I want to search multiple fields for a "3" character or a "3a" character but not a "3b"character and insert the found data into a new field. I have been able to use PatternCount successfully to find the 3 and 3a but can't omit the 3b.

Edited September 29, 201015 yr by Guest

I am not sure I understand what you are trying to do. Perhaps you need something like PatternCount ("3") - PatternCount ("3b")?

By the way, I am defining a new field. I have since solved the problem by using the following formula:

Line3=

Case (

PatternCount ( Class2 ; "3" )>0 and not PatternCount ( Class2 ; "3b" )>0 ;Class2;

PatternCount ( Class3 ; "3" )>0 and not PatternCount ( Class3 ; "3b" )>0 ;Class3;

PatternCount ( Class5 ; "3" )>0 and not PatternCount ( Class5 ; "3b" )>0 ;Class5;

PatternCount ( Class7 ; "3" )>0 and not PatternCount ( Class7 ; "3b" )>0 ;Class7;

"other"

)

I found a page in a google book which gave me a clue...

...thanks anyway

Edited September 30, 201015 yr by Guest