These last weeks I have looked at parsing text. After countless hours and having studied many splendid tips, the like of Text Parsing Tutorial by Ugo Di Luca (recommended), I must concede defeat on this one! Can any one offer help or a solution that can be applied using FMP 5.5 to the following problem.
Problem, I need to come up with a Calculation that will parse data between colon 2 and 3 into a global text field as a list i.e. each string separated by a carriage return. Using a looping script is not an option.
gData
Prefix 1:one or more words:one or more words:
Prefix 1:one or more words:one or more words:
Prefix 1:one or more words:one or more words:
Prefix 2:two or more words:one or more words:
Prefix 2:two or more words:one or more words:
gSeperator : (colon, no leading or trailing space)
Desired result needs to be dynamic so that when field _prefix contains Prefix 1
glist = one or more words
one or more words
one or more words
And when _prefix contains Prefix 2
gList = two or more words
two or more words
My best attempt so far returns the first row of data only, attempts to extend the calculation below using PatternCount have not been successful.
My calculation
Middle(
gSeperator& gData & gSeperator,
Position (gSeperator& gData & gSeperator, gSeperator, 2, 2 ) + 1,
Position (gSeperator& gData & gSeperator, gSeperator, 2, 2 ) + 1) -
Position (gSeperator& gData & gSeperator, gSeperator, 2, 2 ) - 1)
Result
gList = one or more words
Thank you in advance - Steve
