Splitting a data field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 5-character data field that I would like to split into a filed
containing characters 1 and 2, and a second field containing characters 3
thru 5. Can't figure it out - help greatly appreciated.
 
You can use 2 calculated field to do this.

FirstPart: Left([SomeField],2)
LastPart: Right([SomeField],3)
 
Back
Top