Regex - DNS formatting

[tmarlette]

I am attempting to format my DNS data to a standard format. I'm thinking I can use REGEX / SED for the this formatting.

This is my current field value:

(19)espnfivethirtyeight(5)files(9)wordpress(3)com(0)

This is the value that I would like to see:

espnfivethirtyeight.files.wordpress.com

I've used eval to replace the pattern eval myField=replace(src_domain,"\(\d+\)",".") and that replaces the values to the following, and the first and last '.' are adjusting my search results

.espnfivethirtyeight.files.wordpress.com.

Is there anything I can use in order to make the desired adjustment?

Thank you so much!!

[somesoni2 · Accepted solution]

Try like this

eval myField=replace(replace(src_domain,"\(\d+\)","."),"\.(.*)\.","\1")

Option 2

eval myField=substr(replace(src_domain,"(\w*)(\(\d+\))",".\1"),3)

[tmarlette]

the first one worked well. Thank you sir!