I have an access database that has a memo field in it. I need to output the database to a text delimited file. I usually use "|" to seperate the fields like a comma in a CSV file. The problem is that there are many line returns in the memo field causing a record to be written out in mulitple lines. How can I get rid of those carriage returns.
Examples: 1|Some Item|5.95|image.gif|department1|This is a really fun item to have in your house. 2|another item|10.00|image2.gif|department2|some more test with incorrect carriage returns. ##---> above is a good example 1|Some Item|5.95|image.gif|department|This is a really fun item to have in your house 2|another item|10.00|image2.gif|department2|some more test with incorrect carriage returns. ##---> above is the example of the problem I hav and want to get rid of.. This happens when I export the database from access to a text file. _______________________________________________ Perl-Win32-Web mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
