Suppressing special character

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
BSG1
Participant
Posts: 29
Joined: Mon May 11, 2015 9:43 am
Location: United States

Suppressing special character

Post by BSG1 »

Hi all,

Is there any function in data stage which can suppress special characters in parameter. I am creating a date parameter having value like 2015-10-01

i need to get 20151001 from above string.

Please help.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There are no "special characters" in that string. If you want the dashes removed, look into a function like Convert() as one option.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
BSG1
Participant
Posts: 29
Joined: Mon May 11, 2015 9:43 am
Location: United States

Post by BSG1 »

Done. thanks
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”