rpos()

Function groupExecute on clientPlatform(s)
StringYESAll

Syntax

rpos(substring,string)

Description

Returns the 1-based position of the last occurrence of substring in string,or zero if substring is not contained in string

The substring must be contained within string in its entirety for the returned value to be non-zero. Also, the comparison is case sensitive.

Example

Calculate
 
lResult
 as 
rpos
(
'Mouse'
,
'Mickey Mouse'
)

# returns 8

 
Calculate
 
lResult
 as 
rpos
(
'mouse'
,
'Mickey Mouse'
)

# return 0, note case

 
Calculate
 
lResult
 as 
rpos
(
' '
,
'R S W Smith'
)

# returns 6, that is the position of the last space character