Append From but skip 1st row 1

[xenology]

I have my table structure with column names I use. I want to import (Append From) a tab delimited text file but the text file has their column names in the first row. Is there a way to tell

Append From file.txt For "Recno() <> 1" Delimited With Tab ?

TIA!
~xeno

 

[DSummZZZ]

Try using something like APPEND FROM whatever FOR field1 # 'Header'

If that don't work, just append from, then delete the first record. You can then PACK it if you wish.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[bborissov]

#define CRLF CHR(13)+CHR(10)
lcFile = FILETOSTR("YourFile.TXT")
lcFileName = SYS(2015)+[.TXT]
STRTOFILE(SUBSTR(lcFile,AT(CRLF, clFile)+2),lcFileName)
APPEND FROM (lcFileName) DELIMITED WITH TAB

Borislav Borissov

 

[xenology]

the obvious sometimes escapes us!

 

[bborissov]

Yeah, especialy in 0:35 in the morning )



Borislav Borissov

 

[DSummZZZ]

It's only 2:45 p.m. here.

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm