Help cleaning Alteryx output when source data is an excel table

[andreahq]

Hello,

I have a data input which is and excel table. When I loaded to Alteryx, my strings in the output get changed and now start with a " ' ". The other fields (double and date are fine) How can I fix this? I tried cleaning leading spaces when I first load the file but it didn't work.

Example of my issue below:

Input:

Output:

Column 1	Column 2	Column 3	Column 4
'A	1	1/1/2001	'F
'B	2	1/2/2002	'G

Thanks

[RSreeSurya]

Can you share the file you are using as input? to try running from my end 

[andreahq]

Here is an example of the input file and what the output file looks like after loading to Alteryx. The only action I did was input and output

[RSreeSurya · Accepted solution]

This looks interesting. As per below article, it explains that, Alteryx by default adds ' symbol before the string (text) fields. This is only for xls files.

Please have a look. Using VBA was suggested in the below article. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Issue-with-xls-having-a-single...