>>>>>I want to check a value in a field for the first occurrence of a space
>>>>>and report back the character length of that field value.
>>>>>any idea?
>>>>
>>>>iLength = AT( " ", FieldName )
>>>works....thanks...:)
>>
>>Actually, there is an off-by-one error. Line should be:
>>
>>iLength = AT( " ", FieldName ) -1
>Hi, Are you saying off-by-one because...
>iLength = AT( " ", FieldName ) returns value plus 1 and 1 is a space?
In the command window type:
? AT( " ", "The cat" )
Is the result three or four - and how many letters ar in the word "The" ?
censored.