Unwanted Characters displaying in field

Hello,

Please how do I stop unwanted charater “///” in computed field showing up. This is because of canonicalizing but I don’t want the /// showing in the field.

Is there a function such @Trim for removing characters?

I have tried using @Begins, here is the code but not working exactly well…

FIELD ReviewedBy := ApprovededBy+“/” ;

FIELD S := @Set(“ApproveByFmt”;“”);

@If(@Begins(“ApproveByFmt”; “/”); S ;(@Name([Canonicalize];ReviewedBy)))

Thanks a Lot!

Subject: Unwanted Characters displaying in field

You need to rethink this entirely. You’re getting the characters because you are putting them there in a previous formula.

What are you trying to accomplish in each field?

Subject: @ReplaceSubstring