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

Accepted answers

All comments

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

AmitojSingh.yxmd

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.

alteryx null option.png

atcodedog05

Using Null() was a neat trick @AmitojSingh 😁

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703