List Box?

[prajapatiamar38]

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

[antoniotiman · Accepted solution]

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

];

[krishna20]

Hi Try this,

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

it will works..

[jonathandienst]

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

[prajapatiamar38]

Thanks ANTONIO MANCINI,

Its really helpful.

[antoniotiman]

Thanks Amarnath,

I,m glad I was helpful.

Regards,

Antonio