Embedded carriage return in PC data

[Edis, Bob]

G'day Jeff

I have used the following technique successfully:

1. Create a permanent subfile with the same layout as the ASCII file using
Quiz.
2. delete the *.sf file just created
3. edit the *.sfd file just created and add a 1 byte field at the end of the
record.  This hold the CR.
4. copy your ASCII file to same name as the subfile and make the extension
.sf
5. Read the file with Quiz as a test.

Regards,
Blue


-----Original Message-----
From: Jeff Hoffman [mailto:wonicon@optushome.com.au]
Sent: Monday, March 18, 2002 2:51 PM
To: powerh-l@lists.swau.edu
Subject: Embedded carriage return in PC data


G'Day

Sorry for this non PH question butttttt....

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.

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

Thanks
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
+ Jeff Hoffman                          + e-mail: wonicon@optushome.com.au
+
+ Director                              +
+
+ WoniCon Pty Ltd   (ABN 93 083 502 630)+                          ,-_|\
+
+ 21 Prices Circuit                     + voice: +61 2 9542 1527  /     \
+
+ Woronora    NSW     2232              +                         \_,-._*
+
+ AUSTRALIA                             + mobile: 040 790 3929         v
+
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.