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..

[el_aprendiz111]

Hi,

=Concat(chr(13) & subfield(PERMISSIONS,'|',2))

[Anonymous]

Thanks for the help.

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 ?

[Frank_Hartmann]

Maybe like that:

Load *, RowNo() as Row;
Load * INLINE [
PERMISSIONS
TENNIS|A|B|C
TENNIS|A|B|C|D
TENNIS|A|B|C|D|E
];

Textboxexpression:

=right(only({<Row={'1'}>}PERMISSIONS),1)

[Peter_Cammaert]

What do you mean by "first row"? In a listbox? And what if the sort order is reversed? Do you take the last row?

[Peter_Cammaert]

If you want the first value from the symbol table of field PERMISSIONS, you can use

=SubField(FieldValue('PERMISSIONS', 1), '|', 4)

but that will depend on the load order of the PERMISSIONS values...

[its_anandrjs]

Can you check with this in any text object

=Only(SubField(PERMISSIONS,'|',4))

[its_anandrjs]

You can try this way

LOAD *,

RowNo() AS rid;

LOAD * Inline

[

PERMISSIONS

TENNIS|A|B|C

TENNIS|A|B|C|D

TENNIS|A|B|Z|D|E

];

In text object

=Only( {<Leng={12} >} SubField(PERMISSIONS,'|',4))

[Anonymous]

I should display the Last text after ' | ', it can be any line.

One row can have any no of '|', but i should display only the last text after ' | '.

And also the row values can be of any length as below

PERMISSIONS

TENNIS|Austraila|Britain|india

TENNIS|AAAA|BB|CCC|DDD

TENNIS|A|B|C|DEF|GE

How can i achieve that ?

[antoniotiman]

Hi,

may be this

LOAD FirstSortedValue(DISTINCT String,-Count) as MaxString;
LOAD *,SubStringCount(PERMISSIONS,'|') as Count,SubField(PERMISSIONS,'|',-1) as String Inline [
PERMISSIONS
TENNIS|Austraila|Britain|india
TENNIS|AAAA|BB|CCC|DDD
TENNIS|A|B|C|DEF|GE
];

Regards,

Antonio