Hi Michael,
The command "CHCP 437" will set the code page, but I am not sure that that will
have any effect on the problem of your record delimiter and memo fields.
Whenever I export data I use either WP format or XML. generally text file
exports produce the sort of problems you refer to. Mind you I think
Export data out in XML... and use a CDATA section for the memo fields. Yuio
will need to create a Schema (actually the easiest way is to create the target
tables in Access and then export a couple of records as XML, and use that nd
the schema as a template for bringing data from DP.
Creating XML in DP is a piece of cake.
Another way of exporting the data so that you avoid the problem of embedded
lines feeds is to create a report to do the export, and to format memo fields
with the Print Mode Indicator of ;;Q... so you format for the output memo
field might look something like A0A0;;Q
The ;;Q converts embedded CR or CRLF to \n so the text
The quick brown fox CRLF
jumps over the laxy dog
becomes
The quick brown fox\njumpsover the lazy dog"
which overcomes the record delimter problems. (Note that embedded "\"s become
"\\")
Once you get the data into Access it is relatively simple to search and replace
\n to be a CRLF and \\ to be a \
Regards
Brian
----- Original Message -----
From: Michael Iannantuoni
To: Dataperfect Users Discussion Group
Sent: Wednesday, March 05, 2008 6:36 PM
Subject: Re: [Dataperf] Code Page
Hi Brian,
Thanks for the info about CHCP but I'm not sure what I need to set it to. It
currently shows 850.
The problem I had was exporting data from a very simple DataPerfect
application to experiment with in Access. I use a delimited file export using |
for field delimiter and ~ for record delimiter only to find that Access doesn't
allow a record delimiter other that a HRt (!!!!! so much for memo fields in
Access!!!) and that within the Windows environment, my | had changed to a Y
with an acute accent. I seem to recall using Code Page 437 in the past so might
experiment a little.
Regards,
Michael
Brian Hancock wrote:
Hi Michael,
Although I have never had to change a code page from the default 457 on oz
version of Windows , you can do it from the command window before running DP,
eiher inteactively or in a batch file, or by setting it in the autoexec file
for the MS-DOS shortcut.
The utility to change Code page is CHCP, which if executed without a
parameter returns the code page or if executed CHCP xxx set the code page to
the parameter.
When you set up a Shortcut to an MS-DOS program, within its Properties,
from the Advanced Button on the Program tab, you can set the Config.sys and
Autoexec.bat files. By default on WINNT and derivatives it will use two default
files CONFIG.NT and AUTOEXEC.NT located in the Windows\System32 folder. You can
either edit the Autoexec.NT file directly or if you only want to change the
codepage (or other setting) for that instance you can specify a different
autoexec which you have added the necessary CHCP xxx setting. Probably easiest
is it to copy the original AUTOEXEC.NT edit the copy and seting the properties
in the shortcut to use it instead.
Regards
Brian
----- Original Message -----
From: Michael Iannantuoni
To: Dataperfect Mailing List
Sent: Tuesday, March 04, 2008 8:11 PM
Subject: [Dataperf] Code Page
Can someone remind me where I set the Code Page for DataPerfect on a
Windows XP system please.
Thanks,
Michael
--------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
----------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
