DSXchange

Posted: **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!

Posted: **Tue Dec 23, 2008 1:32 pm**

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

Posted: **Tue Dec 23, 2008 1:43 pm**

Use Trim function

Posted: **Wed Sep 05, 2012 9:09 am**

nsm wrote:Use Trim function

The TRIM function does not remove the '-'.

Posted: **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.

Posted: **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,

Posted: **Wed Sep 05, 2012 9:33 am**

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

DSXchange

DS Function to reformat SSN

DS Function to reformat SSN