regex help

[mcbradford]

Not the best regex king, so I need some help please

within the field "From" in my data there are emails. Within the emails there should never be a number before the @.

For example, [email protected] is not valid, but [email protected] is valid.

I want to find all the non valid emails.

[skoelpin]

Try this..

If you want to get good with regex then go to www.regex101.com and put some sample data in and test it

This will find all emails with a number before the @ symbol

\w+\d@\w+\.com

index=foo ... | rex (?P<Bad_Email>\w+\d@\w+\.com)

[sundareshr]

Try this

.... | rex "(.*\d.*?@[^\s]+)" | ...

[somesoni2]

Try like this

your base search | regex From="\S+\d\@\S+"