AnsweredAssumed Answered

Removing hyphens and extra digits in tabular data

Question asked by burrito_mike on Jan 8, 2014
Latest reply on Jan 8, 2014 by burrito_mike
Hi everyone,
So I have a list of numbers that have extra digits and hyphens but I am not too good with the field calculator. I would like to make this:


look like this:


I just want to remove the hyphens and delete the last three numbers. Any suggestions?


Edit: I figured out how to remove the hyphens but I still need to remove the last three digits...