Question Re: Converting a SSN to Include Dashes in Technology Q&A

Converting a SSN to Include Dashes

Former Member — Thu, 18 Oct 2018 17:15:00 GMT

Version: 14.2.3.2132 of Business Objects

When I pull a SSN into a report, it comes through in a straight number 123456789

I need to convert this to somehow include dashes: 123-45-6789

While there is a left =Left([Borrower 1 SSN];3) +"-"

and right =Right([Borrower 1 SSN];4)

function I can use for the first three with a dash and last four, there is no "mid" function to extract the two middle numbers, so they can be separated out and a dash added. Any ideas in how I can do this?

Re: Converting a SSN to Include Dashes

TammyPowlas — Thu, 18 Oct 2018 17:15:44 GMT

Hi - I went ahead and published your question but please share which tool you are using. Is it Web Intelligence?

Re: Converting a SSN to Include Dashes

Former Member — Thu, 18 Oct 2018 17:34:43 GMT

Thanks, yes, using Web Intelligence. SAP BusinessObjects BI Platform 4.2 Support Pack 3

Re: Converting a SSN to Include Dashes

ayman_salem — Thu, 18 Oct 2018 17:36:49 GMT

use Substr

Variable: =Left([SSN];3) + "-" + Substr([SSN];4;2)+ "-" + Right([SSN];4)

Re: Converting a SSN to Include Dashes

Former Member — Thu, 18 Oct 2018 18:19:22 GMT

Thanks Ayman, that did it!

Re: Converting a SSN to Include Dashes

Former Member — Fri, 19 Oct 2018 17:47:50 GMT

One more method I ended up finding that works:

=Substr([Borrower 1 SSN];1;3)+"-"+Substr([Borrower 1 SSN];4;2)+"-"+Substr([Borrower 1 SSN];6;4)

Re: Converting a SSN to Include Dashes

denis_konovalov — Mon, 22 Oct 2018 11:46:08 GMT

I have fixed your primary tag, please select more careful next time.