Remove certain characters

[LexiC]

How can I remove certain characters from my data but keep everything else?

I need to remove | and * and keep the numbers and letters. 

Ex. 

I * A 245

I need just A 245

[gautiergodard]

Hey @LexiC 

If there is a set list of characters that you will always want to remove, you could create a static table with those character using an Alteryx text tool, and then using the "find and replace" to make the changes.

Another route, could be to leverage replace() formulas.

[TimN]

Here is one way with ReplacChar function

[Raj]

for such scenario you can use data cleansing tool and select the punctuation, and this will deliver the required output.

[Cyloptix]

I agree with @gautiergodard, 

You can create a static table in Alteryx by using the Input Data tool. Once this is completed, you can apply the find and replace data with this table. The pros of doing it this way means that you only have one static table that can continue growing based on what characters you're looking for. 

You may add to the table or remove from it as much as you want and it all stays within Alteryx. Bested of luck OP o7