Purge string

[#1]

Hi,

some of my account numbers comes with seven zeroes in fornt, need to get rid of them, example below:

000000088899

0000000777111

00000003334

000000066666

should be presented as:

88899

777111

3334

66666

what would be the easiest way to remove these zeroes in the script?

[#2]

Pls find attached example files.

[pokassov · Accepted solution]

num(evaluate([ACCOUNT NUMBER])) as [ACCOUNT NUMBER],

[sasiparupudi1]

try
Replace([ACCOUNT NUMBER],'0000000','') as [ACCOUNT NUMBER],

[kavita25]

Check the qvw.

[qlikviewwizard]

Hi,

Please use this.

Data:

Load *,

REPLACE(LTRIM(REPLACE( [ACCOUNT NUMBER], '0', ' ')), ' ', '0') as [ACCOUNT NUMBER_1],

Replace([ACCOUNT NUMBER],'0000000','') as [ACCOUNT NUMBER_2];

LOAD [AS OF DATE],

     VER,

  [ACCOUNT NUMBER],

     AMOUNT

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[#7]

Great stuff. No idea what the evaluate function does but seems like it's working