How to get rid of quotations ("") in string resulting from using text to columns feature

[johny9887]

Hi,

Due to the "too many fields in record #10" error when loading in the file, I have decided to use delimiter \0 when inputting the file and have used text to columns option to import the file in - the workflow is shown below. As a result, I have 2 columns, Name and Value as seen below. Is there a way to get rid of the quotation marks in the Name column? I have tried to use stripquotes, trim options which results in errors.

Thank you 

[gautiergodard]

Hello @johny9887 

You can use the remove punctuation option in the data cleansing tool!

[Felipe_Ribeir0 · Accepted solution]

Hi @johny9887 

The method that would consume less resources of your machine would be to use the formula tool, like this:

Replace([Name], '"', '')