January 31, 200619 yr FMP searches are case insensitive by default. However in FMP 6 and earlier setting the field's sort language to ASCII will make it case sensitive. Though I haven't tried it with 7/8, try setting the language to Unicode.
January 31, 200619 yr Author I want to search for any Upper case character after the first letter. want to find out how many characters are Upper case. thanks
February 1, 200619 yr You might try this ... create a calculation (result is number): Length ( Filter ( Middle ( text ; 2 ; Length ( text ) ) ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ) This should produce the number of upper case characters IGNORING the first character (in field called text). Search the calculation field for > 0.
Create an account or sign in to comment