Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

remove values after space in field

Hi all

Field has values like below. 

Desired output:


5as

1

nbg5

Thanks.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

8 Replies
daveamz01
Creator III
Creator III

Hi,

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

MK_QSL
MVP
MVP

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

View solution in original post

MarcoWedel

Subfield(field, ' ', 1)

saurabh5
Creator II
Creator II

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

Not applicable
Author

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

MK_QSL
MVP
MVP

Convert

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

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

anbu1984
Master III
Master III

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)

];

Not applicable
Author

Thanks guys. Got it.