I have a *.txt file. And the data format is like below :
Guest|Orient| |HMI1|0|-480|
Guest2|Orient2| |HMI1|0|-480|
It will not format correctly when I preview the data. Already try all row delimiter-CRLF,CR,LF,;,:,tab,|.
Need advice. Thanks
Asked
Active
Viewed 794 times
0
user2286756
- 211
- 1
- 2
- 11
-
Under `Columns` in Column Delimiter put `Vertical Bar {|}`. Row delimiter should stay as it is (newline sign). If you put | as Row delimiter, you get new row for each | in the file. – makciook Jul 18 '13 at 08:15
-
yes.. i already put | for column. BUT dont know what to put for ROW delimiter. Cause it is not working fine when I preview it. – user2286756 Jul 19 '13 at 08:36