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
ashley11
(Ashley Nihal Dcunha)
April 21, 2020, 9:50am
2
use this regular exprssion …
1 Like
ashley11
(Ashley Nihal Dcunha)
April 21, 2020, 9:54am
3
Temp.zip (13.0 KB)
hope this xaml would be of help
Shivaraju
(UipathLearner)
April 21, 2020, 10:03am
4
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”
ashley11
(Ashley Nihal Dcunha)
April 21, 2020, 11:24am
6
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”