Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Substitute characters in a string with another set of characters

Topic Labels: Formulas
Solved
Jump to Solution
7919 15
cancel
Showing results for 
Search instead for 
Did you mean: 
Milos_Milosavlj
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

image

1 Solution

Accepted Solutions

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" )

See Solution in Thread

15 Replies 15

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")

Hm, @ScottWorld it removed the commas, but did not substitute with “%20”

image

Hmmm… not sure… the same formula works for me on my end.

@ScottWorld , is the source field a Lookup field in your case as well?

Yes. Same setup as you.

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.

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" )

Works. You’re a star!

Fantastic! I probably shouldn’t have gone down the path of that first formula at all! :winking_face: