- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 26, 2017 08:13 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 31, 2019 08:31 AM
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}