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?
+31Hi @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
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.