Search Characters in text

[gr_eldred]

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 ?

[swuehl]

Maybe like

LOAD

     Comments,

     If(WildMatch(Comments, '*Name:*//*'),1,0) as Flag,

     ...

[gr_eldred]

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?

[swuehl]

The Comments field value needs to show 'Name:' as well as '//', and '//' needs to follow 'Name:'.

[gr_eldred]

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

[jayanttibhe]

Can you please provide the sample of TRUE and FALSE conditions with Sample Data and expected results?