Showing results for 
Search instead for 
Did you mean: 

instring function

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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