Sequence.xaml (6.8 KB)
assuming txt = "GRAND TOTAL (I + II + III);470,957,563;57,606,092;413,351,471;409,692,987;GRAND TOTAL (I + II + III + IV + V);413,351,471;409,692,987"
assign system.Text.RegularExpressions.Regex.Matches(txt, "([\d]+)") to regexCollection variable
So this method will only work if I want to do so on all the rows I have. However, I only want to retrieve data from this row only, so I think Regex is a possible solution, but I’m facing an issue while doing so
Thank you for your reply. I tried this regex but it returns the all the numbers in the file. What I want is this line and the highlighted part only in the image.
So if we are using Regex it would be something like (?<=GRAND TOTAL) then skip the fist two variables between ;470,957,563;57,606,092; and return the last two 413,351,471 409,692,987