Display only the right 15 characters of a field.

[evansabres]

Hello -

I have a field, called cmpFULLNME, that contains the following data : FNC - 01072015 - WWE VIP. I only want the 'WWE VIP' to display as a dimension in my graph as opposed to the full string.

What would the expression be for this?

Thank you.

[anbu1984 · Accepted solution]

Substring(cmpFULLNME,'-',-1)

[maxgro]

=right(cmpFULLNME, len(cmpFULLNME)-15)

[sujeetsingh]

You can use th e Subfield function as well as logic combined with len() and right() function as by Massimo

[MarcoWedel]

please post some more values of cmpFULLNME to clarify possible solutions.

thanks

regards

Marco