Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Find text within CSV string, but order varies

Topic Labels: ImportingExporting
944 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