Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
In the field Comments I need to search for the characters Name: and //
example:
Name: Laura Gil Mejia //, Extended Warranty.
I need to put a 1 if you find Name: and //. or a 0 if you can not find it.
Can you help me ?
Maybe like
LOAD
Comments,
If(WildMatch(Comments, '*Name:*//*'),1,0) as Flag,
...
I have a question I need to look for have these two characters Name: and // have some records where they only have //.
with this solution I look at the two characters or any of them?
The Comments field value needs to show 'Name:' as well as '//', and '//' needs to follow 'Name:'.
I have problems I identify the condition in true case but in false case I can not imagine it is because it does not find the words and sees a Null
Can you please provide the sample of TRUE and FALSE conditions with Sample Data and expected results?