Discussion:
Control Characters in Export
(too old to reply)
s***@stevefitzgerald.net
2010-01-05 18:31:46 UTC
Permalink
I'm exporting a flat file from Infomaker 11.5.1. There is a control
character  being inserted before the first field. When I use
version 8.5 I don't get the same control character. This is preventing
my flat file from being imported properly into a third party app.

Any ideas on how to prevent this control character from being created?
Terry Dykstra [TeamSybase]
2010-01-05 19:02:07 UTC
Permalink
How are you creating the file? When saving the file are you selecting ANSI
as the format? It looks like you are using a Unicode format.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<***@stevefitzgerald.net> wrote in message news:2cff7d2e-c57f-4d43-b27a-***@m26g2000yqb.googlegroups.com...
I'm exporting a flat file from Infomaker 11.5.1. There is a control
character  being inserted before the first field. When I use
version 8.5 I don't get the same control character. This is preventing
my flat file from being imported properly into a third party app.

Any ideas on how to prevent this control character from being created?
s***@stevefitzgerald.net
2010-01-06 14:28:57 UTC
Permalink
We've tried all of the encoding methods with the same result. More
information...

When we look at the file through SQLPLUS and use cat -v we see the
following:

M-oM-;M-?

Does this mean anything to anyone?
Terry Dykstra [TeamSybase]
2010-01-20 17:47:34 UTC
Permalink
I checked and when you save as text and select ANSI/DBCS as the format it
does not add those control characters. The other formats add hex characters
FE/FF or FF/FE.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by s***@stevefitzgerald.net
We've tried all of the encoding methods with the same result. More
information...
When we look at the file through SQLPLUS and use cat -v we see the
M-oM-;M-?
Does this mean anything to anyone?
Loading...