Dataport Import csv file

IvonaK

Hi to all,

I have to make a Dataport for import a csv file(The scv file have coma delimiter and file format is variable). I have csv file like this picture. I need just the last 10 fields.

How I can skip the first row, and the first 13 fileds of each row?

Any advice,
Thanks a lot,
Ivona Kuzmanovska,

neilgf

Hi

Skipping the first line is easy using something like 'IF PostingDate='Posting Date' THEN CurrDataport.SKIP; // ignore first line if titles.'
In terms of your csv file structure and ignoring some column headings it would be easier to load in csv data into global variables and then including some code in OnAfterImportRecord'.
Hope this helps.
Neil

IvonaK

Ok.

Thanks a lot. I resolve

Best Regards,

Wisa123

For "ignoring" columns i usually just include some Dummy-Columns I dont use after they are filled. Faster to do so and you have to read the whole file anyway.

IvonaK

Thanks
Best Regards,