Ah, I see, double double-quotes, like you said. Thanks. "Brian Hancock" <[email protected]> wrote in message news:11acbe6a258d48eca9cc4f1199fc9...@brian4... > 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
