Regular expression in grep -E | awk print

terry2009 · #1 (**permalink**) 10-01-2009

Hi All,

I have file.txt with contents like this:

random text
To: recipient@email.co.uk
<HTML>S7randomtext more random text
random text
To: recip@smtpemail.com
<HTML>E5randomtext more random text
random text
I need the output to look like this:

1,,,1,S7
1,,,1,E5

My code so far is:

Code:

 
grep -E "[A-Z][0-9]" file.txt | awk '{print ",1,,,1,"[A-Z][0-9]}' > out.txt

vgersh99 · #2 (**permalink**) 10-01-2009

Code:

echo '<HTML>S7randomtext' | sed 's#.*>\([A-Z][0-9]\).*#1,,,1,\1#'

terry2009 · #3 (**permalink**) 10-01-2009

Thanks, but would this work (this is a snippet of a much much larger script):

Code:

grep -E "[A-Z][0-9]" file.txt | sed 's#.*>\([A-Z][0-9]\).*#1,,,1,\1#' > out.txt

EAGL€ · #4 (**permalink**) 10-01-2009

Quote:

Originally Posted by terry2009

Thanks, but would this work (this is a snippet of a much much larger script):

Code:

grep -E "[A-Z][0-9]" file.txt | sed 's#.*>\([A-Z][0-9]\).*#1,,,1,\1#' > out.txt

Hello friends, could you please tell me what does " > " stands for in SED part of the script? I understand all the regex except it,

regards

scottn · #5 (**permalink**) 10-01-2009

Quote:

Originally Posted by EAGL€

Hello friends, could you please tell me what does " > " stands for in SED part of the script? I understand all the regex except it,

regards

It's a literal > (meaning match a greater-than sign, or in this context an angled bracket)

vgersh99 · #6 (**permalink**) 10-01-2009

Quote:

Originally Posted by EAGL€

Hello friends, could you please tell me what does " > " stands for in SED part of the script? I understand all the regex except it,

regards

It's not part of an RE. Look at the original pattern:

Code:

echo '<HTML>S7randomtext' | sed 's#.*>\([A-Z][0-9]\).*#1,,,1,\1#'

terry2009 · #7 (**permalink**) 10-02-2009

Hi Again!

Here is an extended part of the script... I'd like to be sure that sed will work instead of grep....

Code:

grep -l "search string in files I want" smtp*.tmp > email_filenames_list.txt ;
cat email_filenames_list.txt | xargs cat >> smtp_all_emails_logs.txt ;
sed '/[A-Z][0-9]/ s#.*>\([A-Z][0-9]\).*#,1,,,1,\1#' smtp_all_emails_logs.log > out.txt ;
grep "^To" smtp_all_emails_logs.txt | awk '{print ","$2}' > recipients.txt ;
paste out.txt recipients.txt

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
grep regular expression	Calypso	Shell Programming and Scripting	7	05-18-2009 08:08 AM
grep with regular expression	daikeyang	Shell Programming and Scripting	6	03-22-2009 08:46 PM
How can we grep only those content according to regular expression	Johnivy	UNIX for Dummies Questions & Answers	3	12-16-2008 08:43 AM
regarding grep regular expression	ukatru	UNIX for Advanced & Expert Users	2	10-23-2008 12:47 AM
grep : regular expression	RishiPahuja	Shell Programming and Scripting	10	09-13-2005 01:53 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: