text endtext - blank line at top of page 1

[desert227]

code below creates the txt file but with blank line at top of page. Is there some way to prevent that?
SET TEXTMERGE on
STORE FCREATE("c:\TEMP\testit.txt") TO _TEXT && Create low-level file
LOCAL lcxxx
STORE SPACE(900) TO lcxxx
lcxxx="INVOICE_DATE|INVOICE_NUMBER|CLIENT_ID|FIRM_ID|"+"INVOICE_TOTAL|BILLING_START_DATE|BILLING_END_DATE|INVOICE_DESCRIPTION|LINE_ITEM_NUMBER|"

TEXT NOSHOW PRETEXT 7
<<"MYTEST[]">>
<<lcxxx>>
ENDTEXT

=FCLOSE(_TEXT) && Close file

 

[TamarGranor]

Have you tried using the TEXTMERGE() function and STRToFile() instead?

Tamar

 

[white605]

Will this work

*SET TEXTMERGE on
STORE FCREATE("testit.txt") TO _TEXT     && Create low-level file
LOCAL lcxxx
STORE SPACE(900) TO lcxxx
lcxxx="INVOICE_DATE|INVOICE_NUMBER|CLIENT_ID|FIRM_ID|"+"INVOICE_TOTAL|BILLING_START_DATE|BILLING_END_DATE|INVOICE_DESCRIPTION|LINE_ITEM_NUMBER|"

=FWRITE(_text,"MYTEST[]"+CHR(13))
=FWRITE(_text,lcxxx)
=FCLOSE(_TEXT)  && Close file
MODIFY FILE testit.txt

This old world keeps spinning round - It's a wonder tall trees ain't layin' down

 

[CDavis]

I played around with your code and modified it slightly -- give this a try:

SET TEXTMERGE on
STORE FCREATE("c:\TEMP\testit.txt") TO _TEXT && Create low-level file
LOCAL lcxxx
STORE SPACE(900) TO lcxxx
lcxxx="INVOICE_DATE|INVOICE_NUMBER|CLIENT_ID|FIRM_ID|"+"INVOICE_TOTAL|BILLING_START_DATE|BILLING_END_DATE|INVOICE_DESCRIPTION|LINE_ITEM_NUMBER|"

\\<<"MYTEST[]">>

TEXT NOSHOW PRETEXT 7
<<lcxxx>>
ENDTEXT

=FCLOSE(_TEXT) && Close file

************

The \\ (double backslash) designation directs the output to the same line. Check the example under _TEXT in the help file. However you have to do it outside of the TEXT - ENDTEXT command or the backslashes will merely print as text.

CDAVIS

 

[Olaf Doschke]

TEXT..ENDTEXT has new FLAGS and PRETEXT options. PRETEXT 4: eleminate blank lines (not just the start line, though).

Bye, Olaf.

 

[desert227]

Thanks CDavis, that works beautifully. I love this site.