I'm fairly new to Regex and having a difficult time coming up with a pattern for my query. I need to match everything after the second period in all of these values but can't figure out how
There are some slight variations in this but essentially I need a pattern that takes everything after the second period.
Any help is greatly appreciated.
... | rex \w+\.\w+\.(?<FIELD>\w+)
This will capture everything after the 2nd period and create a new field called FIELD
View solution in original post
if your need is to take all the chars after the first dot of each row, this is your regex:
your can test it at https://regex101.com/r/PTqtiI/1
if instead you need is to take all the chars after the second dot of each row, this is your regex:
your can test it at https://regex101.com/r/8gxaHO/1
This worked perfectly, Thank you.