Issue parsing delimited data, all the data remains in one field.

[jams1614]

Input file is embedded in a .yxdb that has extra data in the file prior to the comma delimited data. I removed the extra data so the file now has the column names in the first row.  However, it doesn't seem to recognize the delimiter as all the data remains in one field.  I tried text to column and dynamic rename of columns with first row, yet the data is still remains in the first field as one string.

[apathetichell]

can you attach a sample? usually you are parsing the wrong column - wrong delimiter or dynamic rename isnt configured correctly.

[jams1614 · Accepted solution]

Here is a sample, I am thinking the same, there is some extra data at the beginning of the file that removed, after that, I am not seeing my issue.

[binuacs · Accepted solution]

@jams1614 One way of doing this

[TimN · Accepted solution]

Hi,

Here is an approach.