Embedded carriage return in PC data

[Chris Sharman]

> I am using VMS variable length file to read data from an Access data base.
>
> CR's are embedded in the data, they are being treated as end of record.

In a VMS VAR file, CR's aren't treated as anything, just another character.
The format can contain variable length binary records (eg 3gl object files).

Perhaps you mean a stream format, or stream-cr, or stream-lf ?
What does dir/full show, and dump/rec=count=1 ?
If it's stream-lf, and has trailing cr's, then do

$ set file/attr=rfm=stm <file> ! makes it stream-crlf

> Has anybody got some advice (politely please) of a way to detect
> and remove
> these before I access this file with PH?

If you're accessing with PH, presumably you're able to treat it as a fixed
file ?

quiz> def field1 ....
quiz> ...
quiz> set subfile mydb keep
quiz> rep sum field1 ....
quiz> exit
$ anal/rms/fdl mydb.sf
$ convert/fdl=mydb mydatafile.dat mydb.sf /truncate/pad=%x20
$ quiz
quiz> access *mydb ...
quiz> ; now use defines to find & remove any spurious cr's



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.