Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ahidu1030
New Contributor II

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

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

1 Reply
silvacarlos
Contributor II

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

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