Removing "" from entire dataset

Hi,

Is there any way to remove "" from all the records at once? I imported .txt file using \0 delimiter and so the quotes came in as well.

StripQuotes works but I have 100+ fields in my data set. I would have to do it all one by one.

Data Cleansing won't work because I want to keep all other punctuation in my data.

Please help!

Thanks

Accepted answers

Blake

@rajputakansha @bpatel @DiegoParker

Alteryx is great because we can all solve the same problem in different ways. I think in this case it is best to keep it simple.

If you look at performance profiling for a problem like this, the crosstab along can take up to 4x longer to run than the multifield formula.

If you want to only remove the quotes from each end of the field, you can use stripquotes([current_field]) in the multirow formula instead of the replace function.

All comments

Blake

Use a multi-field formula just like you would a regular formula but point it at "current_field" and select all fields.

Good luck!

DiegoParker

What about using transpose, strip quotes and then crosstab back?

rajputakansha

Hi @Blake ,

Thanks for your solution.

Can you help me configure the tool?

I haven't used this tool much.

Thanks

bpatel

Hi @rajputakansha

originally i suggested the data cleansing tool, did not see your comment about it. i would suggest what @DiegoParker recommended

rajputakansha

Hi @DiegoParker ,@Bpatel,

Thanks for replying.

I tried that. For some reason, it's not removing all the "" from the column.

Do you why this is happening or if you have any other solution for the problem?

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703