count characters of field values

[hopkinsc]

hi, i was wondering if there was an easy way to only have values of a field if the number of characters = 3.

does anyone know of a way i can do this in the script please?

[sbaldwin]

you could try creating a new field using If and len(your_field) = 3 ?

Thanks

Steve

[israrkhan]

hi, try like below..

if(len(Field)=3, Field,' ')

hope it helps

[#4]

If you do it in the loading scrip you can use a where statement ex.

load field1 from source.txt where len(field1) = 3;