topic Extract numbers in QlikView

Extract numbers

pgalvezt — Wed, 29 Jun 2016 19:32:44 GMT

Hello,

I have this:

FieldNumbers:

0009533544-2

0005345344-0

0012445665-4

0013445332-K

I would Like to Obtain This:

9533544-2

5345344-0

12445665-4

13445332-K

Thanks!

sunny_talwar — Wed, 29 Jun 2016 19:35:41 GMT

Try this:

Table:

LOAD SubField(FieldNumbers, '-', 1) * 1 & '-' & SubField(FieldNumbers, '-', 2) as FieldNumbers;

LOAD * Inline [

FieldNumbers

0009533544-2

0005345344-0

0012445665-4

0013445332-K

];

maxgro — Wed, 29 Jun 2016 19:51:17 GMT

maybe

Table:

LOAD

Replace(Ltrim(Replace(FieldNumbers, '0', ' ')), ' ', '0');

LOAD * Inline [

FieldNumbers

0009533544-2

0005345344-0

0012445665-4

0013445332-K

];

MarcoWedel — Wed, 29 Jun 2016 22:34:23 GMT

Hi,

an alternative solution might be to purge the leading zeros like:

Replace(Replace(LTrim(Replace(Replace(FieldNumbers,' ','@SPACE@'),'0',' ')),' ','0'),'@SPACE@',' ')

Mid(FieldNumbers,FindOneOf(FieldNumbers,PurgeChar(FieldNumbers,'0')))

hope this helps

regards

Marco