Delimiter ";" doesn't split columns corrected

I have a set of data of about 6~7 millions lines, and I can't set it correct, when adding the file to Alteryx it correct be distributed on each field.

Every field is between quotation marks ("Data1") and delimited by semicolons (;), but some fields has semicolons between the field eg; ("0,0225200";"JÉSSICA SANTOS";"32877077870") or ("DUQUE DE CAXIAS";"AV; NILO PECANHA";"1642").

Every time I try to import, it make some of the rows be like null.

Thanks in advance.

Sample Kardex.txt

Regex

Transformation

Accepted answers

All comments

BrandonB

It would appear that the sample file you attached read in correctly. Does this not look as you would expect?

BrandonB

The #9 option in the configuration window allows you to ignore delimiters in quotes which should take care of your issue.

pedrodrfaria

Hi @felipemorselli

The sample you provided seems to be assigning the correct fields under the correct columns.

You can change the option in the Data Input to ignore delimiters inside of quotes, single quotes or automatically.

Pedro.

felipemorselli

Well, the thing is well I Run the script it goes wrong, it doesn't split the fields correctly as the image shows.

I'm setting the file as that:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703