How to remove special character from excel column

[Sandhya_Gajare]

I have excel column with column name Candidate name which having value of candidate name but some candidate name come with special charcter how can i romove it

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

System.text.regularexpression.Regex.Replace(yourString, “[^A-Za-z0-9-/]”, “”)

[anon87560229]

Hi UiPath Users ,

Please refer below code
You could remove a specific word like this:
Strings.Repalce(MyWord, MyWordToRemove,“”)

Click to solution if it helps you , let others take advantage

[Sandhya_Gajare]

@sangeethaneelavannan1

System.text.regularexpression.Regex.Replace(yourString, “[^A-Za-z0-9-/]”, “”)

i wanted to remove from clolumn

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Replace inputstring in the code with currentrow(“columnname”).tostring

[Sandhya_Gajare]

@sangeethaneelavannan1

System.text.regularexpression.Regex.Replace(yourString, “[^A-Za-z0-9-/]”, “”)

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

System.text.Regularexpressions.Regex.Replace(yourString, “[^A-Za-z0-9-/]”, “”).Add s in regular expression

[anon87560229]

Please refer this question from forum u will get your ans

link :
How can i Move the Regex data into Excel file plz?

[Sandhya_Gajare]

what?what have add i did not get you

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

System.Text.RegularExpressions.Regex.Replace((currentrow(“columnname”).tostring), “[^A-Za-z0-9-/]”, “”)

[anon87560229]

Hi , USe regex expression in one variable and see above question how to pass regex value in excel ,…

[Sandhya_Gajare]

doing same till getting issue

[Sandhya_Gajare]

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

System.Text.RegularExpressions.Regex.Replace((currentrow(“columnname”).tostring), “[^A-Za-z0-9-/]”, “”)
Copy and paste it ,show me the error

[Manish540 (Manish Shettigar)]

@Sandhya_Gajare , In this below screenshot where ever you have the double quotes right, please remove it and re-add the double quotes.

[pavan_kumar5 (pavan kumar)]

I saw that you are reading data from excel file and using for each row. I have create one xaml file with the matches(Regular Expression). Please place in for loop as it is . It will works as you expected.
Please attached the file as attached. Let me know is it works or not?
Test.xaml (8.3 KB)

[jonathan.traeger]

So if your column name is “Candidate”, and let’s say your excel file is assigned to a variable “File”:
File(“Candidate”).Replace(“listofspecialchars,”")

Remember, you can always toggle a breakpoint in debug mode, go to the Immediate tab, and play around with adjusting the input. prefix with ? to search (as in ?File(“Candidate”) should bring up the candidate name)