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.
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.
-
- Participant
- Posts: 15
- Joined: Fri Nov 21, 2008 12:41 am
Return to “IBM<sup>®</sup> DataStage TX”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration