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?
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
