Skiping first line in dataport

JK · 2005-09-28

Hi Gurus,

When importing records from CSV file I need to skip first row (Collumn names).

So I tried to place CurrFile.Read(Variable) OnPreDataItem,

but the text lenght is more than 1024

](*,) :shock: ](*,)

Thanks in advance, 1

Marije_Brummel · 2005-09-28

Please, do not cross-post

http://www.mibuso.com/forum/viewtopic.p ... highlight=

JK · 2005-09-28

Sorry, do not now how to delete .. in this forum

Marije_Brummel · 2005-09-28

I thought a variant was unlimited ??

Or is it also limited to 1024 :?:

JK · 2005-09-28

Variant, .. 1095 .. ,

DenSter · 2005-09-28

Add a dataitem of type integer to your dataport, as the first dataitem, and set the filter on number=1

JK · 2005-09-28

Thanks a lot,

I have tried with integer, but it didnt work.

So i tried:

OnPreDataItem

CurrFile.SEEK(1395)

and it pointed to next line.

\:D/

Marije_Brummel · 2005-09-28

Good thinking!

For the integer option you need to change the recordseparator.

DenSter · 2005-09-28

right, forgot to mention that one

thanks Mark. Not the record separator, but the dataitem separator. By default the record separator is one <new line>, and the dataitem separator is two new lines. You need to change the dataitem separator to one new line, so it jumps to the next dataitem in the dataport.

Marije_Brummel · 2005-09-28

Yes, the dataitem thing. :?

Not realy into dataports fortunalely

JK · 2005-09-28

Hmm ... tested ... doesn`t work integer option.

Have you tested on ver 4.00.

:-k

ovicash · 2005-09-29

JK wrote:

Hi Gurus,

When importing records from CSV file I need to skip first row (Collumn names).

So I tried to place CurrFile.Read(Variable) OnPreDataItem,

but the text lenght is more than 1024

](*,) :shock: ](*,)

Thanks in advance, 1

Hello.
I found this : http://www.mibuso.com/howtoinfo.asp?FileID=8&Type=howto
It is for exporting, but it can give you an ideea what you should do.

Skiping first line in dataport

Answers

Categories