Hi All,
I am obtaining a number from a cell but sometimes other characters are added as per below:
How would I check each character to confirm it is non-numeric and remove?
OR
How would I check the first character of the string to confirm its non-numeric and remove?
@chend
Just to confirm are you trying to remove “-” this in String. In that case you can use replace activity to replace it to null.
Or you can convert that complete string to double " Convert.ToDouble(yourstring)", so that it will still show as a numeric value.
To check whether string is numeric or not “Microsoft.VisualBasic.Information.IsNumeric(yourstring.ToString)”
Hi Hemanth,
I want to keep the “-” as it is a negative amount.
As the string contains “=”, I am unable to convert to double as it does not recognise as a number format.
I am trying to remove the “=” but the person filling the cell could place any non-numeric characters.
@chend
Use Replace Activity and use below Regex Pattern.
As you said “I am trying to remove the “=” but the person filling the cell could place any non-numeric characters.”. So you have to remove all non numeric characters.
Regex Pattern : [a-z\s_:;'/="]+
If you don’t want to remove alphabets, then use like below
Regex Pattern : [\s_:;'/="]+
Input- String Variable
Regex Option : (IgnoreCase, Compiled)
Regards,
Mahesh
Hi Mahesh,
This is great.
So if I assign Cell = ?-123D123
NewCell = System.Text.RegularExpressions.Regex.Replace(Cell,“\D”,“”)
This provides the outocme NewCell = 123123
Is it possible to keep the “-”
So it will result NewCell = -123123
Hi Mahesh1,
UIpath did not accept this expression as it provides a compiling error.
Regards,
Darren
You to to give pattern within double coats
“[^\d-.]”
Regards,
Mahesh
@chend
you have not assigned any value to the result field. Please once assign the value and let me know whether it is working or not.
Regards,
Mahesh
