Hi I have a field a with a long value list which is defined to contain only specific values. But the field contains some imported data which includes entries that are not on the list and are therefore not valid and need to be replaced.

I would therefore like to do a search to find all non-valid entries so that I can edit them to conform with my list. Does anyone have any suggestions?

Please forgive me if this is a silly question, I'm not an expert at all in this.

Many thanks

eelandsaphire

Lets assume for this example:

file name = "new.fp5"

data field = "Field01"

valuelistname = "test"

Create a calculation field called: "cValidationCheck"

if(Position( ValueListItems("new.fp5" , "test") , Field01 , 1, 1) , "Y" , "N")

If I have done this correctly, it should determine instantly if the value stored in the field is a member of the value list. if it is a member of the value list the value stored in the calculation field should be a "Y", otherwise it will be a "N".

You can then do a search on this field to find any record containing an "N".

It worked perfectly! That's saved me days of work.

Thank you so much Brian C.