Excel automation method

[Abubakkar (vnrabu)]

Dear experts,

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

[AshwinS2 (Ashwin S)]

Hi @Abubakkar

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

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

Thanks
Ashwin.S

[Abubakkar (vnrabu)]

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

[AshwinS2 (Ashwin S)]

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}

[Abubakkar (vnrabu)]

Main.xaml (8.6 KB)

Can you help me where can I mistake it?

[AshwinS2 (Ashwin S)]

Hi @Abubakkar

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

Thanks
Ashwin S

[Palaniyappan (Forum Leader)]

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

hope this would help you
Cheers @Abubakkar

[Abubakkar (vnrabu)]

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

[Palaniyappan (Forum Leader)]

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

[Abubakkar (vnrabu)]

Thanks for the help @Palaniyappan

[Palaniyappan (Forum Leader)]

No worries
Cheers @Abubakkar