I have a string column and I am trying to replace some words from that string column.
â€œ @_CCarter: Cent line 6pm-7pm. Only time one can irritate me and get away with itâ€ wow
I want to remove corrupting characters like â€œ , â€ etc.
Output for this would be:
@_CCarter: Cent line 6pm-7pm. Only time one can irritate me and get away with it wow
I have a file wherein I have a list of all such characters and replacements for it.
I am trying to use Cell Replacer but I think that this node is trying to compare the entire sentence and hence not working. String Replacer works but the list is long so I can’t have hundreds of string replacers. I tried String Replace (Dictionary) but that isn’t working properly.