Update datatable column based on condition without iteration

Help Studio
1

Hi,

Two of my datatable columns contain phone numbers. I want to append ’ (apostrophe) infront of all phone numbers which start with +.

Is it possible to do same without iteration?

Thanks!

2

Hi @Kapil

Welcome to UiPath community

You can try with regex expression

System.Text.RegularExpressions.Regex.Replace(YourInput_Phonenumber,"(?=\+)","'")

image
image457×753 12 KB

3

Hi @Gokul001 ,

Thanks for your suggestion. Will above approach make required updates in all applicable rows of phone number columns? I don’t want to use iteration for this update.

Thanks!

4

Hi @Kapil

Try this expression in Invoke VBA activity

dt.AsEnumerable.ToList.ForEach(Sub(x) x("phone number") = System.Text.RegularExpressions.Regex.Replace(YourInput_Phonenumber,"(?=\+)","'").ToString.trim)

Regards
Gokul