UNIX for Dummies Questions & Answers

Hello,

I have a list in .txt format of email addresses and I need to extract just a specific domain ...

The list format is like:
"123456";"user@domain.com";"email";"john";"name"
"123457";"user2@domain.com";"email";"john";"name"
"123458";"user3@domain.com";"email";"john";"name"
"123459";"user4@domain.com";"email";"john";"name"

After running grep I want the newly created list to look like:
user@domain.com
user2@domain.com
user3@domain.com
user4@domain.com

I tried grep -r @domain.com filename1.txt > filename2.txt

It works but gives me all the things before and after the email address, I just want the email by itself...


Thanks in advance for your help!!!!!!!!!

You could use awk instead:

Code:

awk -F"\";\"" '{print $2}' file

Code:

awk -F'";"' '{ print $2 }' input_file.txt

Hello,

I tried both your commands but they didn't work ...

I tried it on gawk in windows:

C:\TEMP\LIST>awk -F'";"' '{ print $2 }' bad1txt > bad2.txt
awk: '{
awk: ^ invalid char ''' in expression

C:\TEMP\LIST>awk -F"\";\"" '{print $2}' bad1.txt > bad2.txt
awk: '{print
awk: ^ invalid char ''' in expression


Any idea?

Strange. Maybe a Windows peculiarity. Try:

Code:

sed -r 's/^.+;"([^@]+@[^"]+)".+/\1/' file

Are you using Windows Services for UNIX?

I've used them in the past and I remember I had your same issue... Don't remember if it was something related to single/double quotes escaping or curly braces... Try escaping them with a backslash or playing around with quoting... Or try another approach:

Code:

cut -f2 -d ';' input_file.txt | cut -f2 -d '"'

...or try a real linux emulation like cygwin, which is better.

EDIT: paying more attention to the error returned, now I seem to remember that awk on windows does not like single quotes around the awk script: you must always use double quotes, and escape all the double quotes that now are surrounded by single quotes, like ripat did in the post before. Try something like this:

Code:

awk -F"\";\"" "{ print $2 }" input_file.txt

Code:

cut -d "\"" -f4 < file > outfile

Regards