Replace commas in a CSV file with a blank

Hello amazing people at Alteryx community,

I have a CSV file data that looks like this.

If an trying to use the Text to Columns tool in the Parse tool palette to split this based on the comma (,) delimiter. However, upon close observation, we can see that some companies that have Inc, LLC have a comma in between them. How do I prevent Alteryx from splitting the company name?

Any help on this is much appreciated.

Parse

Accepted answers

murthybhs

Thank you for the reply @EstherB47 and @MarqueeCrew. I was able to achieve this by using the Find Replace tool. I used " , INC " in the Find and "INC"
in the replace portion.

All comments

estherb47

Hi @murthybhs

I'd take a two-step approach to this challenge.

First, use a text to columns with a comma delimiter, but separate into two columns only. That will get the name out.

Then you can use a RegEx tool to separate the rest.
Use the parse method on the second column (the one that now starts with the company name), with the following expression:

(.+),(\d+),(\d+)