Quotes

[murali_potnuri]

Hi

I have number in Excel cell like this 88451619454’ I want to remove that single quote from that number how can I do that

[ppr (Peter)]

@murali_potnuri

88451619454’ I

One of many Options:

Assign Activity:
strCleansed = System.Text.RegularExpressions.Regex.Replace(YourOrigStringVar,"\D","")

[Jithesh_R]

Hii @murali_potnuri ,

Give atry to this.

NumberVariable= Split(YourCurrentrowexcelvalue,“’”)(0)

Regards,

[Anil_G]

@murali_potnuri

You can use a replace

Str.Replace("’","")

Use this in a loop and instead of str use currentrow("columnname").ToString and assign it to currentrow("columnName")

Cheers