Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Aug 25, 2022 09:39 PM
Hello All,
I am trying to convert a concatenated text cell into various records, split by the semi-column.
Ideally, an automation would somehow split the cell contents so I can return the linked lookup value for both Optimisers, and Double Storey and their relevant costs in another lookup column.
Is there a way I can split the contents into separate records for the pricing data column?
Aug 25, 2022 10:16 PM
Hi @Luca_Wessels ,
Just to confirm, you’d like to end up with the following, is that right?
If so, if you split your text by a comma instead of a semi-colon, you can paste that text into the Pricing Data
linked field and it would become separate records based on the comma split automatically