deleting 1st Row before inporting data from CSV file

brijleo

Hi,

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


thank!

kapamarou

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

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

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

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