AnsweredAssumed Answered

Calculated Field - Replace\Trim white space or special characters

Question asked by Sam Matthews on Jul 17, 2018
Latest reply on Jul 18, 2018 by André Lopes

Hi All,

 

Just wondering if anyone has worked out a way to trip spaces or replace special characters in fields.

 

We are building a coupon code module and would like to have a combination of fields i.e

"Type"-"LastName"-"Date"-"RandGen"

 

There is a chance that the "LastName" field might be "O'Donnell" or "Lee Swagger" for instance.

 

This would break the code system as it doesn't allow these scenarios. I am hoping to find a formula to have them appear like:

 

ODonnell and LeeSwagger

 

Hope that makes sense.

 

Kind Regards,

 

Sam

Outcomes