View Single Post
  #1   Report Post  
Phil
 
Posts: n/a
Default Need insert a dash in between last 4 digits in text string

I have a column (TractID) that has a 10 character text string, like the
following entry: 0190003164.

First, I need to grab the last four digits (3164) of the entry, copy them to
the next column (PropertyID), then insert a dash (-) between the 3rd to last
(from the R) and the 2nd to last characters.

The data in the column will always be the same format, if that helps.

How do I do this?