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
TMS_KEP.Male_RTU2.Male_PRM1_GL_OUT TMS_KEP.Male_RTU2.Male_PRM1_PS_IN TMS_KEP.Female_RTU2.Female_WC8_RL_OUT TMS_KEP.Male_RTU1.Male_WC3_FS_OUT TMS_KEP.Male_RTU1.Male_WC5_FS_OUT
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.
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