Strrpos

string-functions strr(ight)pos(ition)

syntax

  • strrpos(source, key)

description

The strrpos(source, key) function results in the character offset (position) of the first occurence of the key argument value in the source argument, starting from the end of the string value.

If no key value occurs as a substring in the source argument, the resulting value is null.

The strrpos function is case sensitive.

condition

The domain-unit of both arguments must match or be void (literals or parameters can be combined with data items of any domain unit).

example

attribute<uint32> strrposA (ADomain) := strrpos(A, 't');
A strposA
‘Test’ 0
‘88hallo99’ null
’+)’ null
‘twee woorden’ 11
’ test met spatie’ 2

ADomain, nr of rows = 5

see also