Hi all,
recently I had have to import a text file ( row are separated by TAB and each column by a space) into a new database.
Here i will try to give example:
this is how the text file looks
LUA 25.614397 43.06958 261 0 1 7 0 57:51.8 0
LUS 25.614397 43.06958 261 0 1 7 0 57:51.8 -1 400 284 5
SEI 25.614397 43.06958 261 0 1 7 0 57:51.8 1
CHI 25.614397 43.06958 261 0 1 7 0 57:51.8 12 1 10638 176194 400 3 320 5 640 2 640 -1 -1 -1 -1 1
NLIST 25.614397 43.06958 261 0 1 7 0 57:51.8 0 0
RRCD 25.614397 43.06958 261 0 1 7 0 57:53.8 CCCH event 30 EF 36 0 10 12 E5 8 5 1 90 0 8 87 18 7 83 3 49 D3 E0 4 F8 6A 10 0 14 21 67 F4 50 B1 E6 0A 42 67 4F 88 13 E3 A8 C0 0 51 89 9F D1 42 C7 98 29 9 9D 3E 41 4F 96 A5 0 5 4A 36 7F 45 0B 1E 60 A4 26 74 F9 85 3E 7A 9C 0 15 32 0 1 81 E3 43 3C 0F 80 24 2 2B B3 66 9 F0 2 40 22 3B 37 5C A4 82 F0 51 4D 9 A7 F8 2 19 5A 85 40 40 FC 1 20 51 0
This is how values must be imported:
Column1 Col2 Col3 Col4 Col5
LUA 25.614397 43.06958 261 0
Could you give me a clue how this could be done?
thank you in advance,
milenio
