instring function

[Former Member]

i have a string field that looks like this

Beneficiary: 'AB NYNAS PETROLEUM' received amount: '23064049.65' over '4'

i need to retreive the name between the ' '

it is not always a set # of characters.

[Former Member]

i am using this formula

if left({USR_CR_ALERTHIST;1.A_DESC},11)='Beneficiary'

then left ({USR_CR_ALERTHIST;1.A_DESC}, InStr({USR_CR_ALERTHIST;1.A_DESC}, "' "))

i retreive the following data

Beneficiary: 'AB NYNAS USA INC.'

then i used this formula

mid({@testing name},14)

which got what i needed. thanks anyway