Converting a SSN to Include Dashes

[Former Member]

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?

[TammyPowlas]

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

[denis_konovalov]

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

[ayman_salem · Accepted solution]

use Substr

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

[Former Member]

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)

[Former Member]

Thanks Ayman, that did it!

[Former Member]

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