How to remove special characters in excel data table like for one sheet

Help Something Else
2

Hi @sathish_Kumar6

Perform a for each row in excel and then use

currentRow("Columnname") = System.Text.RegularExpressions.Regex.Replace(currentRow("Columnname").ToString,"[^a-zA-Z0-9\s]","")

This will replace all values except the specified which are alphabets numbers and spaces

Cheers

1 Like