deleting 1st Row before inporting data from CSV file

brijleo · 2008-09-22

Hi,

I am importing data form .csv file, but before importing data i have delete 1st row which contain header row automatically.

thank!

kapamarou · 2008-09-22

I suppose that you could use a counter and do a CurrDataport.SKIP but the problem is that all your headers are "TEXT" and you'll get errors when the field is of different type. I wouldn't do it if I were you, but if you really need it, declare Text Variables for all your columns and do a skip on the first row. Then you'll need to manually EVALUATE / VALIDATE the values in the record fields...

kine · 2008-09-22

Or you can use

CurrFile.READ(MyVariable);

In OnPreDataItem or OnPreDataport when mode is Import to skip the first line (it will read the line and the import will continue on next line). 8)

kriki · 2008-09-22

kine wrote:
Or you can use
CurrFile.READ(MyVariable);
In OnPreDataItem or OnPreDataport when mode is Import to skip the first line (it will read the line and the import will continue on next line). 8)

And "MyVariable" is of type Text1024.

Savatage · 2008-09-22

Here's an explanation that I used from Tips N Trick Forum.

It allows you to skip the first line (or multiple lines if needed)
viewtopic.php?f=5&t=10564

deleting 1st Row before inporting data from CSV file

Comments

Categories