Regex count spaces after a comma (if there is one)

[adrian_sullivan]

hi all,

i am working on a project where i am using regex to extract data from text files and then writing that value to a datatable

i can work with the data if there is no comma, or if there are 2 or more digits after the comma

i have an issue though if the data i am extracting has only one digit after a comma

the value is coming out as 1273 but it should be 1273.5

ideally i would like to count the number of comma’s (if any) in the string and then write a switch based on what should happen then
no comma eg 123 report 123
1 comma eg 321.6 report 321.6 or 321.60 just not 321 as is currently being reported
2 or more commas eg 568.8765432 report 568.87

the work flow is attached, along with a few text files that i used as well

any help greatly appreciated
Main.xaml (27.1 KB)

Text file 3.txt (31 Bytes)
Text file 4.txt (80 Bytes)
Text file 5.txt (75 Bytes)
Text file 1.txt (72 Bytes)
Text file 2.txt (73 Bytes)

[postwick (Paul Ostwick)]

Just write a RegEx expression that takes only digits and comma.

^[-,0-9]+$

.net - Matching numbers with regular expressions — only digits and commas - Stack Overflow.

[ppr (Peter Preuss)]

It looks like the value parsing of number in French close culture is needed
e.g. Valeur Liquidative (VL) : 1 273,5 ( USD) as space is used as a group seperator

in general we can do it by

And can also reformat e.g. like

For catching the number we can use Regex and also extend it. Just a starter partern focussing on French Formats

\d[\d ]*[,\d]*
For sure we can tune and adapt the pattern

[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…

[adrian_sullivan]

Will give that a try and get back to you.

Thanks

[ppr (Peter Preuss)]

@ppr

It looks like the value parsing of number in French close culture is needed

@ppr

\d[\d ]*[,\d]*
For sure we can tune and adapt the pattern

in certain scenarios we were also able to reduce the complexity by removing spaces then we can reduce the complexity of the regex to

and parse like

[Steven_McKeering]

Hey @adrian_sullivan

Take a look here:
AS-19.01.24.zip (15.5 KB)

Results

Regex Pattern used:

.NET Regex Tester - Regex Storm

Note results added to table have spaces removed and commas replaced with .

Hopefully this helps,

Cheers

Steve

[mkankatala (Mahesh Kankatala)]

Hi @adrian_sullivan

Check out the below workflow file:
Sequence22.xaml (13.6 KB)
Workflow:

Output:

RegExr: Learn, Build, & Test RegEx

Happy to help if further clarifications needed.

Regards

[adrian_sullivan]

hi Steve,

thanks fo the help. tried this and it worked ok. i did have to make one minor change. i had to add an if statment to see if a value was left blank. if it was blank i put in a value like N\A just so as it would be reported on.

Adrian

[Steven_McKeering]

Hey

Oops, I missed the blank values.

Great to hear you have a working solution.

Cheers

Steve