Removing double quotes "" from a CSV file using ALTERYX

[AmitojSingh]

Hi Everyone 

I have a csv file which looks similar to the following format

employeeID, businessDate, categoryName, employeeType

24414,2021-07-01,"",Permanent

67674,2021-03-15,"",Temporary

I was to remove the "" from this file using ALTERYX, and set the output to following

employeeID, businessDate, categoryName, employeeType

24414,2021-07-01,,Permanent

67674,2021-03-15,,Temporary

can you please help

[Shifty]

Hey @AmitojSingh 

You can use the Data Cleasing tool

Select the field with the "" (categoryName) and check "Punctuation" in the configuration window:

Hope this helps!

[TheOC]

hi @AmitojSingh !

The key to this one is the regex tool:

We can specify the text we want to replace in the "Format to Convert" Field, and then leave the Replacement text blank, to remove them.

I have attached a workflow that does this to the data you have provided!

Hope this helps,
TheOC

[BosKev]

can use formula replace as well

[vizAlter]

Hi @AmitojSingh — Try this solution:

(,"")

$$,

Please mark this solved if it helps.

(FYI — You can use \0 as a delimiter in the Input tool to ignore the delimiter and bring your data in one single column, then add a RegEx tool to perform the step above.)

[AmitojSingh]

Hi Everyone, I ended up using Null() in the formula tool and that got ride of the ""  for me.

[atcodedog05]

Using Null() was a neat trick @AmitojSingh 😁

[AdamR_AYX]

One more option with this one is to write out the csv file with the "Quote Output Fields" option set to "Never"

Example attached