Oct 12, 2020 01:39 PM
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…