Embedded carriage return in PC data

[shulbert@littlejohnfrazer.com]

Despite the risk of merciless flaming here goes.

Since the data is in Access, why not use VBA to write it to a text file?
VBA can read the data structure and can be made to cope automatically with decimal places or embedded line breaks: declare dates as YYYYMMDD, numerics as freeform, and remember to include a byte or two on the end for the line break.
You can also use it to write a small quiz to create the data structure, or even a batch file to do the whole import for you.
Saves all that fiddling about uploading and downloading.

BTW, making variable length text files fixed length on UNIX is a one line AWK script and not hard at all.

Regards,
Stephen Hulbert.
Senior Analyst/Programmer.
Software Division. Littlejohn Frazer.
Direct: +44 (20) 7369 4501. Fax: +44 (20) 7987 9707
mailto:shulbert@littlejohnfrazer.com



 -----Original Message-----
From: 	BEdis@usbnc.org [mailto:BEdis@usbnc.org] Sent:	Tuesday, March 19, 2002 4:44 PM
To:	powerh-l@lists.swau.edu
Subject:	RE: Embedded carriage return in PC data

I too think TextPad is a great text editor!

Blue

-----Original Message-----
From: Hoppe, Eric EP [mailto:Eric.Hoppe@steelscape-inc.com]
Sent: Tuesday, March 19, 2002 10:15 AM
To: 'Jeff Hoffman'; powerh-l@lists.swau.edu
Subject: RE: Embedded carriage return in PC data


Jeff-

I am not sure exactly if this is what you are looking for... assuming this is a 'one-off' and you can massage the file, I swear by a
fantastic text editor called Textpad to manipulate files (textpad.com).  It
has been able to do anything and everything I have ever asked.

---ehops
eric hoppe

ps I am not associated with the Textpad company at all, I just TRULY believe
in the product... and it's only about $30US for a license.

-----Original Message-----
From: Jeff Hoffman [mailto:wonicon@optushome.com.au]
Sent: Monday, March 18, 2002 12: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.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.




The information contained in this communication is confidential and may
be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it.  If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking of any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful.

Littlejohn Frazer reserves the right to monitor the content of any
message sent to or from littlejohnfrazer.com and its associate domains,
fmi-litjon.co.uk and litjon.co.uk

A list of partners may be inspected at 1 Park Place, Canary Wharf,
London, E14 4HJ

Registered to carry on audit work by the Institute of Chartered
Accountants in England & Wales, and authorised by the Financial
Services Authority to provide financial services