Import dataport and skipping the header line

kriki · 2006-03-16

Problem:you have a textfile with headers and you must import it with a dataport, but you want to skip the header line, because otherwise you get an error. How to do that?

Put some code in trigger "OnPreDataItem()":
(variable "cha" is CHAR)

IF CurrDataport.IMPORT THEN BEGIN
  REPEAT
    CurrFile.READ(cha);
  UNTIL cha = 10; // of course in case the RecordSeparator is "<<NewLine>>"
END;

kriki · 2006-03-21

And for more than 1 line:

IF CurrDataport.IMPORT THEN BEGIN
  LintLinesToRead := 2; // lines that must be read (this is an integer)
  REPEAT
    CurrFile.READ(cha);
    IF cha = 10 THEN
      LintLinesToRead -= 1;
  UNTIL LintLinesToRead = 0;
END;

gulamdastagir · 2008-06-20

I get an error "File is not open" at Currfile.Read(cha) part of the code.

i dont want to hardocode the filepath but when the "user" slects the "csv"file from the options tab

iam using 4.0(SP3)

Thanks

Savatage · 2008-06-20

are you sure the code is on PreDataItem not PreDataPort?

(variable "cha" is TYPE CHAR)

gulamdastagir · 2008-06-20

thanks savatage #-o

colingbradley · 2011-05-30

I am missing the logic for the Until cha = 10;
Is 10 the expected number of records?

kriki · 2011-05-31

No, the 10 is the ASCII value of the line feed.

A newline in a textfile is defined by 2 chars : CR/LF = Carriage Return + Line Feed = ASCII 13 + ASCII 10.

So I am reading char per char until I find ASCII value = 10. When I have found it, I know I am at the end-of-line.