Data Problem

[Jeff Hoffman]

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    +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+