DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
ushasribandaru
Participant



Joined: 21 Nov 2008
Posts: 15

Points: 191

Post Posted: Wed Dec 08, 2010 3:34 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Unix
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.
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours