Dynamic list using delimited values from Excel file

Craig Leininger

• April 27, 2018 21:02

I am designing a product label for a paint manufacturer. Each SKU has a variable list of color variations. I am defining these in an Excel spreadsheet in a column named "ColorVariations" as a delimited list of values (i.e. "Desert Rose;Sand;Forest Sunset"... etc) for each SKU.

I would like to translate this retrieved value into a unordered list to print on the label.

Example:

Desert Rose
Sand
Forest Sunset

Looking for some guidance on the most elegant way to do this without VB scripting.

Thanks!

0

• 

  Craig Leininger

  ★ BarTender Hero ★

  • April 28, 2018 03:52

  The solution was right in front of my nose - by replacing the delimiter with <<CR>> I was able to do this easily.

  0

Please sign in to leave a comment.