how to search for a chine's char in file using chines word

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
ushasribandaru
Participant
Posts: 15
Joined: Fri Nov 21, 2008 12:41 am

how to search for a chine's char in file using chines word

Post by ushasribandaru »

Hi ,

Can u please advice how to search for a chinies charecter in the files using the CHINIES KEY word.

I tried as below
1.

IF( (FIND("公对私",TRIMRIGHT(TRIMLEFT(PayDetLine1 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine2 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine3 Field:Detail_Trans:TxnDetails)))=0 |
FIND("对个人",TRIMRIGHT(TRIMLEFT(PayDetLine1 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine2 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine3 Field:Detail_Trans:TxnDetails)))=0 |
FIND("对私支付",TRIMRIGHT(TRIMLEFT(PayDetLine1 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine2 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine3 Field:Detail_Trans:TxnDetails)))=0),"A","B")


2.

IF(MEMBER(TRIMRIGHT(TRIMLEFT(PayDetLine1 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine2 Field:Detail_Trans:TxnDetails))+TRIMRIGHT(TRIMLEFT(PayDetLine3 Field:Detail_Trans:TxnDetails)),{"公对私" , "对个人" , "对私支付"}),"A","B")

not working with the both,
please advice if any one worked with chines charecters before ? please advice any alternative??

Thank You.
Post Reply