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.
You can try this:
SubField(fieldname, '_', 2)
is u again bro. i wonder where r u living, obviously, in earth.
i wrote this expression as such : if(SubField(PRD_NAME, '_', 2),PRD_NAME) , not working.
Why do you need if? This should be enough I think:
SubField(PRD_NAME, '_', 2)
thank you bro!
Sorry bro, but i only need data that start with AB_ and CD_ . how to do that?
SubField(PRD_NAME, 'AB_', 2)
May be this:
If(Match(SubField(PRD_NAME, '_', 1), 'AB', 'CD'), SubField(PRD_NAME, 'AB_', 2))
Retrieving data ...