I have some item descriptions that have an Alcoholic volume at the end of the description. I need to supress the volume as this is being shown elsewhere on my report. But note, not all descriptions have the volume at the end so simply cutting the last 3 digits wont work. e.g.
CARLING 4.0
But i am already using a formulae for my description because i also had unwanted information at the beggining of my description.
trimleft(mid({FRL_LIVE_Item.Description}, instr({FRL_LIVE_Item.Description}," ")+1))
Any help would be greatly appreciated.
AdamRicko
CR2008
CARLING 4.0
But i am already using a formulae for my description because i also had unwanted information at the beggining of my description.
trimleft(mid({FRL_LIVE_Item.Description}, instr({FRL_LIVE_Item.Description}," ")+1))
Any help would be greatly appreciated.
AdamRicko
CR2008