Hi
I have a problem which I am struggling to get over...
I have a text file which has rows of data, the rows are tab delimitted, and there are many more cols than I need to get out and put into my db.
I need to be able to read each line of the file, then just extract the data i need and put this into my table.
The main question is how; if I have a line with let's say 5 cols:
id
name
blank
blank
title
How do I read each line, skip over the two blank cols and just get the id, name and title. And then read each line until finished.
This is a little more complex than I thought...
Anyone help?
Regards
D
I have a problem which I am struggling to get over...
I have a text file which has rows of data, the rows are tab delimitted, and there are many more cols than I need to get out and put into my db.
I need to be able to read each line of the file, then just extract the data i need and put this into my table.
The main question is how; if I have a line with let's say 5 cols:
id
name
blank
blank
title
How do I read each line, skip over the two blank cols and just get the id, name and title. And then read each line until finished.
This is a little more complex than I thought...
Anyone help?
Regards
D