Data Problem

[Mike Godsey]

I get this kind of problem every week. I solve it by using a PC editor like
ME or TextPad to filter the file before I transfer it for Powerhouse to
process.
Mike Godsey
----- Original Message -----
From: "Jeff Hoffman" <wonicon@bigpond.net.au>
To: <powerh-l@lists.swau.edu>
Sent: Sunday, June 03, 2001 3:11 AM
Subject: Data Problem


> Hi
>
> I have received an access (.mdb) data base, I need to create a tab
> delimited file for processing by QTP.
>
> The data has line feeds (hex 0a) embedded in the data. Record separator is
> cr/lf (hex 0d0a). Powerhouse is treating the line feeds as a record
separator.
>
> The powerhouse is running on a VMS system.
>
> As far as I know I use access to create an excel spreadsheet, then use
> excel to create the tab delimited file, which is transferred to the VMS
> machine.
>
> Does anybody know if the line feed can be converted to say ", " without
> affecting the record separator in any of the steps? or any other
suggestions.
>
> Thanks
>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
> + Jeff Hoffman                          + e-mail: wonicon@bigpond.net.au
+
> + Director                              +
+
> + WoniCon Pty Ltd   (ABN 93 083 502 630)+                          ,-_|\
+
> + 21 Prices Circuit                     + voice: +61 2 9542 1527  /     \
+
> + Woronora    NSW     2232              +   fax: +61 2 9521 3979  \_,-._*
+
> + 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.
>