Exporting records containing newlines

[davidmorr]

Hi

I need to be able to export records on multiple lines. For example, I want to create a Unix shell script which requires multiple lines:

/web1/fred -pr <<EOD

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

EOD

The field in the database is the row of xxxxxxxxxxxxxxxxxxxxx, but it needs the command above and the terminator (EOD) below to work.

As far as I can see, exporting can only create one line per record. (I did try explicitly inserting newline characters in the record, but it did not work properly.)

So, I would appreciate any suggestions as to how to do this.

Thanks

David

[Garry Claridge]

You can create a calculation field which wraps the concatenated field data with the head and tail for each record.

Hope this helps.

Garry

[BobWeaver]

I believe that unix uses a linefeed character to indicate a new line, where Macs use a carriage return. So, make sure that you are inserting the correct character.