Re: Need DBCS help

["Rory Hewitt" <roryhewitt@xxxxxxxxx>]

Jeff,

Remember that DBCS data needs to have matched shift-in and shift-out
characters, plus you need to be sure that everything between the shift's is
in double-byte pairs (i.e. you need to ensure that there are an even number
of characters between the x'0E' and the x'0F'). So a simple %trim + x'0F'
might not work, either if there has already been a matching x'0F' or because
there is an odd number of characters following the x'0E'

I'm not sure whether Chinese text could be a mixture of SBCS and DBCS (i.e.
containing multiple shift-in's and shift-outs) - Japanese certainly can. I
assume you're using Simplified Chinese?

Rory

On Wed, Oct 15, 2008 at 8:41 AM, <jeffw@xxxxxxxxxxxxxxxx> wrote:

> Hi everybody.
> Sorry for the wordy explanation but it is the only way I know how to convey
> the problem. I have a field that is being filled by our ERP package that is
> in DBCS (Chinese). The problem is one field is 20 but another field they
> are
> putting the same data in is 15 (short of like a short desc of the first
> field).
> So when they fill the field with DBCS data if it is larger than the 15 then
> I think it is losing the SHIFT-IN hex value. Our ERP vendor is working on
> this, but I have a lot of data that is bad at the moment.
> I want to write a cleanup to go into the file and fix the fields. If you
> try
> and DFU the field it looks like garbage data in the field. I dont have much
> experience with HEX, but what I have learned is this should work but it
> doesnt.
> EVAL CDESC=%trimr(CDESC)+x'0F'
> I have a program that I wrote that has screen that will show both fields if
> I copy and paste it manually into the new field it works. Any ideas?
> Thanks
> Jeff Williams