Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try: subfield(Field, '-', -1)
- Marcus
=mid(Field, index(Field,'-',-1)+1)
Hi,
Try right(Field, 2)
Values can be 3 or 4 or 5 digits it is not fixed. So it will not work. But really thanks for the reply