Standardizing phone number data

user_4828653 0
Viewed 58

I'm looking for a more elegant solution for this:

phone_number <- function(x) {
x <- gsub("[\\() -]", "", x) 
x <- gsub("^(.{3})(.{3})(.*)","\\1-\\2-\\3", x, perl = TRUE)
}

This would take data like this:

(123) 123-1234
123-123-1234
123 123-1234

And produce this:

123-123-1234
123-123-1234
123-123-1234
r regex
1 Answers

We could do

gsub(".*(\\d{3}).*(\\d{3}).*(\\d+).*?", "\\1-\\2-\\3", x)
# [1] "123-123-1234" "123-123-1234" "123-123-1234"

assuming that we have only three groups of digits somewhere in a character and they are what we need.

user_13205350
Related