Help

Substitute characters in a string with another set of characters

Topic Labels: Formulas
Solved
Jump to Solution
7342 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: