Generate Datatable from text file separating each column as excel separator

Hi devs, pls how do we generate dt from text so the final output looks like
image

Hi,

Can you share your input file?

Regards,

1 Like

Sample input format wit column and row - “ID”“TEAM”“COUNTRY”“NAME”
"1"“OSCAR”“USA”“BEN”

Hi,

How about the following?

Sample20211222-2.zip (2.4 KB)

Regards,

1 Like

EXcepyion occurred - Generate Data Table: A column named ’ ’ already belongs to this DataTable.

Hi,

For now, can you try to turn off UseColumnHeader of GenerateDataTable?

And/or can you shaer your date as a file?

Regards,

1 Like

Hi Yoichi, the text file looked like this: with 2 double quotes each
““ID”” ““TEAM”” ““COUNTRY”” ““NAME””
““1"” ““OSCAR”””“USA”""“BEN”"

So each had two double qoutes

Hi,

Can you share your text as a file?
We need accurate data.

Regards,

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.