Issue
I am hoping someone can help me (complete newbie to regex)
I am trying to extract only the email addresses with numeric entries before the @
for example
[email protected] would not be selected
[email protected] would be selected
The other problem i have is that each email address also has a phone number afterwards in a ten digit format.
Example
[email protected] 5555511111
[email protected] 5555511112
Everything i have tried seems to either select the phone number too or nothing at all.
Thanks in advance and apologies if there is not enough information. I will try and answer any questions people have.
Things i have tried so far
grep -E [0-9][@] data.csv
grep -E [0-9] data.csv
grep -E \d+(?=@) data.csv (this does not complete due to a syntax error)
As i say, i'm a complete novice at this and still trying to get my head round the regex stuff
Solution
You can use
grep -Eo '^[^@[:space:]0-9]*[0-9][^@[:space:]]*@[^[:space:]]+' file
Details
^- start of string[^@[:space:]0-9]*- zero or more chars other than a@, whitespace and a digit[0-9]- a digit[^@[:space:]]*- zero or more chars other than a@, whitespace and a digit@- a@char[^[:space:]]+- one or more chars other than whitespace.
See an online demo:
s='[email protected] 5555511111
[email protected] 5555511112
[email protected] 6453453344'
grep -Eo '^[^@[:space:]0-9]*[0-9][^@[:space:]]*@[^[:space:]]+' <<< "$s"
# => [email protected]
# [email protected]
Answered By - Wiktor Stribiżew Answer Checked By - Gilberto Lyons (WPSolving Admin)