condition

[smilingjohn]

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

[asgardd2]

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') "

[antoniotiman]

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

[Chanty4u]

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;

[Anonymous]

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

[Chanty4u]

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:

[susovan]

Also try this,

Lead:

LOAD Lead    

FROM

Table.xlsx

(ooxml, embedded labels, table is Sheet1)

Where WildMatch(Lead,'ABC*','abc*')

;

[smilingjohn]

Hi Chanty it works

Cant i make everythins as capital and get the output .?

all small abc_* should appear in capitals letters

[Chanty4u]

good

it will work for both

[Anonymous]

Use Captalise () fuction or upper () function before  field name