Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Plz try this.
Keepchar(String,'ab') as String
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.
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;