topic Re: remove values after space in field in QlikView

remove values after space in field

Mon, 15 Dec 2014 15:39:08 GMT

Hi all

Field has values like below.

Desired output:

5as

nbg5

Thanks.

Re: remove values after space in field

daveamz — Mon, 15 Dec 2014 15:41:44 GMT

Hi,

Try subfield(s, 'delimiter' [ , index ] )

Re: remove values after space in field

MK_QSL — Mon, 15 Dec 2014 15:43:16 GMT

Left(Value,Index(Value,' ')-1)

Re: remove values after space in field

MarcoWedel — Mon, 15 Dec 2014 15:49:30 GMT

Subfield(field, ' ', 1)

Re: remove values after space in field

saurabh5 — Mon, 15 Dec 2014 16:04:22 GMT

hi Koushik,

if you have two delimiters you can use the below expression,

=SubField(Replace(F1,',','-') ,'-',1)

where F1 is the field with your values.

Regards

Saurabh

Re: remove values after space in field

Mon, 15 Dec 2014 16:38:29 GMT

Thanks guys. Lets say I have something like

2:45AM - 2:50PM 0.08 (5) or 8:30AM - 8PM 11.5 (3)

and I would like to display only AM and PM values such as 2:45AM - 2:50PM ; 8:30AM - 8PM

Regards

Re: remove values after space in field

MK_QSL — Mon, 15 Dec 2014 16:43:27 GMT

Convert

2:50PM 0.08 to 2:50PM as below

=TIME(Time#('2:50PM 0.08','h:mmTT f.ff'),'h:mmTT')

Re: remove values after space in field

anbu1984 — Mon, 15 Dec 2014 16:44:18 GMT

Load Subfield(Time,'P',1) & 'PM' Inline [

Time

2:45AM - 2:50PM 0.08 (5)

8:30AM - 8PM 11.5 (3) ];

Load SubField(Txt,' ',1) & ' - ' SubField(Txt,' ',3) & ' ; ' SubField(Txt,' ',7) & ' - ' SubField(Txt,' ',9) Inline [

Txt

2:45AM - 2:50PM 0.08 (5) or 8:30AM - 8PM 11.5 (3)

];

Re: remove values after space in field

Mon, 15 Dec 2014 16:55:19 GMT

Thanks guys. Got it.