topic Re: How can I get 566 and 2657 in string in QlikView

How can I get 566 and 2657 in string

suzel404 — Tue, 02 Dec 2014 13:40:15 GMT

Hi all,

How can I get 566 and 2657 in string :

5-300 | 6-800 | 6-805

2-300 | 6-455 | 5-899 | 7-800

Thanks for your help.

Re: How can I get 566 and 2657 in string

ThornOfCrowns — Tue, 02 Dec 2014 13:50:22 GMT

Adding it to the string or taking it out?

Re: How can I get 566 and 2657 in string

its_anandrjs — Tue, 02 Dec 2014 13:54:11 GMT

Hi,

Load this way

LOAD String,Left(Trim(SubField(String,'|')),1) as New;

LOAD * Inline

[

String

5-300 | 6-800 | 6-805

2-300 | 6-455 | 5-899 | 7-800

];

NoConcatenate

LOAD

String,

Concat(New,'') as NewString

Resident S

Group By String;

DROP Table S;

Regards

Anand

Re: How can I get 566 and 2657 in string

morganaaron — Tue, 02 Dec 2014 13:54:46 GMT

Not an elegant solution but:

Left(SubField(PurgeChar([Field Name],' '),'|',1),1) & Left(SubField(PurgeChar([Field Name],' '),'|',2),1) & Left...

Where [Field Name] is the name of your field above, and then repeat this as many times as you needed (in your example you'd need 4) changing the number after the '|' delimiter in the SubField function.

Re: How can I get 566 and 2657 in string

anbu1984 — Tue, 02 Dec 2014 14:03:06 GMT

Load PurgeChar(Left(Txt,1) & TextBetween(Txt,'|','-',1) & TextBetween(Txt,'|','-',2) & TextBetween(Txt,'|','-',3) & TextBetween(Txt,'|','-',4),' ') As Str;

Load * Inline [

Txt

5-300 | 6-800 | 6-805

2-300 | 6-455 | 5-899 | 7-800 ];

Re: How can I get 566 and 2657 in string

suzel404 — Tue, 02 Dec 2014 22:51:40 GMT

Thanks you for your response!!