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
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