topic identify String or Text and eleminate the zeros at the beginning in App Development

identify String or Text and eleminate the zeros at the beginning

ahidu1030 — Thu, 24 Aug 2017 12:38:09 GMT

Hey Guys,

I have a dimension "Material Number", where the numbers can be

000002525451012,

0000000695748,

P IND XXX,

B7TRCXX

As result I shall get:

2525451012,

695748,

P IND XXX,

B7TRCXX

if only contains figures and there are zeros at the beginning then the zeros at the beginning have to eliminated. If it contains Letters, the material number shall remain so.

How shall I write in the script?

thank you.

Re: identify String or Text and eleminate the zeros at the beginning

sunny_talwar — Thu, 24 Aug 2017 15:42:40 GMT

Check here:

How to Trim Leading Zero's from Numeric value of a Alpha Numeric datatype‌

If(IsNum(Replace(LTrim(Replace(CUSTOMER,'0',' ')),' ','0')), Replace(LTrim(Replace(CUSTOMER,'0',' ')),' ','0'), CUSTOMER) as Customer

Alt(Num(Replace(LTrim(Replace(CUSTOMER,'0',' ')),' ','0')), CUSTOMER) as Customer

Re: identify String or Text and eleminate the zeros at the beginning

antoniotiman — Thu, 24 Aug 2017 15:52:28 GMT

Alt(Num(Left(Field,14)),Field)

Re: identify String or Text and eleminate the zeros at the beginning

ahidu1030 — Fri, 25 Aug 2017 07:50:05 GMT

It works perfectly!!!!

Thanks a lot. Exactly the same problem as in the referenced post.