Can we remove all the special characters from a sentence. ?
This is my input. (We can't expect a fixed set of special characters. Any thing can occur in between the sentence.)
This is my expected output
@KrishnaChithrathil, give this a try.
and if you are just looking to remove the punctuations then use data cleansing tool with the following configuration.
Thanks!
@KrishnaChithrathil one way of doing this
@KrishnaChithrathil I’m a little confused as the title just says remove special characters, but your expected outcome you’ve also removed valid letters - do you just want the first word up until a special character?
@DataNath
Oops. My bad. take the first word until I see a special character. that's the correct scenario.
The example which i've provided is random data. I'm expecting any special character including a space in the client requirement.
@grazitti_sapna
Perfect. Thanks.
It'll take all the possible special characters, right?
People who're looking into this topic, solution provided by @binu_acs also works perfectly. I can take only one as the solution to my topic.
Thanks.
@KrishnaChithrathil, you can mark multiple posts as solutions if they work for you. There is no restriction to that.
Thanks for marking my post as a solution, glad I could help.
