when my input
why i run with
awk -F"|" '{OFS="|";$3=substr($3,1,2)"|"substr($3,3,2)"|"substr($3,5);$4=substr($4,1,2)"|"substr($4,3);$6=subs tr($6,1,2)"|"substr($6,3,2)"|"substr($6,5);$7=substr($7,1,2)"|"substr($7,3)}1' file input
Dear All,
I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...):
ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N
ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Hello,
What's the best way to split a large into multiple files based on the last digit in the first column.
input file:
f
2738483300000x0y03772748378831x1y13478378358383x2y23743878383802x3y33787828282820x4y43748838383881x5y5
Desired Output:
f0
3738483300000x0y03787828282820x4y4
f1... (9 Replies)
I am unable to spit the file based on the 2nd column passing as a parameter with awk command.
Source file:
“100”,”customer information”,”10000”
“200”,”customer information”,”50000”
“300”,”product information”,”40000”
script: the command is not allowing to pass the parameters with the awk... (7 Replies)
Hi,
I have a fixed width text file without any header row. One of the columns contains a date in YYYYMMDD format.
If the original file contains 3 dates, I want my shell script to split the file into 3 small files with data for each date.
I am a newbie and need help doing this. (14 Replies)
Hi All
I have one query,say i have a requirement like the below code should be
move to diffent files whose maximum lines can be of 10 lines.Say in the below example,it consist of 14 lines.
This should be moved logically using the data in the fisrt coloumn to file1 and file 2.The data of first... (2 Replies)
Hi,
I have a file sample_1.txt (300k rows) which has data like below:
* Also each record is around 64k bytes
11|1|abc|102553|125589|64k bytes of data
10|2|def|123452|123356|......
13|2|geh|144351|121123|...
25|4|fgh|165250|118890|..
14|1|abc|186149|116657|......... (6 Replies)
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Hi All,
I have a requirement to split file into 2 sets of file. Below is a sample data of the file
AU;PTN;24EX;25-AUG-14;AU;123;SE;123;Test NN;;;;ASD;
AU;PTN;24EX;25-AUG-14;AU;456;SE;456;Test NN;;;;ASD;
AU;PTN;24EX;25-AUG-14;AU;147;SE;147;Test NN;;;;ASD;... (6 Replies)
Hi all,
Newbie here, so please bear over with my stupid question :)
I have used far too long time today on figuring this out, so I hope that someone here can help me move on.
I have some annotation data for a transcriptome where I want to split a column containing NCBI accession IDs into a... (7 Replies)
Hi Team,
I have a requirement in such a way that need to split the file into two based on which column particular value appears.Please find my sample file below.
Lets consider the delimiter of this file as either comma or two colons.(:: and ,). So I need to split the file in such a way that all... (2 Replies)
Discussion started by: ginrkf
2 Replies
LEARN ABOUT HPUX
mailq
mailq(1) General Commands Manual mailq(1)NAME
mailq - prints the mail queue
SYNOPSIS DESCRIPTION
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, 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:
to indicate that the job is being processed
to indicate that the load is too high to process the job
to indicate that the job is too new in the queue to process.
The output lines that follow the second line show the message recipients, one per line.
is identical to
Options
The supported options are:
Show the mail submission queue specified in the
file instead of the MTA queue specified in the file.
Show the lost items in the mail queue instead of normal queue items.
Show the quarantined items in the mail queue instead
of the normal queue items.
Limit processed jobs to those containing
substr as a substring of the queue ID or not when is specified.
Limit processed jobs to quarantined jobs containing
substr as a substring of the quarantine reason or not when is specified.
Limit processed jobs to those containing
substr as a substring of one of the recipients or not when is specified.
Limit processed jobs to those containing
substr as a substring of the sender or not when is specified.
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. In addition, extra lines may be intermixed with the recipients indicating the
`controlling user' information. This shows who owns the programs that are executed on behalf of this message and the name
of the alias this command expanded from, if any.
RETURN VALUE
The utility exits with 0 on success, and >0 if an error occurs.
AUTHOR
was developed by the University of California, Berkeley, and originally appeared in 4.0BSD.
FILES
mail queue files for
SEE ALSO sendmail(1M).
mailq(1)