Please provide the regex for the following

Hi,

Please provide the regex for the following strings:-
2,406,289,170.66
1,903,143,785.05
503,145,385.61

digits are separated as \d\d\d,\d\d\d,\d\d\d.\d\d format
(folloing the US numeric format for amount)

Regex must satisfy even if few more digits are added.(including COMA)
@hacky

@HareeshMR Buddy please help

Sure @hacky,

Have you tried this \d.+

1 Like

Here is the workflow which will return you the text with the format also

GetDates.xaml (5.6 KB)

1 Like

Exactly :point_up:
image

@HareeshMR,

I tried and updated your code with my string:- it is in the undesirable format,

GetDates.xaml (6.2 KB)

Please refer my question for more updates: Splitting the string array into array characters. (not as simple as it seems) - #2 by Shubham_Varshney

@Pablito Please help with the attached question.

I want the following format to be satisfied:-
Data%20Extraction

(\d+,?)+\d+.\d{2} will work with smaller numbers such as 12.61 (for example)

If you only want the big numbers, leave the ? out

Try this @hacky

(\d+,?){4}…