combining awk and sed Post: 302498394

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

combining sed commands

I would like to change the lines: originalline1 originalline2 to: originalline1new originalline1newline originalline2new originalline2newline To do this, id like to combine the commands: sed 's/^/&new/g' file > newfile1 and sed '/^/ a\\ newline\\ \\

2. Shell Programming and Scripting

combining fields in awk

I am using: ps -A -o command,%cpu to get process and cpu usage figures. I want to use awk to split up the columns it returns. If I use: awk '{print "Process: "$1"\nCPU Usage: "$NF"\n"}' the $NF will get me the value in the last column, but if there is more than one word in the...

3. Shell Programming and Scripting

Sed: Combining Multiple Lines into one

Before I ask my actual question, is it going to be a problem that I want to run this process on a 15 Gig file that is ~140 million rows? What I'm trying to do: I have a file that looks like Color,Type,Count,Day Yellow,Full 5 Tuesday Green,Half 6 Wednesday Purple,Half 8 Tuesday ......

4. UNIX for Dummies Questions & Answers

Combining awk tests

It would be convenient to be able to combine awk tests. For example, suppose that I do this query: awk '$1 != "Bob" || $1 != "Linda" {print $2}' datafileIs there a reasonable way to combine the conditions into a single statement? For example, in egrep, I can do: egrep -v "Bob|Linda"...

5. Shell Programming and Scripting

Combining multiple rows in single row based on certain condition using awk or sed

Hi, I'm using AIX(ksh shell). > cat temp.txt "a","b",0 "c",bc",0 "a1","b1",0 "cc","cb",1 "cc","b2",1 "bb","bc",2 I want the output as: "a","b","c","bc","a1","b1" "cc","cb","cc","b2" "bb","bc" I want to combine multiple lines into single line where third column is same. Is...

6. Shell Programming and Scripting

combining multiple sed statements

I need to run a cronjob that will monitor a directory for files with a certain extension, when one appears I then need to run the below scripts How do I go about combining the following sed statements into one script? and also retain the original filename.? sed 's/71502FSC1206/\n&/g' # add a...

7. Shell Programming and Scripting

How to combining awk commands?

I can achieve two tasks with 2 different awk commands: 1) awk -F";;WORD" '{print $2}' file | sed '/^$/d' #to find surface_word 2) awk -F"bw:|gloss:" '// {print $2}' file | sed '/\//!d; s:/*+*: + :g; s:^+::; s: *+ *$::;' #to find segmentation of surface_word Number 1) finds surface_word...

8. Shell Programming and Scripting

awk problem - combining awk statements

i have a datafile that has several lines that look like this: 2,dataflow,Sun Mar 17 16:50:01 2013,1363539001,2990,excelsheet,660,mortar,660,4 using the following command: awk -F, '{$3=strftime("%a %b %d %T %Y,%s",$3)}1' OFS=, $DATAFILE | egrep -v "\-OLDISSUES," | ${AWK} "/${MONTH} ${DAY}...

9. Shell Programming and Scripting

Combining sed actions

Let's say I have an input file looking like: ID1 1 5 6 8 ID2 1 4 5 7 I'm trying to formulate a loop that can combine these actions: - If the line begins with a letter: replace the '\ n' after a field containing characters with a '\ t' (sed 's / \ n / \ t / g' ) - If the line...

10. UNIX for Beginners Questions & Answers

Help using combining variables with sed command (RHEL 7)

Here is the whole script, very simple, but I am just learning ROK_NO=$1 RPT=/tmp/test sed -E '/^SELECT/ s/(.{23}).{8}/\1'"$ROK_NO"' /' $RPT echo $RPT When I run this I get $ bash rok.sh 2388085 : No such file or directory /tmp/test When I type the command in console, it works...

LEARN ABOUT FREEBSD

mailq

MAILQ(1)						      General Commands Manual							  MAILQ(1)

NAME

       mailq - print the mail queue

SYNOPSIS

       mailq [-Ac] [-q...]  [-v]

DESCRIPTION

       Mailq prints a summary of the mail messages queued for future delivery.

       The  first  line printed for each message shows the internal identifier used on this host for the message with a possible status character,
       the size of the message in bytes, the date and time the message was accepted into the queue, and the envelope sender of the  message.   The
       second  line  shows  the error message that caused this message to be retained in the queue; it will not be present if the message is being
       processed for the first time.  The status characters are either * to indicate the job is being processed; X to indicate that  the  load	is
       too  high to process the job; and - to indicate that the job is too young to process.  The following lines show message recipients, one per
       line.

       Mailq is identical to ``sendmail -bp''.

       The relevant options are as follows:

       -Ac    Show the mail submission queue specified in /etc/mail/submit.cf instead of the MTA queue specified in /etc/mail/sendmail.cf.

       -qL    Show the "lost" items in the mail queue instead of the normal queue items.

       -qQ    Show the quarantined items in the mail queue instead of the normal queue items.

       -q[!]I substr
	      Limit processed jobs to those containing substr as a substring of the queue id or not when !  is specified.

       -q[!]Q substr
	      Limit processed jobs to quarantined jobs containing substr as a substring of the quarantine reason or not when !	is specified.

       -q[!]R substr
	      Limit processed jobs to those containing substr as a substring of one of the recipients or not when !  is specified.

       -q[!]S substr
	      Limit processed jobs to those containing substr as a substring of the sender or not when !  is specified.

       -v     Print verbose information.  This adds the priority of the message and a single  character  indicator  (``+''  or	blank)	indicating
	      whether  a  warning  message  has  been sent on the first line of the message.  Additionally, extra lines may be intermixed with the
	      recipients indicating the ``controlling user'' information; this shows who will own any programs that are executed on behalf of this
	      message  and  the name of the alias this command expanded from, if any.  Moreover, status messages for each recipient are printed if
	      available.

       Several sendmail.cf options influence the behavior of the mailq utility: The number of items printed  per  queue  group	is  restricted	by
       MaxQueueRunSize	if  that  value  is set.  The status character * is not printed for some values of QueueSortOrder, e.g., filename, random,
       modification, and none, unless a -q option is used to limit the processed jobs.

       The mailq utility exits 0 on success, and >0 if an error occurs.

SEE ALSO

       sendmail(8)

HISTORY

       The mailq command appeared in 4.0BSD.

							   $Date: 2013-11-22 20:51:55 $ 						  MAILQ(1)

f && /^L/{s=$0;next}	If the flag f is set (==1) and the line starts with "L" assign the line to the variable s and get the next record
/^L/{print substr($0,178,15);f=1}	If the line starts with "L" and the flag is not set print the substring, this is the first occurrence
END{print substr(s,178,15)}	print the substring of the last occurrence

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

combining sed commands

Discussion started by: Dave724001

2. Shell Programming and Scripting

combining fields in awk

Discussion started by: json4639

3. Shell Programming and Scripting

Sed: Combining Multiple Lines into one

Discussion started by: goldfish

4. UNIX for Dummies Questions & Answers

Combining awk tests

Discussion started by: treesloth