how to remove NullValues and 0

[rohit214]

hi all

i have data like

barcode

000001

0 1012

00 111

002222

000088

i want to get barcode shown in below format

barcode

1

112

111

2222

88

thanks

rohit

[SunilChauhan]

use thee below code

mid(barcode,findoneof(barcode,'123456789'),len(barcode)-1) as Barcode

[#3 · Accepted solution]

Try this ....

=KeepChar(barcode ,123456789)

Regards,

Antony

[rohit214]

hi sunil

thanks for ur replay

but it shows like

barcode

1

1012

111

2222

88

thanks

rohit

[#5]

KeepChar(barcode ,123456789) as barcode