Need formula to remove dashes from string

JHaden3

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!

Jerry Casey

REPLACE("yourfieldname",'-','')

JHaden3

Exactly what I needed, thanks so much!