find "not including" text

[Impart]

I need to write a complex search, 1 aspect will be to determine if a text field does not contain the word 'video'.

 

[paulbent]

This is the find condition, substitute your own table & field names

If(Position(Upper(Table.Field), 'VIDEO', 1) = 0)

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[Impart]

Thanks Paul, it works fine but I don't see how. I can understand the Position statement but I have only seen IF documented as IF(test,then if true, else if false).
This looks like IF(test)
Can you enlighten on this version of If please.

 

[paulbent]

In Find mode, you can enter a condition as a formula that evaluates to True or False and in that formula you can use the same functions as in calculated fields. The formula can also compare fields in the record with values in variable fields. It's a powerful tool!

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk