Excel read cell

HI ,
I am new to uipath.

i have an excel contain B column with below value
this is id: 244
I have new id : 323

how can i get only no
want value o/p like 244
323

can you send me the file?

Hi,

under for each activity you can use Regex to find numbers

regards
Aditya

just for learning new senerio i am doing this.

Test of ID: 123
Test the new ID: 456
How to find no. ID: 789

i want output -
123
456
789

try this
read column activity to read a column B
then for each activity
string b= System.Text.RegularExpressions.Regex.Replace(“string_Variable”,"\D","")

It will replace all the characters other than digits and return only digits.

refer to this thread for more

image

System.Text.RegularExpressions.Regex.Replace(“item”,"\D","") i tried this also.

sorry …it is too spoon feeding but i am not getting any o/p .did i missed something

for csv:

Main.xaml (8.1 KB)

hope it will help you

for excel:

Main.xaml (12.7 KB)

Answer.xlsx (9.7 KB)

thanks this is what i was trying.

Yup! Enjoy the training…

u can use write line insted msg box if you want .

1 Like