Excel read cell

Help
1

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

2

can you send me the file?

3

Hi,

under for each activity you can use Regex to find numbers

regards
Aditya

5

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

6

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

7

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

8

for csv:

Main.xaml (8.1 KB)

hope it will help you

for excel:

Main.xaml (12.7 KB)

Answer.xlsx (9.7 KB)

9

thanks this is what i was trying.

10

Yup! Enjoy the training…

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

1 Like