Position Function

[Carl Smith]

I'm trying to parse out some text between ampersand characters using a global number field "Counter" within the Position function (e.g. Position( Text, "&", 0, Counter).

The Counter field is based on the PatternCount of the ampersand character within the text.

Going one step further I'm using the Middle function to hopefully get the text between the ampersands using the calculation;

Middle( Text,

Position( Text, " & ", 0, Counter) + 1,

Position( Text, " & ", 0, Counter + 1) - Position( Text, " & ", 0, Counter) - 1)

But for some reason when I want to increment the Counter field (e.g. Counter + 1)I'm not getting a result.

Can anyone help?

[Carl Smith]

I've worked out my problem and here is the answer for anyone interested.

I have found that I inadvertantly used the ampersand button in the Specify Calculation box instead of manually typing it into the Position function. The button creates "(space)&(space)" so the result didn't appear because the calculation didn't make sense.