Similar to this question, I want to remove only middle zero’s while preserving trailing zeroes:
testdata <- c("101", "102", "103", "104", "105", "106", "107", "108", "109", "110")
The desired result is 11, 12, 13, 14, 15, 16, 17, 18, 19, 110. My real dataset contains values from 100 to 899 and is in character format.
When I adjust the answer to the linked question, it removes trailing zeroes.
sub("([1-8])0(.*)", "\1\2", c(testdata))
returns:
“11” “12” “13” “14” “15” “16” “17” “18” “19” “11”
How can I remove only middle zeroes and leave trailing zeroes?
1