Oh yes, I should have added, in the Transaction log a double quote in the data is handled correctly and from memory I think it inserts it as two double quotes. So for example 3 inches would be output in the TLog as "3 inches", and 3" would be output as "3"""
Also the Tlog does these conversion Embedded carriage returns become a CR outside of quotes eg "The quick" CR "brown fox" Embedded tabs become either an \I or "\I (I can't remember which) Bolded text becomes is enclosed between BO and BF markers eg "The " BO "quick" BF " brown fox" And similarly underlined text becomes is marked with UO and UF markers Brian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ralph Alvy Sent: Thursday, 18 December 2008 3:42 AM To: [email protected] Subject: [Dataperf] Logs and Exports: Some Problems I have run into an interesting couple of problems. Some of my records have double quote marks in them. Mainly because I use them to denote inches. So here's the problem. I want to export some DataPerfect data into a different database. That database can import CSV or Tab Delimited files. I can't use CSV formatted files because of previous use of double quotation marks in some of the data. I thought I could just create a Tab Deliminated file by using ^I as my field deliminator, but that didn't work. How would I get tabs entered into a DP report? I don't remember how to do that. The second thing I noticed is that the DP transaction log export facility uses double quotes as field deliminators as well. This means that, as long as I have double quotes in my data, I can't rely on the transactions log export/import facility to clean my database any more. Unless I carefully remove those double quotes in the database and never use them again. Am I missing something here? Ralph _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
