Which regex expression to use in order to be bale to select the second number of AUD?

[mce (Maic Ceriani)]

I want to retrieve the second number that is after the word AUD

150 B AUD 3,3968 3,3982 0,7184 0,7186

So, I want to retrieve 3,3982. Which expression to use?

PS: noted that between the numbers there are space

[supermanPunch (Arpan)]

@mce

150 B AUD 3,3968 3,3982 0,7184 0,7186

Hi @mce ,

You Could try the below Expression :

System.Text.RegularExpressions.Regex.Match(InputString,"(?<=AUD )[\d,.]+\s+([\d,.]+)",System.Text.RegularExpressions.RegexOptions.IgnoreCase).Groups(1).Value.ToString

Here, InputString variable contains the input string data.

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

@mce

Have a look on it->

System.Text.RegularExpressions.Regex.Matches(String_test,"(?<=AUD )[\d\.\,].+")(0).ToString.Split()(1)

[mce (Maic Ceriani)]

thanks for your reply. How to use the System:text.RegularExpressions.Regex.Match?
Im not familiar with this

Thanks in advance for your help.

Rgds,
Maic

[ppr (Peter Preuss)]

have a cheatsheet for regex here:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[mce (Maic Ceriani)]

Not sure I understand how to proceed.
I prefer to use basic Expression. Is that feasible to correct the below expression to only get the 2nd number?

Thanks in advance.

[ppr (Peter Preuss)]

your data looks like csv data so it has a potential to get it solved different.

With regex we can replace the multiple spaces with a discrete column seperator/delimeter character. This cleansed date we can parse as CSV and can continue the processing on datatable level. Can you share some sampe data as text file with us?

[ptrobot]

You could try with this expression:

(?<=AUD [\d,]+\s+)[\d,]+

[mce (Maic Ceriani)]

Thanks it works with the following expression :
(?<=AUD+\s+[\d,]+\s+)[\d,]+