Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Convert comma separated listed into individual cells

Topic Labels: Formulas
280 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone,

I have a cell that contains a comma separated list of images, examples below, I’d like to separate each value into a new cell, however I’d like this value to be strictly the url. Does anyone know how I can get this solution?

Thanks in advance

EX:

LIST:
2020-10-09 08.59.08.jpg (https://dl.airtable.com/.attachments/0394c79d/2020-10-0908.59.08.jpg),2020-10-09 08.59.37.jpg (https://dl.airtable.com/.attachments/c9a6eabc/2020-10-0908.59.37.jpg),2020-10-09 09.00.14.jpg (https://dl.airtable.com/.attachments/e15451a9/2020-10-0909.00.14.jpg),2020-10-09 09.00.26.jpg (https://dl.airtable.com/.attachments/cd631799/2020-10-0909.00.26.jpg),2020-10-09 09.00.41.jpg (https://dl.airtable.com/.attachments/6cd5bde0/2020-10-0909.00.41.jpg),2020-10-09 09.01.03.jpg (https://dl.airtable.com/.attachments/fc16571d/2020-10-0909.01.03.jpg)

DESIRED END RESULT

Cell 1
https://dl.airtable.com/.attachments/0394c79d/2020-10-0908.59.08.jpg

Cell 2 (Right of cell 1 on the same row)
https://dl.airtable.com/.attachments/c9a6eabc/2020-10-0908.59.37.jpg

Cell 3 (Right of cell 2 on the same row)
https://dl.airtable.com/.attachments/e15451a9/2020-10-0909.00.14.jpg

etc…

0 Replies 0