I have a field called [Feature] and I want to extract everything to the right of the period.
1A. Bunker Undesignated (Includes concrete)
1B. Bridge identified
1C. Interchange
I'm able to extract the left side easily using:
Left([Feature],InStrRev([Feature],".")-1)
I'm sure there's a simple configuration of a command but I'm stumped right now.
1A. Bunker Undesignated (Includes concrete)
1B. Bridge identified
1C. Interchange
I'm able to extract the left side easily using:
Left([Feature],InStrRev([Feature],".")-1)
I'm sure there's a simple configuration of a command but I'm stumped right now.