Extract between two values

Hi,

Please help me in this,

I have a string as “Net income (loss) for income tax purposes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3,672,851 A”

need to extract only values : 3,672,851

Thanks

image
use this regular exprssion …

1 Like

Temp.zip (13.0 KB)
hope this xaml would be of help

Hi @Sharanabasava_Kallur

You can try this
System.Text.RegularExpressions.Regex.Matches(inputstring,“[0-9]\d*(.[0-9]\d+)?”)(0).ToString

Hi,

Thanks, but for the some of the value is not there, how need to check value is there or not
for example:
“Net capital losses deducted in the year (enter as a positive amount) . . . . . . . . . . . . . . . . . . . . . . a”

Temp.zip (13.5 KB)
check this you had to add if bock

Val1 = “Subtotal (amount A minus amount B; if positive, enter “0”) C”

some of the value is not there, how need to check value is there or not

after this enter “0” there is a blank and in the last it is “C”