Subfield with Set Analysis

[Anonymous]

I have a field called PERMISSIONS,

PERMISSIONS

TENNIS|A|B|C

TENNIS|A|B|C|D

TENNIS|A|B|C|D|E

I have 3 rows in PERMISSIONS,

I want to take only the first row, and display the last text from it

in this case, it is C from the first row and display it in the text object

How can i do that ?

It didn't worked..

[Peter_Cammaert]

Yes you can do that.

Create a listbox with an Expression (instead of a Field Name) like:

=SubField(PERMISSIONS, '|', -1)

The negative third parameter of SubField() tells the function to start parsing from the end instead of the front of the string.