Importing TXT delimited by comma with quotes & commas in data

Question

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.

EXAMPLE.txt

MasoB · Answer

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

EXAMPLE UPDATED.txt

MasoB · Answer

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.

Luke_C · Answer

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.