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

Derived Field help ~ REPLACE??? function

Status
Not open for further replies.
abowling

abowling

Technical User
Apr 27, 2005
33
0
0
US
I need a derived field to change the SSN from

123-45-6789 to XXX-XX-6789


Any help would be greatly appreciated.
 
Sort by date Sort by votes
Try this (Example is with basic PS_Employees table):

1st Derivied Field
SUBSTR("PS_Employees.SSN",6)

2nd Derived Field
Use concatenation to combine 'XXX-XX-' with first derived field
 
Upvote 0 Downvote
that worked, thanks a lot for your help!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SamD1996
  • Locked
  • Question
Derived Fields and Detail
Replies
0
Views
191
SamD1996
SamD1996
amandacody
  • Locked
  • Question
Can I please get help with a DECODE function that contains a derived
Replies
0
Views
208
amandacody
amandacody
wmannod
  • Locked
  • Question
Reportsmith Version 4.2 derived field 1
Replies
19
Views
166
CharlesCook
CharlesCook
ttrsnoob
  • Locked
  • Question
derived field to pull check gross in range of dates 1
Replies
7
Views
127
CharlesCook
CharlesCook
salbrandt
  • Locked
  • Question
Tenure - Dervied Field
Replies
5
Views
97
CharlesCook
CharlesCook

Part and Inventory Search

Sponsor

Back
Top