Excel automation method

Help
1

Dear experts,

Untitled
Untitled819×533 47.6 KB

1.) I need only number in A column so cut that number then past it “B” column

2.) In"C" column only valid for 10 digit mobile number is valid other than that the number is invalid. I will write the output in “D” column.
Is valid or invalid?

Could you help me please

1 Like
2

Hi @Abubakkar

Assign string variable to row(“Name”). ToString

Use matches activity
\d - regex expression
Use matches activity
\d{10}.*

Thanks
Ashwin.S

2 Likes
3

Sorry I didn’t understand.
Can you give me example please.
How can I use matches activity?

1
11366×768 39.2 KB
2
21366×768 54.3 KB

1 Like
4

Hi @Abubakkar

pass the var1 in the input and print the item based on type argument as System.Text.RegularExpressions.match
and give the expression as \d{4}

5

Main.xaml (8.6 KB)

Can you help me where can I mistake it?

1 Like
6

Hi @Abubakkar

Pass the data datatable to read range and write range instead of var1

Thanks
Ashwin S

1 Like
7

Here you go
its resolved
abhu.zip (18.1 KB)

hope this would help you
Cheers @Abubakkar

1 Like
8

Thanks @Palaniyappan.
It’s working fine now.
Is there any other easy method ?

1 Like
9

This was the one that came to my mind at first to get this done
Hope it didn’t come out with any issue
Maybe we can try with LINQ query but as it has some regex matches to be done, I though this would be very simple and precise rather to make it complicated with other methods

Cheers @Abubakkar

1 Like
10

Thanks for the help @Palaniyappan

1 Like
11

No worries
Cheers @Abubakkar

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.