Embedded carriage return in PC data

[Jeff Hoffman]

Blue

At 03:49 PM 19-03-02 -0600, you wrote:
>G'day Jeff
>
>Is the Access data extracted to a CSV file?  
>What would be the longest record length in the file? (you can use anal/rms
>to find that).  Are any of the fields more than 2047 bytes long?
>
>I see two possibilities:
>
>1. create a record definition in the PHD for a variable length file with a
>single field (if rec length is under 2047 bytes) then rename the access csv
>file to that filename and parse the fields using the delimiter.  Write the
>output to a subfile and read that subfile for the final load.

This is what I do currently, trouble is that embedded CR or LF are treated
as end of record, so that the actual record is split into or more
incomplete records.

>2. create a record definition in the PHD that matches the layout of the
>Access output file.  Rename the Access file and read it as a standard RMS
>sequential file.

The record is a variable length, how would I create a PHD file layout to
match that?

>Regards,
>Blue
>

Regards

Jeff