Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need formula to remove dashes from string

JHaden3Jan 23 2020 — edited Jan 23 2020

OBIEE - Would someone please help with a formula to remove dashes from this social security number field so that only the digits remain.  The field name is "Worker"."Primary National Identifier Number"

Example:  change xxx-xx-xxxx  to xxxxxxxxx (must be 9 digit social).  Thanks!
This post has been answered by Jerry Casey on Jan 23 2020
Jump to Answer
Comments
Post Details
Added on Jan 23 2020
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
2,792 views