I'm trying to build a character count into a formula. Basically, if field 1 is 9 characters long, I want it to give me a certain value in a new column. I can't seem to figure out how to do this. I'm not matching a certain character, just need a count of the characters in field 1. Any suggestions?
Solved! Go to Solution.
IF Length([Field 1] = 9 THEN "NINE" ELSE Null() ENDIF
Null() could be anything that you wanted. "NINE" could be "9" or 9 depending upon the data type. You could even just make the column a byte and use:
Length([Field 1])
Then decide what to do later....
That did exactly what I needed. Thank you!