function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Mohammed zabi 6Mohammed zabi 6 

How to Remove Special charters from String

Hi All,

  We have a formula filed like TRIM(''+Id) this custom filed we are using in Email templet so when senind an Email we are getting string in sent mail ""  llike this. how ti remove "?" from the link when we send an email. please help me on this.
You can use SUBSTITUTE to remove it
'' + TRIM(SUBSTITUTE(Id, '?', ''))

You may want to look at REGEX if you need to substitute lots of different strings.
Mohammed zabi 6Mohammed zabi 6
Hi Pcon,
  thanks for the replay this SUBSTITUTE Will work to remove  '?' mark.
Great! If you could please choose a "best answer" so that this question can be removed from the unresolved queue and so others may easily find the answer.