Skip to main content

Extract Partial Text From Field

  • November 1, 2018
  • 2 replies
  • 21 views

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.

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+4

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


  • Author
  • New Participant
  • November 1, 2018

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