Delet letters from all fields at once

[LaraOli]

Hi Guys,

Hope you can help me out with this issue I am struggling with. 
I am new to Alteryx so maybe the solution is simple. 

I have this CSV file as input and it is extracted from SQL. 

And as you can see, there is a "*$ in front and after all records.

How can I delet all the  "*$ ? 

I've already tried 3 things:

- Switch the delimiters from ";" to "," but it didn't work well.

- Along with that, I have also tried the options of ignore delimiters in "quotes", "auto" and "single quotes", but only "none" works well importing the file without any problem and with all the fields I need.

- And I tried to use the Multi-Field Formula tool but as all the file is formatted as string, the " sign doesn't let me write the formula.

So now I have to find a way to delet the "*$ in all the fields. 

Do you have any ideas?

[kcgreen]

I think this will work in the Multi-Field Formula:

REGEX_Replace([_CurrentField_], '\"\*\$', Null())

[MarqueeCrew · Accepted solution]

@LaraOli,

Using a Multi-Field Formula (select desired incoming TEXT fields):

TrimRight(TrimLeft([_CurrentField_],'"*$'),'"*$')

This will remove the beginning and ending unwanted punctuation while leaving other punctuation in tact.  You can change the output type from "String" to a number if you so desire.  You'll also want to UNCHECK the "copy output fields" option to overwrite the existing variables.

Cheers,

Mark