Trim Field values

[#1]

UGSCU-G

QUSJIE-G

when field values are like this if i want to omit the '-G' just to get

UGSCU

QUSJIE

????

[Anonymous]

hi khushi,

                 1 option is to change all tat symbols into one unique symbol n den use index function or subfiled function.....

regards,

Vaibhav