Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
prajapatiamar38
Creator II
Creator II

List Box?

Hi Community,

I have one inline table.

LOAD * INLINE [

    ID

    00001234

    000546

    00000768

    00007777

    00005867

    000qdsf

    000bfn

    0000abcd

    000005464

    80000000y

];

My requirement is i want to remove zeros and my output should be like this 1234,456,abcd,8000000y...

I want in list box only how can i do this..

Thanks

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi,

=Alt(Num(ID),If(Left(ID,1)=0,PurgeChar(ID,'0'),ID))

Regards,

Antonio

View solution in original post

6 Replies
antoniotiman
Master III
Master III

Hi,

=Alt(Num(ID),If(Left(ID,1)=0,PurgeChar(ID,'0'),ID))

Regards,

Antonio

MayilVahanan

Hi

Try like this

LOAD *, Mid(ID, FindOneOf(ID, '123456789abcdefghijklmnopqrstuvwxyz')) as FinalID  INLINE [

    ID

    00001234

    000546

    00000768

    00007777

    00005867

    000qdsf

    000bfn

    0000abcd

    000005464

    80000000y

];

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
krishna20
Specialist II
Specialist II

Hi Try this,

=If(Left(ID,1)=0,PurgeChar(ID,'0'),ID)

it will works..

jonathandienst
Partner - Champion III
Partner - Champion III

=Alt(Num(ID), Replace(Trim(Replace(ID, '0', ' ')), ' ', '0'))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
prajapatiamar38
Creator II
Creator II
Author

Thanks ANTONIO MANCINI,

Its really helpful.

antoniotiman
Master III
Master III

Thanks Amarnath,

I,m glad I was helpful.

Regards,

Antonio