Importing TXT delimited by comma with quotes & commas in data

[MasoB]

UPDATE: Please see my updated example below

Hi,

I am trying to create a workflow to prep data. My data looks like this and does not contain field names:

I typically input into Access and then fix each error manually. Is there any way to buid a workflow that can process this data? The quotations and commas are causing issues.

Thank you in advance.

[Luke_C]

Hi @MasoB 

I input this as a text file and it seems to process correctly, see below. You can then use a data cleanse to remove trailing spaces and select tool to rename columns. 

[MasoB]

Sorry, my example was a bad representation. I guess the issue only happens when the data ends or starts with a ".  I will make a corrected post.

[MasoB]

See corrected example. This is what happens when I run it through delimited with , :