Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need formula to remove dashes from string

Received Response
1407
Views
2
Comments
Rank 3 - Community Apprentice

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!

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.