function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mohammed zabi 6Mohammed zabi 6 

How to Remove Special charters from String

Hi All,

  We have a formula filed like TRIM('https://www.google.com/'+Id) this custom filed we are using in Email templet so when senind an Email we are getting string in sent mail "https://google.com/?123456789890290"  llike this. how ti remove "?" from the link when we send an email. please help me on this.
pconpcon
You can use SUBSTITUTE to remove it
  
'https://google.com/' + 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.
thanks.
pconpcon
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.