Help

Find text within CSV string, but order varies

Topic Labels: ImportingExporting
691 0
cancel
Showing results for 
Search instead for 
Did you mean: 
EastEndTom
6 - Interface Innovator
6 - Interface Innovator

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.

0 Replies 0