Hi there,
I’m looking for help extracting portions of CSV text within a long array, but the order within varies. For example…
Record 1 Array:
Text01,Text-style02,Text-variation03
Record 2 Array:
Text-syle02,Text-type04
Record 3 Array:
Text-type04
Could someone point me towards a FIND formula that will display just one of each of these in a unique field, please? And ideally the start info is trimmed off, too. Resulting data…
Record__Text___Text-style___Text-variation___Text-type
1_______01____02________ 03____________________
2_____________02_______________________04_____
3______________________________________04_____
I’ve been going round the houses trying to find a solution, any help very much appreciated.
Thanks all.
