trimming the field values

[abhijith28]

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 · Accepted solution]

Plz try this.

Keepchar(String,'ab') as String

[abhijith28]

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 · Accepted solution]

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;