I know this should be a simple one but my brain has frozen!

I am trying to script a find to find records in a table where the field data is in multiples of 3 letters (not counting spaces)...

so

AAA BBB CCC or AAABBBCCC would be fine.

But AA BBBCCC would not be returned.

I could do it with @@@ @@@@@@ but i know ther must be a way to check number of letters and see if it is a multiple of 3... can anyone tell me what I am missing here?

I know this should be a simple one but my brain has frozen!

I am trying to script a find to find records in a table where the field data is in multiples of 3 letters (not counting spaces)...

so

AAA BBB CCC or AAABBBCCC would be fine.

But AA BBBCCC would not be returned.

I could do it with @@@ @@@@@@ but i know ther must be a way to check number of letters and see if it is a multiple of 3... can anyone tell me what I am missing here?

I know this should be a simple one but my brain has frozen!

I am trying to script a find to find records in a table where the field data is in multiples of 3 letters (not counting spaces)...

so

AAA BBB CCC or AAABBBCCC would be fine.

But AA BBBCCC would not be returned.

I could do it with @@@ @@@@@@ but i know ther must be a way to check number of letters and see if it is a multiple of 3... can anyone tell me what I am missing here?

Hi,

You'd better use a Marking calculation that would result true or false according to the string.

Then do a search for 1 if True or 0 if False.

Should this be testing the alphabet order too and would ABCABCABC turn true as well ?

Hi,

You'd better use a Marking calculation that would result true or false according to the string.

Then do a search for 1 if True or 0 if False.

Should this be testing the alphabet order too and would ABCABCABC turn true as well ?

Hi,

You'd better use a Marking calculation that would result true or false according to the string.

Then do a search for 1 if True or 0 if False.

Should this be testing the alphabet order too and would ABCABCABC turn true as well ?

order of letters doesnt matter... its actually three letter codes for airports and cities

so it could be NYC LHR MIA ..... etc etc ut i need to be able to spot any that are not complete groups

order of letters doesnt matter... its actually three letter codes for airports and cities

so it could be NYC LHR MIA ..... etc etc ut i need to be able to spot any that are not complete groups

order of letters doesnt matter... its actually three letter codes for airports and cities

so it could be NYC LHR MIA ..... etc etc ut i need to be able to spot any that are not complete groups