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:

XXX-XXX-XX-XX-X

look like this:

XXXXXXXX

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

Thanks!!

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

Outcomes