Skip to main content

Formula Field - Substituting Multiple Characters

  • January 27, 2017
  • 1 reply
  • 23 views
P

Hi,

I currently have a column that efforts to basically make a url-friendly version of the record name using this string.

LOWER(SUBSTITUTE(artist, " ", “-”))

That takes the Artist’s name column and removes spaces and replaces them with dashes. Is there anyway to program this formula to look for multiple characters that it would find and replace with a dash?

Thanks for any help.

      This topic has been closed for replies.

      1 reply

      B
      • bruce_hartley
      • New Participant
      • January 31, 2019

      THANK YOU! I’ve definitely a novice, but have been futzing around for an hour or two trying to create a column that will search Google Maps, using several of my fields as parameters. I couldn’t figure out how to either strip out the spaces (i.e. change “Vintage Vinyl” into “VintageVinyl”) or replace them with a “+” (i.e. change “Vintage Vinyl” into "Vintage+Vinyl) so they would work in a search. With your help, I made a formula that works! I couple this with a google link (which I can’t include here for some reason):

      SUBSTITUTE(Store, " ", “+”) & SUBSTITUTE(Town, " ", “+”) & {State}

      Terms & ConditionsAccessibility statement