
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 10:45 AM
Hello,
I am trying to substitute all the occurrences of ", " (comma, space) in a Lookup field with “%20” and place that into the formula field.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 11:23 AM
Oh, interesting… actually, my setup WASN’T identical to yours. My lookup field was actually looking up a collaborator field, and it worked for that type of field. When I switched it to a different field type, it failed.
Try this instead for your formula, and see if this works:
ARRAYJOIN( {Inquiry: Skills List Internal}, "%20" )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 10:51 AM
In your formula, you will need to turn your lookup field into a string, by adding an empty string after the field name:
{Inquiry: Skills List Internal} & ""
So your whole formula would look like this:
SUBSTITUTE( {Inquiry: Skills List Internal} & "", ",", "%20")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 10:55 AM
Hm, @ScottWorld it removed the commas, but did not substitute with “%20”

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 11:02 AM
Hmmm… not sure… the same formula works for me on my end.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 11:03 AM
@ScottWorld , is the source field a Lookup field in your case as well?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 11:05 AM
Yes. Same setup as you.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 11:08 AM
The formula works when I apply it on a single line text field, but not a lookup field or formula field (I just copied the lookup string into a formula field by inserting it).
I’ll keep trying.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 11:23 AM
Oh, interesting… actually, my setup WASN’T identical to yours. My lookup field was actually looking up a collaborator field, and it worked for that type of field. When I switched it to a different field type, it failed.
Try this instead for your formula, and see if this works:
ARRAYJOIN( {Inquiry: Skills List Internal}, "%20" )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 11:26 AM
Works. You’re a star!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 05, 2021 11:26 AM
Fantastic! I probably shouldn’t have gone down the path of that first formula at all! :winking_face:
