Hi Ralph, Hold down the Alt Key and on the Numeric key pad type either 09 or 009 it will insert a circle symbol into the report which represents a Tab character in the file. You can even insert tabs this way in AxAy fields in a panel.
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
