well, theres nothing wrong with csv or tab delimited.
But what you can do is use an hex editor like Gedit; change the cr character
that is in your text to an unused character like ~
Import the data
then change the data in the new database from ~ to cr/lf if you need to.
delete if not.
Of course, you're hosed if the record delimiter as used by DataPerfect is
identical as your CR in your text field. But almost guaranted not. If you
export in wpmerge format your delimiter will be somethine like ^R ^ECR/LF
Finally, you can try to do a direct subsitution before import, CR into ASCII
13 or similar. But usually a substitution after importation works better.
From: [email protected]
To: [email protected]
Date: Sat, 25 Apr 2009 03:01:13 +0000
Subject: [Dataperf] Exporting data with carriage returns
Hi,
Years ago I took a large number of notes in Dataperfect for my dissertation
research. I used some large text fields in which I entered multiple paragraphs
of notes, and I used carriage returns to break paragraphs within these text
fields (the ability to do this was one of the things that made DP such a good
product for historical research). Now I'm trying to export my old DP data into
a new database (Bento) but it seems that the CRs that I put into my text fields
are being written to the export file and interpreted as record delimiters by
the import program. The data gets out of sync as soon as the import program
hits the first in-text CR. I'm limited to either CSV or tab-delimited import.
Is there a way to export the data so that something other than a CR gets
written to the export file inside the text field? Or failing that, is there a
way to find/replace all those CRs in my text fields so that during export CRs
only appear as record delimiters?--hopefully while preserving my paragraph
breaks.
I'm a little hazy about the ASCII code that is being written here and for that
matter about exactly how I entered those paragraph breaks those 10+ years ago.
I believe I entered them by hitting the Enter key, though perhaps sometimes I
used Shift+Enter--not sure if that writes a different code.
Any help you can offer would be most appreciated. Thanks,
Ron
_________________________________________________________________
Windows Live™ Hotmail®:…more than just e-mail.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_more_042009
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
