topic Re: trimming the field values in QlikView

trimming the field values

abhijith28 — Thu, 22 Nov 2018 10:17:12 GMT

Please someone help with this issue.

i have a field values as:

Field Name:- String

banarus

Animal

Lib-antartica

i need the output as: "an" if i select the field "String", all other alphabets should be eliminated

shiveshsingh — Thu, 22 Nov 2018 10:23:00 GMT

Plz try this.

Keepchar(String,'ab') as String

abhijith28 — Thu, 22 Nov 2018 11:10:28 GMT

Suppose if i want the output as:

String:

A-Q1_asg

Bgf-Q1

lsdQ1rts

Q2-tyu

uyQ2ih

if there is"Q1" in any field value, then the field name should be Q1. if Q2 then field name should be Q2.

shiveshsingh — Thu, 22 Nov 2018 11:33:08 GMT

T:LOAD * INLINE [
F
A-Q1_asg
Bgf-Q1
lsdQ1rts
Q2-tyu
uyQ2ih
];
NoConcatenate

F:LOAD IF(WildMatch(F,'*Q1*')=1,KeepChar(F,'Q1')
,KeepChar(F,'Q2'))AS F
Resident T ;

DROP TABLE T;