I am needing to strip a portion out of email's. I have a list of email addresses where some of them contain -priv before the @ that I need stripped out leaving what would be the "normal" email address.
example address
example-priv@email.com
I want to be left with example@email.com
can someone help me with the rex for this?
thank you
Try | rex field=email mode=sed "s/-priv//"
Try | rex field=email mode=sed "s/-priv//"
Thank you, this worked
Like this:
| makeresults
| eval email="example-priv@email.com"
| rex field=email mode=sed "s/-[^@]+@/@/g"
Thank you, I should add that I have since noticed that there are email addresses that have an appropriate need to have - in them.
example
surname.givenname-middlename-priv@email.com
so I really need to only strip emails that have -priv in them, not any email that contains a - from the - to @