How do you write a regex string that drops .0 only when it is at the end of a string?

user_8427615 0
Viewed 55

Basically what I'm looking for is a regex string that gets everything before either .0 or .0.0 when either of those are the end of the string. If the string has .0 in the middle but ends with something else, it should stay as it is.

Android 7.0.0 should just be Android 7. Android 6.0 should just be Android 6 Android 6.0.1 should stay as it is

I am using the regex dialect featured in google bigquery. The closest I have come is the regex pattern .*[^(.0|.0.0)] . I imagine the $ symbol should be in the pattern but I haven't been able to figure out how to use it.

Thanks!

google-bigquery android regex
1 Answers

You can use

(?:\.0)+$

See the regex demo and the regex graph:

enter image description here

Details:

  • (?:\.0)+ - zero or more occurrences of a dot and a zero
  • $ - end of string.
user_38329700
Related