Extract Partial Text From Field


#1

I have a # field and I would like to have another field that ='s the first 3 digits of the #field.

Example. # field = 201-11-211. I would like to have another field that would = 201. The first 2 digits.


#2

Hi Vince

I hope I’m not missing something obvious - but can’t you simply use a formula field using the Left() function?

See Formula Field Reference


#3

THANK YOU. That’s is all I needed