Changing SSN to include dashes
Sorry, me again. When it rains it pours.
Currently in Taleo our SSN is stored in ######### format. We do not have any type of data feed to our HCMS because, well we don't have an HCMS, just a payroll system that can't take a feed from Taleo. So, we are using an export from OBI to put new hires into the Payroll system and they want SSN with the dashes in it.
Is there an OBI formula I can use to insert the dashes? I've tried some of the mySQL examples I have found online and most of them don't work in OBI as it says the administrator has not allowed that command. So it should be 123-45-6789 instead of 123456789.