Replacing Multiple Special Character
Hello Experts,
I have a source column (Emp_name) where many special character are there in name ,want to remove all the special characters.
Tried using replace and replaceAll but i didn’t find a ...
Forum Discussion
@Andrej_Bogdanovski Thank you very much.
However i have done these in another way ,may be it will help you ,so know we know 2 ways to do these
- $Name.replace(/[^a-zA-z]/g,“”).
- $Name.replaceAll(‘!’,‘’).replaceAll(‘@’,‘’).replaceAll(‘#’,‘’).replaceAll(‘$’,‘’).replaceAll(‘%’,‘’).replaceAll(‘^’,‘’).replaceAll(‘&’,‘’).replaceAll(‘*’,‘’)
Hope these help us.
Again thank you for your solution.
Note that this will replace numbers as well. If you want to keep the numbers, you can modify the expression to something like the following:
$Name.replace(/[^a-zA-Z0-9]/g, '')
