You will need to create a formula like the following
if instr({Field}," ") > 0 then
replace({Field}," ","") else
if instr({Field},"!") > 0 then
replace({Field},"!","") else
if instr({Field},"-") > 0 then
replace({Field},"-","") else
{field}
You will need to repeate each of the instr and replace statements for each of the punctuations you want to check for and remove.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.