Subject Re: [firebird-support] external file table and CR/LF
Author Ann Harrison
Brian Schembri wrote:

>>... I
>>cannot get to insert a CR/LF in the rows.
What I've done when I need that is to create a text file containing a
CR/LF, create a table definition that maps to that table, including a
char(2) field for the CR/LF, then create a table in the database with a
char(2) field called CR_LF. Insert into the database table selecting
values from the external table. Now you have a CR/LF in the database
which you can include when you insert into your external file.