Help

Re: CONCATENATE with prefix for multiple values in the column

Solved
Jump to Solution
855 0
cancel
Showing results for 
Search instead for 
Did you mean: 
mmr1443
6 - Interface Innovator
6 - Interface Innovator

If you look at my attached images below, I'm struggling with the CONCATENATE function. I want to add the COMPANY as a  prefix to each of the multiple items listed in the PRODUCTS column, but concatenate only adds it as prefix to the first item.

I am doing this so that it will reference a price list. We offer the same products to each company, but each company has a different set of prices. 

I was going to figure out how to automate the copy/paste from PRICE CODE to PRICE, but I couldn't even figure out how to get the price code in the correct format. Thanks in advance for any help!

 

airtable 1.pngairtable 2.png

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try using `SUBSTITUTE()` instead:

Screenshot 2023-03-18 at 3.56.47 PM.png

{Company} & " " & 
SUBSTITUTE(
  {Products},
  ", ",
  "," & {Company} & " "
)

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try using `SUBSTITUTE()` instead:

Screenshot 2023-03-18 at 3.56.47 PM.png

{Company} & " " & 
SUBSTITUTE(
  {Products},
  ", ",
  "," & {Company} & " "
)

Ahhh thank you so much! This had me pulling out my hair. Really appreciate it!!! It worked like a charm.

I thought I would be able to figure out how to automate the copy/paste from "Price Code" to "Price" column, but I am struggling. Would you have any advice in that regard? Thanks!

Yeap sure, I've replied to your other post