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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert ss# xxx-xx-xxxx to xxxxxxxxx in crystal 1

Status
Not open for further replies.
timISST

timISST

MIS
Joined
Jun 12, 2012
Messages
35
Location
US
have tried several things to no avail any ideas?
 
Sort by date Sort by votes
Seems like Replace({SSN_Field,"-","") should work.
 
Upvote 0 Downvote
thank you that was exactly what i needed and it resolved like 9 other things i was trying to do in that report!!
 
Upvote 0 Downvote
Interesting that is the number of digits in the SSN :-)
 
Upvote 0 Downvote
quite true lol didnt think about that one... appreciate the help since i am quite new at working with crystal
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question Question
Crystal Report
Replies
2
Views
809
john432
john432
john432
  • Locked
  • Question Question
Crystal Report Help
Replies
2
Views
770
john432
john432
D
  • Locked
  • Question Question
Dynamic field height in crosstab?
Replies
0
Views
173
doodledump
D
john432
  • Locked
  • Question Question
Crystal Report formula (finding with key words)
Replies
2
Views
771
john432
john432
sofseattle
  • Locked
  • Question Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
697
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top