Wildmatch()

[v_jaideep]

Hello,

I have list of 500 products, if product  contains *new* (either at start, end or in between)it should be as 'New' else it should be 'old'

I have tried pick(wildmatch(product,'*new*'),'New','Old) in script, it does not give output as Old , it just gives oytput as only 'New'.

What am I missing /doing wrong here.

[marcus_sommer · Accepted solution]

Try it in this way:

pick(wildmatch(product,'*new*', '*'),'New', 'Old')

or with a simple if-loop, like:

if(product like '*new*','New', 'Old')

- Marcus

[v_jaideep]

Thanks Marcus, I'm looking only for wildmatch() possibilities.

[emilyrabbit]

if(wildmatch([product],'*new*')>0,'New','Old')