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!
You were going in the right direction! Enable the Support short data rows option with delimiter
Why this is required? No clue but it works
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.
Hi @ArjenEX and @bruno29a
Thank you very much!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.