probably a dumb question

[Chalkster]

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?

[Chalkster]

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?

[Chalkster]

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?

[Ugo DI LUCA]

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 ?

[Ugo DI LUCA]

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 ?

[Ugo DI LUCA]

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 ?

[Chalkster]

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

[Chalkster]

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

[Chalkster]

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