Remove special characters

[swapsingh2712]

Hello All,

I've a analytical app which is taking the input from the user. Here's the sample data

Test ID	Test Name	Sample Size
121	My-Test_1	100
122	My-test 2@	70
123	sample-test	40

As you see for test ID 122 there's a special character which I need to remove using alteryx. My workflow should remove special characters from the start and end of the test name (Ltrim and Rtrim), but it should not remove the characters like  '-', or space.

Please advise.

[ShankerV]

Hi @swapsingh2712 

Can I consider _ as special character or keep in the output.

Many thanks

Shanker V

[ShankerV]

Hi @swapsingh2712 

Solution:

The below will eliminate the @ and any other from the incoming string.

REGEX_Replace([Test Name], "[^a-zA-Z0-9 -]", '')

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

[binuacs]

@swapsingh2712 you can also use the function ReplaceChar()

ReplaceChar([Test Name],’@?!_‘.’’)