Last value in string

[#1]

Hi,

I have Field values like,  001-AB-002-CD, 11-AB , AS-001-AK. Now I want to find the last value from string. For these values, I want to find CD,AB, AK

[marcus_sommer · Accepted solution]

Try: subfield(Field, '-', -1)

- Marcus

[Kushal_Chawda]

=mid(Field, index(Field,'-',-1)+1)

[Anonymous]

Hi,

Try right(Field, 2)

[#5]

Values can be 3 or 4 or 5 digits it is not fixed. So it will not work. But really thanks for the reply