Thanks Vincent. I got the solution by using count and If Else statement.
Regards
Ashwin
Search found 93 matches
- Thu Sep 08, 2005 11:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pattern Matching in DS PX
- Replies: 3
- Views: 1314
- Thu Sep 08, 2005 12:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pattern Matching in DS PX
- Replies: 3
- Views: 1314
Pattern Matching in DS PX
Hi Can anybody guide me in this regard? How to do pattern matching in DS PX. Example you have to move all cities which are having "MI" anywhere in their name. i.e %MI% Substr can work if we are sure where "MI" can occur in the incoming string. Count will also not work in this cas...
- Tue Aug 30, 2005 4:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion of CCYY-DD-MM to CCYYDDMM
- Replies: 5
- Views: 2027
Conversion of CCYY-DD-MM to CCYYDDMM
Hi
I am new to this forum.
Can anbody help me with conversion of CCYY-DD-MM to CCYYDDMM.
I am tring to do this but the 0 of MM is getting truncated.
Please let me know about any soultion for this.
Thanks
Ashwin
I am new to this forum.
Can anbody help me with conversion of CCYY-DD-MM to CCYYDDMM.
I am tring to do this but the 0 of MM is getting truncated.
Please let me know about any soultion for this.
Thanks
Ashwin