Generate Datatable from text file separating each column as excel separator

Help Forum
1

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

2

Hi,

Can you share your input file?

Regards,

1 Like
3

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

4

Hi,

How about the following?

img20211222-4
img20211222-4456×556 10.6 KB

Sample20211222-2.zip (2.4 KB)

Regards,

1 Like
5

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

6

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
7

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

8

So each had two double qoutes

9

Hi,

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

Regards,

1 Like
10

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