Hi All,
I need to select only those records having a non zero record in the first column of a comma delimited file.
Suppose my input file is having data like:
"0","01/08/2005 07:11:15",1,1,"Created",,"01/08/2005"
"0","01/08/2005 07:12:40",1,1,"Created",,"01/08/2005"... (2 Replies)
New to awk and need some help. I have a script that I would like to make more compact. I want to read a file and grab every field, from every record, except the last field. The records are variable length and have varying number of fields. A record will have at least two fields, but can have... (9 Replies)
Dear list
its my first post and i would like to greet everyone
What i would like to do is select records 7 and 11 from each files in a folder then run an executable inside the script for the selected parameters.
The file format is something like this
7 100 200
7 100 250
7 100 300 ... (1 Reply)
Hi,
I have file on below pattern, and i want to write a generic awk to handle all cases.
input_file:
col1~col2~col3~col4~col5~col6
I need to generate 4 files something like this
File1:
col1~~col2~~col3
File2:
col1~~col2~~col4
File3:
col1~~col2~~col5
File4:
col1~~col2~~col6 (1 Reply)
Hello:
I am new to shell script programming. Now I would like to select specific records block from a file. For example, current file "xyz.txt" is containing 1million records and want to select the block of records from line number 50000 to 100000 and save into a file. Can anyone suggest me how... (3 Replies)
Print only records from file 2 that do not match file 1 based on criteria of comparing column 1 and column 6
Was trying to play around with following code I found on other threads but not too successful
Code:
awk 'NR==FNR{p=$1;$1=x;A=$0;next}{$2=$2(A?A:",,,")}1' FS=~ OFS=~ file1 FS="*"... (11 Replies)
Hi All,
I am looking for a simple concise solution most likely using sed to process the following 4 rows of data from the same record and only keeps it if the second record satisfy certain critea such as surname matches up to smith or jackson:
John (firstname)
Smith (surname) ... (21 Replies)
Friends,
I have data sorted on id like this
id addressl
1 abc
2 abc
2 abc
2 abc
3 aabc
4 abc
4 abc
I want to pick all ids with addressesses leaving out duplicate records. Desired output would be
id address
1 abc
2 abc
3 abc
4 abc (5 Replies)
Hi All
I would like to modify a file like this:
>antax gioq21 tris notes
abcdefghij
klmnopqrs
>betax gion32 ter notes2
tuvzabcdef
ahgskslsooin this:
>tris
abcdefghij
klmnopqrs
>ter
tuvzabcdef
ahgskslsoo
So, I would like to remove the first two fields(and output field 3) in record... (4 Replies)
I have a file, named records.txt, containing large number of records, around 0.5 million records in format below:
28433005 1 1 3 2 2 2 2 2 2 2 2 2 2 2
28433004 0 2 3 2 2 2 2 2 2 1 2 2 2 2
...
Another file is a key file, named key.txt, which is the list of some numbers in the first column of... (5 Replies)
Discussion started by: zenongz
5 Replies
LEARN ABOUT OPENSOLARIS
mailq
mailq(1) User Commands mailq(1)NAME
mailq - print the mail queue
SYNOPSIS
/usr/bin/mailq [-Ac] [-q subarg] [-v]
DESCRIPTION
The mailq utility displays a summary of the mail messages queued for future delivery.
The first line displayed for each mail message shows the internal identifier used on this host for the message, 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 of the display
shows the error message that caused this message to be retained in the queue. This line will not be displayed if the message is being pro-
cessed for the first time.
The mailq utility used to be identical to sendmail -bp. Now it checks for the authorization attribute, solaris.mail.mailq. If the check for
the invoking user succeeds, sendmail -bp is executed with the remaining argument vector. Otherwise, an error message is printed. This
authorization attribute is by default enabled for all users. It can be disabled by modifying the Basic Solaris User entry in prof_attr(4).
OPTIONS
The following options are supported:
-Ac Like sendmail(1M), this flag tells mailq to use submit.cf rather than sendmail.cf even if the operation mode does
not indicate an initial mail submission. This will result in the client queue /var/spool/clientmqueue being displayed
rather than the default server queue /var/spool/mqueue.
-qp[time] Similar to -qtime, except that instead of periodically forking a child to process the queue, sendmail forks a single per-
sistent child for each queue that alternates between processing the queue and sleeping. The sleep time is given as the
argument. The sleep time default is 1 second. The process will always sleep at least 5 seconds if the queue was empty in
the previous queue run.
-qf Processes saved messages in the queue once and does not fork(), but runs in the foreground.
-qG name Processes jobs in the queue group called name only.
-q[!]I substr Limits processed jobs to those containing substr as a substring of the queue id, or not when ! is specified.
-q[!]R substr Limits processed jobs to those containing substr as a substring of one of the recipients, or not when ! is specified.
-q[!]S substr Limits processed jobs to those containing substr as a substring of the sender, or not when ! is specified.
-v Prints 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 that indicate 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 is expanded from, if any.
EXIT STATUS
0 Successful completion.
>0 An error occurred.
FILES
/etc/security/prof_attr local source for execution profile attributes
/var/spool/mqueue default server queue
/var/spool/clientmqueue client queue
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsndmu |
+-----------------------------+-----------------------------+
SEE ALSO sendmail(1M), prof_attr(4), attributes(5)SunOS 5.11 10 Jul 2002 mailq(1)