Skip to main content
Solved

CONCATENATE with prefix for multiple values in the column

  • March 17, 2023
  • 4 replies
  • 35 views
M
Forum|alt.badge.img+8

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!

 

Best answer by TheTimeSavingCo

Try using `SUBSTITUTE()` instead:

 

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

4 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6414 replies
  • Answer
  • March 18, 2023

Try using `SUBSTITUTE()` instead:

 

{Company} & " " & SUBSTITUTE( {Products}, ", ", "," & {Company} & " " )
Adam, Airtable Consultant - thetimesaving.company
M
Forum|alt.badge.img+8
  • mmr1443
  • Author
  • Inspiring
  • 16 replies
  • March 20, 2023

Try using `SUBSTITUTE()` instead:

 

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

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

M
Forum|alt.badge.img+8
  • mmr1443
  • Author
  • Inspiring
  • 16 replies
  • March 29, 2023

Try using `SUBSTITUTE()` instead:

 

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

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!

TheTimeSavingCo
Forum|alt.badge.img+31

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

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement