awk,cut fields by change field format Post: 302368596

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,...

2. UNIX for Advanced & Expert Users

Printing Field with Delimiter in AWK/cut

Hello, I had posted earlier about printing fields using AWK, but now I have a slightly different problem. I have text files in the format: 1*2,3,4,5 and wish to print the first, third, and fifth fields, including the asterisk and commas. In other words, after filtering it should look...

3. UNIX for Advanced & Expert Users

change field 2 date format

from this input WEBELSOLAR,29122009,1:1 WIPRO,15062010,2:3 ZANDUREALT,18012007,1:3 i want output as WEBELSOLAR,20091229,1:1 WIPRO,20100615,2:3 ZANDUREALT,20070118,1:3 basically input is in ddmmyyyy format and i was to convert it to yyyymmdd format

4. Shell Programming and Scripting

AWK : Add Fields of lines with matching field

Dear All, I would like to add values of a field, if the lines match in a certain field. Then I would like to divide the sum though the number of lines that have a matched field. This is the Input: Input: Test1 5 Test1 10 Test2 2 Test2 5 Test2 13 Test3 4 Output: Test1 7.5 Test1 7.5...

5. Shell Programming and Scripting

how to parse with awk (using different fields), then group by a field?

When parsing multiple fields in a file using AWK, how do you group by one of the fields and parse by delimiters? to clarify If a file had tom | 223-2222-4444 , randofield ivan | 123-2422-4444 , random filed ... | and , are the delimiters ... How would you group by the social security...

6. Shell Programming and Scripting

awk - print all fields except for last field

How do I print all the fields of a record except for the $(NF) field?

7. Shell Programming and Scripting

How to Print from nth field to mth fields using awk

Hi, Is there any short method to print from a particular field till another filed using awk? Example File: File1 ==== 1|2|acv|vbc|......|100|342 2|3|afg|nhj|.......|100|346 Expected output: File2 ==== acv|vbc|.....|100 afg|nhj|.....|100

8. Shell Programming and Scripting

how to cut the last field without using awk

i have file as with the below content aaa.bbb.cc.dd aaa.fff.bb yyyyy.rrrrr.ggggg.iii wwww.w.r.ty i want the o/p as below dd bb iii ty but i dont want to use awk. is there any other way to do this ?

9. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk...

10. Shell Programming and Scripting

Insert field between two fields using awk or sed

Hi All, I am trying to insert two columns in the following text. I tried awk but failed to achieve. Highly appreciate your help DATETIME="28-Sep-2013;20:09:08;" CONTROL="AB" echo "Myfile.txt;11671;7824.90;2822.48" The DATETIME will be inserted at the beginning and CONTROL will...

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)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

Discussion started by: axo959

2. UNIX for Advanced & Expert Users

Printing Field with Delimiter in AWK/cut

Discussion started by: Jahn

3. UNIX for Advanced & Expert Users

change field 2 date format

Discussion started by: manishma71

4. Shell Programming and Scripting

AWK : Add Fields of lines with matching field

Discussion started by: DerSeb