Search found 93 matches

by ashwin141
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

Thanks

Thanks Vincent. I got the solution by using count and If Else statement.


Regards
Ashwin
by ashwin141
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...
by ashwin141
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