Best way to remove the Header from a CSV file.

David_Singleton

Just wondering what you guys prefer to do this.

I have "pseudo" csv file, that has the column names as headers. Currently I have a working dataport if I remove the headers manually. So I don't really want to rewrite the whole thing in code.

Option 1/ and the most obvious solution is just to have the user manually delete the header, the problem is that the file has a .CSV extension, so at some stage they are going to double click it, open it in excel, delete the first row, save it (some how) and then ruin the file. So option one out.

The other four options are

2/ My preferred option would be to convert the file to XML and be done with this horrid antiquated CSV nonsense.

3/ Hack the Dataport with an additional dataitem, and change the <<NewLine><NewLine>> itme seperator to something that is constant at the end of the header line.

4/ Read the file in CAL and rewrite back without the header.

5/ Call an external script to do it.

So out of curiosity what do most people prefer.

Savatage

For CSV files with headers - I use the Kriki's old skip headers.
viewtopic.php?f=5&t=10564

BernardJ

i like this one:

kriki wrote:

viewtopic.php?f=5&t=10564

Although with the proviso that whenever possible data exchange by means of xml is preferred

Savatage

That's two votes for the Header Skip!

BernardJ

and rightly so, I would say

kine

Easier... if you are sure, that the first line is not longer than 1024 bytes...

----OnPreDataport
var
  Line: Text1024;
if CurrDataport.IMPORT then begin
  CurrFile.TEXTMODE := true;
  CurrFile.READ(Line);
  CurrFile.TEXTMODE := false;
end;

David_Singleton

Savatage wrote:

That's two votes for the Header Skip!

I will give it the third vote.

Done and working...