Column delimiter

Hi,
I have a problem with column delimiter of a txt file.


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)

1 Like

Hi @Shiva123

You were going in the right direction! Enable the Support short data rows option with delimiter \t
Why this is required? No clue but it works :laughing:

4 Likes

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.

3 Likes

Hi @ArjenEX and @bruno29a
Ohh :see_no_evil:
Thank you very much!
Greetings,
Shiva

2 Likes