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!

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

Newbie Replace Formula question

Status
Not open for further replies.

presucio

Technical User
Jun 4, 2005
2
US
Hello everyone! I need to replace the "," character and "PRN" from an employee name field.
I have used the

replace ({employee.name},"PRN","");
replace ({employee.name},",","")

to remove the letters PRN but I still have many ","

What do I need to add to the formula to remove commas and the letters P,R,N from the field?

Any help to this newbie will be greatly appreciated. Thanx
 
try

replace(replace ({employee.name},",",""),"PRN","")


Mo
 
Worked Great! Thank you very much for your prompt response ... that was quick ... saved me a lot of headaches!

Thanx again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top