DS Function to reformat SSN

metadata1 · 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 · Post by **kandyshandy** » Tue Dec 23, 2008 1:32 pm

what did you search for? I wonder you searched for CONVERT

nsm · Post by **nsm** » Tue Dec 23, 2008 1:43 pm

Use Trim function

Jag · Post by **Jag** » Wed Sep 05, 2012 9:09 am

nsm wrote:Use Trim function

The TRIM function does not remove the '-'.

chulett · 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.

jwiles · 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,

ArndW · Post by **ArndW** » Wed Sep 05, 2012 9:33 am

Trim(In.Column,'-') will remove dashes.