Help

Extract Partial Text From Field

1713 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Vince_Forte1
4 - Data Explorer
4 - Data Explorer

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 Replies 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

THANK YOU. That’s is all I needed