Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ALl
there is a field by name Lead which has the following content
Lead:
abc_dp
abc_dp1
ABC_dp
ABC_WE
Yzx_r
art
bed
sem
...
i want only those which start from abcor ABC content only
to this iam tying to apply this condition
where Lead:='ABC'; after loading this i dont see any content . can someone try to help me out with this
give a try below
LOAD * INLINE [
lead
abc_tp
abc_dp1
ABC_dp
ABC_WE
YZX_r
art
bed
sem
];
min_temp:
load upper(lead) as lead_ABC Resident main_table where WildMatch( UPPER(lead),'ABC*');
Hello!
Try using left() and trim() functions.
"...Where Left(trim(Lead),3) = 'ABC' or Left(trim(Lead),3) = 'abc'"
or with match() function:
"...Where Match(Left(trim(Lead),3),'ABC','abc') "
Hi John,
maybe
LOAD * Inline [
Lead:
abc_dp
abc_dp1
ABC_dp
ABC_WE
Yzx_r
art
bed
sem
]
Where SubField([Lead:],'_',1)='ABC';
Regards,
Antonio
TRY THIS
Select *
From xxxxxxx
Where lEAD IN ( 'abc*',ABC*');
or you can do it in the preceding load
LOAD *
Where Match(Lead, 'abc*','ABC*');
Select *
FROM xxxxxxx;
Hi John
main_table:LOAD * INLINE [
lead
abc_tp
abc_dp1
ABC_dp
ABC_WE
YZX_r
art
bed
sem
];
min_temp:
load lead as lead_ABC Resident main_table where WildMatch( lead,'ABC*');
excute this you will get field name start with ABC
orelse try in simple
Data:
LOAD * INLINE [
lead
abc_tp
abc_dp1
ABC_dp
ABC_WE
YZX_r
art
bed
sem
]
Where WildMatch(lead,'ABC*');
Result:
Also try this,
Lead:
LOAD Lead
FROM
Table.xlsx
(ooxml, embedded labels, table is Sheet1)
Where WildMatch(Lead,'ABC*','abc*')
;
Hi Chanty it works
Cant i make everythins as capital and get the output .?
all small abc_* should appear in capitals letters
good
it will work for both
Use Captalise () fuction or upper () function before field name