Find <

[beckham]

Hi , I am trying to "find" where a field contains less the the correct number of characters but it appears not to work.

I have a barcode field that should always have 12 digits, but some have less than this and i need to find and isolate them.

 

I thought using the Find mode <12 would work but it apears not, can anyone please advise?

 

FMpro V12.04 MacOSX 10.8.3

 

Many thanks

[hbrendel]

You could make a calculation field (type Number) with the formula:

 

Length ( YourBarcodeFieldName )

 

Then execute the above Find on that field.

 

HTH

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Pro 12" to "Calculation Engine (Define Fields)".

 

The version topics (i.e. FileMaker 12)  are reserved for discussion of the new tools, functions and features introduced with that version of FileMaker, and not for asking How-To questions.

 

Lee 

[bruceR]

Though a calc field would work, and could be a good idea, you can do this with a standard find.

 

Note that the @ character in find mode can be used to represent any single character.

 

In my example, I have phone numbers formatted to use 12 characters:

 

###-###-####

 

Therefore, entering find mode, putting in 12 "@" characters, choosing omit, and performing the find, shows me all records which do NOT have 12 characters in the phone number field.

[beckham]

Many Thanks Guys!

Both these suggestions worked perfectly