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
metadata1
Participant
Posts: 10 Joined: Thu Dec 04, 2008 5:50 pm
Post
by metadata1 » Tue Dec 23, 2008 1:21 pm
Hello -
Could you please guide me to figure out how to remove dashes (-) from the existing SSN number (999-99-9999) - Is there a specific function in DS to get this formatting done. I would like my result to be (999999999) with out any special characters.
I tried running the Search query but did not find a relative match -
Thank you again!
kandyshandy
Participant
Posts: 597 Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore
Post
by kandyshandy » Tue Dec 23, 2008 1:32 pm
what did you search for? I wonder you searched for CONVERT
Kandy
_________________
Try and Try again…You will succeed atlast!!
nsm
Premium Member
Posts: 139 Joined: Mon Feb 09, 2004 8:58 am
Post
by nsm » Tue Dec 23, 2008 1:43 pm
Use Trim function
Jag
Premium Member
Posts: 4 Joined: Tue Sep 15, 2009 8:38 am
Post
by Jag » Wed Sep 05, 2012 9:09 am
nsm wrote: Use Trim function
The TRIM function does not remove the '-'.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Sep 05, 2012 9:29 am
Pretty sure you can specify the character to trim, spaces is just the default. Convert would work for this as well.
-craig
"You can never have too many knives" -- Logan Nine Fingers
jwiles
Premium Member
Posts: 1274 Joined: Sun Nov 14, 2004 8:50 pm
Contact:
Post
by jwiles » Wed Sep 05, 2012 9:33 am
Yes it can, and I would think that after nearly four years they have figured that out
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Wed Sep 05, 2012 9:33 am
Trim(In.Column,'-') will remove dashes.