Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

johny9887
7 - Meteor

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 

 

johny9887_0-1665770762716.png

 

2 REPLIES 2
gautiergodard
13 - Pulsar

Hello @johny9887 

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

Felipe_Ribeir0
16 - Nebula

Hi @johny9887 

 

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

 

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

 

Felipe_Ribeir0_1-1665772118586.png

 

Felipe_Ribeir0_0-1665772101382.png

 

Labels