Hi Andy weir,
Thanks a lot for the reply.
I have a data like 1.1.6 and 1.1.7 like that but when i applied the =right(fieldname,2) then it's taking .6 and .7.
how can i exclude "." when i have single value.
same way when i have value 1.1.213 how can i select only 213.
All these must be in one expression.