How to use RIGHT() for string value?

[jim_chan]

Hi guys,

i have data as such AB_apple, AB_orange,AB_lemon, CD_chicken, CD_Beef, CD_Fish.

my expected result is i only want to show result - apple, orange,lemon WITHOUT the AB_ ?

I have  tried to write this expression, it didnt work.

if(right(fieldname,3)='AB_' ,fieldname)

HElp pls!

Rgds

Jim

[sunny_talwar]

You can try this:

SubField(fieldname, '_', 2)

[jim_chan]

is u again bro. i wonder where r u living, obviously, in earth.

[jim_chan]

Sunny,

i wrote this expression as such : if(SubField(PRD_NAME, '_', 2),PRD_NAME) , not working.

[sunny_talwar · Accepted solution]

Why do you need if? This should be enough I think:

SubField(PRD_NAME, '_', 2)

[jim_chan]

thank you bro!

[jim_chan]

Sorry bro, but i only need data that start with AB_ and CD_ . how to do that?

SubField(PRD_NAME, 'AB_', 2)

[sunny_talwar]

May be this:

If(Match(SubField(PRD_NAME, '_', 1), 'AB', 'CD'), SubField(PRD_NAME, 'AB_', 2))