Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
Needed help on Wildmatch().
Sample data
Description |
---|
MY WALLET - CASHBACK - NU27011981410574 |
MY WALLET - CASHBACK - NU77010981580515 |
MY WALLET - CASHBACK - NU77010981592963 |
BURN |
I want to tag against those descriptions where it contains MY WALLET.
Code :- if(Wildmatch(Description,'%MY WALLET%'),'Yes','No')
But its not working its returning No.
Please help.
Thank you in advance,
Girish
I think you need to check which chars your data really contain - quite useful is in such cases an editor like notepad++.
Another try for testing could be:
if(Wildmatch(Description,'*MY*WALLET*'),'Yes','No')
or
if(Wildmatch(Description,'*MY*','*WALLET*'),'Yes','No')
- Marcus
Try: if(Wildmatch(Description,'*MY WALLET*'),'Yes','No')
- Marcus
Yes, please have a look at the HELP pages:
"It permits the use of wildcard characters ( * and ?) in the comparison strings. "
Thank you guys for the prompt reply!
Would like to correct the code
Wildmatch(Description,'*MY WALLET*')
But still it's not working.
Inspire of above code even I tried using replace function to replace MY WALLET string to MY_WALLET and in that MY_WALLET string I tried using wildmatch but still the same result.
I know replace is not required in this case but still tried working out but no proper result.
Agreed Stefan n Marcus!!!
Tried but still the same issue.
For me it worked:
- Marcus
Hey Marcus,
Yup this same is working on text object.
But when it's applied in the script level it's not worked.
Even I can't understand.
Thank you,
Girish
I think you need to check which chars your data really contain - quite useful is in such cases an editor like notepad++.
Another try for testing could be:
if(Wildmatch(Description,'*MY*WALLET*'),'Yes','No')
or
if(Wildmatch(Description,'*MY*','*WALLET*'),'Yes','No')
- Marcus
Thank you very much Marcus!!!!
Will check and revert.
Thank you,
Girish
Thank u Marcus!!!!! It worked.