Field Formatting

[Chris Stammers]

Hello,

I am using Word 2002 and I have a field that contains text and numbers. I
need the field to show as:

Gold Cover [£250,000]

however the pound sign seems to be corrupting and is showing as a strange
looking pipe character. The data in the field seems OK (it is an AS400
system). I have made sure that the regional setting in Word is set to English
UK. Is there anything I can do in formatting that will solve this?
Thanks,
Chris

 

[Peter Jamieson]

Assuming that the field can contain a "£" at any point, I can't think of a
way to deal with this in Word without either preprocessing your input or
postprocessing your output, unless you happen to have a font where this
particular "code point" displays correctly - and that would probably have to
be a non-Unicode font.

(AFAICS "£" is character A3 in Unicode but character 9C in, say the DOS USA
character set)

However, it is probably worth looking at your AS400 OLE DB provider/ODBC
driver to see if there is an option to do any character set translation.
"CCSID" is a keyword you could look for. (I think I've mentioned before that
I don't have an AS400 to play with here).

 

[Chris Stammers]

Thanks for your help once again peter. I will check with our IT department.

Regards,
Chris

Assuming that the field can contain a "£" at any point, I can't think of a
way to deal with this in Word without either preprocessing your input or
postprocessing your output, unless you happen to have a font where this
particular "code point" displays correctly - and that would probably have to
be a non-Unicode font.

(AFAICS "£" is character A3 in Unicode but character 9C in, say the DOS USA
character set)

However, it is probably worth looking at your AS400 OLE DB provider/ODBC
driver to see if there is an option to do any character set translation.
"CCSID" is a keyword you could look for. (I think I've mentioned before that
I don't have an AS400 to play with here).

--
Peter Jamieson
http://tips.pjmsn.me.uk

Hello,

I am using Word 2002 and I have a field that contains text and numbers. I
need the field to show as:

Gold Cover [£250,000]

however the pound sign seems to be corrupting and is showing as a strange
looking pipe character. The data in the field seems OK (it is an AS400
system). I have made sure that the regional setting in Word is set to
English
UK. Is there anything I can do in formatting that will solve this?
Thanks,
Chris