Identify String or text and eliminate the zeros at the beginning of string

[ahidu1030]

Hello Guys,

I need to load "material number" from original file as:

00002532548452,

0000000698542,

A7B765430,

P PPXX,

78BL333

I want to have results shown as:

2532548452,

698542,

A7B765430,

P PPXX,

78BL333

Actually, to eliminate the possible zeros at the beginning. The zero appears if there is only figures.

How shall I script???

[silvacarlos]

Maybe this (I found this here How to remove the leading zero's in the alphanumeric field values)

mid([YourField],index([YourField],left(PurgeChar([YourField] , '0' ),1)))

I hope it helps!

CS