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

ahidu1030 — Thu, 24 Aug 2017 13:13:57 GMT

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???

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

silvacarlos — Fri, 25 Aug 2017 16:48:33 GMT

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

I hope it helps!