When I open the txt file in the file reader, the column delimiter is not recognized (see left image). Normally the table should look like on the right. I tried it with the delimiter \t but without success. How do I find the correct column delimiter?
I have uploaded the txt file (Pos.txt).
Thanks for your help!
Many greetings,
Shiva Pos.txt (1.1 KB)
This is what the Description shows: Support short data rows Select this box if some rows may be shorter than others (filled with missing values).
I think it tries to guess that the delimiter could be part of the data when it sees that most of the data is empty for certain columns, which it is in this case.