Find in multiple fields

[JitseSchaafsma]

This is driving me crazy.

I have a database with record with three fields : veld1; veld2 and veld3 (yes indeed i am dutch)

Now i want to perform a find script that finds records with

veld1 contains text to find

veld2 contains zero or more characters

veld3 contains nothing

How should i define the necessary fields steps

specifically how to set the field veld3 to nothing ?

Thanks

Jitse Schaafsma

[RalphL]

Use the following script

Find

Enter Find Mode

Set Field [ vel1 , "your text" ]

New Record/Request

Insert Calculated Result [ veld3 , "*" ]

Omit Record

Perform Find

Since veld 2 can be anything don't include it the find.

[JitseSchaafsma]

Okay, i admit, i feel like an idot,

i can not get it two work.

Again, an example

this is my date

record number veld1 veld2 veld3

1 A

2 A A

3 A A A

4 AA A A

could someone please show me the script steps i need

to find only record number 1.

(*in brwoser/find mode i have know problem *)

I am very gratefull

Jitse

[CyborgSam]

There's a typo in Ralph's script: Insert Calculated Result [ veld3 , "*" ]

Should be: Insert Calculated Result [ veld3 , "=" ]

In Find mode, =Something searches for an exact match. = alone searches for empty fields. * alone is the opposite of = alone: it searches for any none-empty field.

Does this work now?