Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove dashes from SSN

Status
Not open for further replies.
cutpen

cutpen

Technical User
Joined
Jun 23, 2008
Messages
20
Location
US
What is the formula to remove the dashes from a Social Security Number? I have 8.5 version.

Thanks,
Penny
 
Sort by date Sort by votes
replace({table.ssn},"-","")

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question Question
Extract Phone Numbers from Text Field
Replies
0
Views
691
socalvelo
socalvelo
D
  • Locked
  • Question Question
Running total from a subreport only showing last value
Replies
4
Views
1K
doodledump
D
socalvelo
  • Locked
  • Question Question
Date Range Formula - Data from two months ago only
Replies
4
Views
774
pmax9999
pmax9999
Tonyvee73
  • Locked
  • Question Question
Use a field from a subreport in a calculation formula
Replies
2
Views
511
kray4660
kray4660
BradCustom
  • Locked
  • Question Question
Passed variable from Subreport to Main skips one row
Replies
4
Views
462
BradCustom
BradCustom

Part and Inventory Search

Sponsor

Back
Top