Hi Brian,
I haven't used the ;;Q option before but for now, it seems the best option.
Thanks again.
Regards,
Michael
Brian Hancock wrote:
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 <mailto:[EMAIL PROTECTED]>
*To:* Dataperfect Users Discussion Group
<mailto:[email protected]>
*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 <mailto:[EMAIL PROTECTED]>
*To:* Dataperfect Mailing List <mailto:[EMAIL PROTECTED]>
*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] <mailto:[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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
