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
