Remove special characters from a sentence

[KrishnaChithrathil]

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

[DataNath]

@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?

[grazitti_sapna · Accepted solution]

@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]

@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.

[KrishnaChithrathil]

@grazitti_sapna 

Perfect. Thanks.

It'll take all the possible special characters, right?

[binuacs · Accepted solution]

@KrishnaChithrathil one way of doing this

[grazitti_sapna]

@KrishnaChithrathil, it will work for punctuations can try all the possible special characters to test if it is working or not but according to me it should take out all special characters.

Thanks!

[KrishnaChithrathil]

People who're looking into this topic, solution provided by @binuacs also works perfectly. I can take only one as the solution to my topic. 

Thanks.

[grazitti_sapna]

@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.

Thanks!