topic Convert String into Double + String in QlikView

Convert String into Double + String

userid128223 — Tue, 31 Oct 2017 19:39:12 GMT

Thx

How do you read a string and convert into DUAL + STRING and also remove leading zeros.

String:

AIOU002343443

000000URREI34343438

vvira1316 — Tue, 31 Oct 2017 19:54:51 GMT

Hi,

Include more sample data to better understand the patterns and to come up with logic/functions that will help you.

BR,

Vijay

sunny_talwar — Tue, 31 Oct 2017 23:53:48 GMT

What would be the expected output in the above sample data?

prma7799 — Wed, 01 Nov 2017 03:07:13 GMT

Please share sample file with expected output.

tresB — Wed, 01 Nov 2017 04:53:48 GMT

May be this?

=Dual(<YourString>, Replace(Ltrim(Replace(Keepchar(<YourString>,'1234567890'),'0',' ')), ' ','0'))

jonathandienst — Wed, 01 Nov 2017 05:13:11 GMT

Perhaps this:

Dual(

Replace(LTrim(Replace(field, '0', ' ')), ' ', '0'),

Num(KeepChar(field, '0123456789'))

)

The Replace() will strip the lading zeroes from the text part and the Num() will strip the leading zeroes from the numerical portion.