Worked like a charm. Thanks. "Brian Hancock" <[email protected]> wrote in message news:3c0e2f7a7784452a9118899bf3da7...@brian4... > 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
