How to remove certain word from a string

[Vidu_Senanayake]

Hi you can use a Assign inside a for each and assign the
CurrentRow(“Column”)=System.Text.RegularExpressions.Regex.Replace(CurrentRow(“Name”).ToString, “[,]{0,1}Not Correct[,]{0,1}”, “”).Trim

RemoveSpecialCharacters.xaml (9.9 KB)