Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

#ERROR using SUBSTITUTE()

Topic Labels: Formulas
Solved
Jump to Solution
180 1
cancel
Showing results for 
Search instead for 
Did you mean: 
egrubis
4 - Data Explorer
4 - Data Explorer

Hello! I want to generate some HTML code using a Lookup function and I've been running into a weird issue. Each HTML button is defined in a table, then is combined like such in a Lookup function:

<a href="/water-coaster/192/" style="text-decoration: none;" title="Go to this water coaster"> <span style="background-color: beige; color: black; padding: 10px 20px; border-radius: 50px; font-size: 16px; font-weight: bold;">Montanha Russa Aquática - Thermas dos Laranjais</span></a>
, <a href="/water-coaster/281/" style="text-decoration: none;" title="Go to this water coaster"> <span style="background-color: beige; color: black; padding: 10px 20px; border-radius: 50px; font-size: 16px; font-weight: bold;">Acqua Coaster - Thermas Acqualinda</span></a>

Unfortunately, there is a pesky comma that Airtable adds in between the two blocks. I tried using a second column with the formula 

 
SUBSTITUTE(WaterCoastersManufacturerHTML,",","")
 
This always gives me a #ERROR as an output, no matter what characters I have in the substitute. Note that for some other entries, there are over 50 HTML buttons for one entry. Is this some sort of weird bug, an overflow issue, or did I mess something up? Thanks!
1 Solution

Accepted Solutions
egrubis
4 - Data Explorer
4 - Data Explorer
1 Reply 1
egrubis
4 - Data Explorer
4 - Data Explorer

https://community.airtable.com/t5/formulas/error-on-very-simple-substitute/m-p/123568#M13964
This took care of it for me! Gotta convert "array" to "string". Classic