-
1. Re: Manipulating strings
Galen Busch Jul 25, 2017 3:00 PM (in response to Alex Hartley)Hi Alex,
Simply put, this is easier with find and replace in Excel (Control+H) or a replace function in SQL. Are either of those options?
-
2. Re: Manipulating strings
Stoyko KostovJul 25, 2017 3:04 PM (in response to Alex Hartley)
Have you tried REPLACE([ADDRESS], " ", "+")? This would simply replace all spaces with pluses. Please let me know if this is not quite what you are trying to achieve - I can try to improve it using different string functions.
-
3. Re: Manipulating strings
Alex Hartley Jul 25, 2017 3:04 PM (in response to Galen Busch)yes, you are right. I have done it in excel before. the problem is that I have a dashboard that displays the address and I want users to click on that address and open the search engine in salesforce to look for opportunities in that address. the search engine uses a specific link and the only thing that changes is the end, which is the "6251+main+st" portion. makes sense?
-
4. Re: Manipulating strings
Alex Hartley Jul 25, 2017 3:05 PM (in response to Stoyko Kostov)oh man!!! didn't think of using REPLACE. let me try it.
-
5. Re: Manipulating strings
Alex Hartley Jul 25, 2017 3:06 PM (in response to Stoyko Kostov)Stoyko, it worked. thank you!!