10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
In the awk below which does execute I get output that is close, except for all the lines that start with a # are removed. Some lines have one others two or three and after the script adds the
ID= to the fields below the pattern in the awk, I can not seem to add the # lines back to the output. ... (5 Replies)
Discussion started by: cmccabe
5 Replies
2. Shell Programming and Scripting
Hi all.
This is the content of the text file used for the e-mail:
TM ICP-EDW BILLING REGISTER USAGE BREAKDOWN_01062014.csv
TM_ICP_EDWH_FICL_13062014.TXT
TM_ICP_EDWH_FICL_16062014.TXT
TM_ICP_EDW_Detailed Payment Journal Report_13062014.txt
TM_ICP_EDW_Detailed Payment Journal... (9 Replies)
Discussion started by: aimy
9 Replies
3. Shell Programming and Scripting
Running solaris 9, on issuing the follwing command
df -h | awk '$5 > 45 {print}'
Filesystems with utilisation > 45% are being displayed as well as those between
5 and-9%!!! (3 Replies)
Discussion started by: squrcles
3 Replies
4. UNIX for Dummies Questions & Answers
Hi All
I have a .dat file, the values are seperated by ". I wish to identify all field values in field 14 that are not '01-APR-2013' band then copy those records to a new file. Can anyone suggest the UNIX command required.
Thanks in advance
Andy (2 Replies)
Discussion started by: aurum1313
2 Replies
5. Shell Programming and Scripting
Hi,
I have a file (sorted by sort) with 8 tab delimited columns. The first column contains duplicated fields and I need to merge all these identical lines.
My input file:
comp100002 aaa bbb ccc ddd eee fff ggg
comp100003 aba aba aba aba aba aba aba
comp100003 fff fff fff fff fff fff fff... (5 Replies)
Discussion started by: falcox
5 Replies
6. Shell Programming and Scripting
I've been a Unix admin for nearly 30 years and never learned AWK. I've seen several similar posts here, but haven't been able to adapt the answers to my situation. AWK is so damn cryptic! ;)
I have a single file with ~900 lines (CSV list). Each line starts with an ID, but with different stuff... (6 Replies)
Discussion started by: protosd
6 Replies
7. Shell Programming and Scripting
Hello,
I couldn't find anything on the Forum that would help me to solve this problem. Could any body help me process below data using awk?
I have got two files:
file1:
Worker1: Thomas
Position: Manager
Department: Sales
Salary: $5,000
Worker2: Jason
Position: ... (5 Replies)
Discussion started by: killerbee
5 Replies
8. Shell Programming and Scripting
The input file:
>cat module1
200611051053 95
200523457498 35
200617890187 57
200726098123 66
200645676712 71
200744556590 68
>cat module2
200645676712 ... (10 Replies)
Discussion started by: winter9
10 Replies
9. Shell Programming and Scripting
Hello friends,
I searched in forums for similar threads but what I want is to have a single awk code to perform followings;
I have a big log file going like this;
...
7450494 1724465 -47 003A98B710C0
7450492 1724461 -69 003A98B710C0
7450488 1724459 001DA1915B70 trafo_14:3
7450482... (5 Replies)
Discussion started by: enes71
5 Replies
10. Shell Programming and Scripting
I've got a file with each record on a separate line and each record contains 34 fields separated by a colon and i'm trying to re-arrange the order of the fields and merge together certain fields separated by a slash (like field7/field28). I tried using an awk print statement like
awk -F: 'BEGIN... (5 Replies)
Discussion started by: RacerX
5 Replies
paste(1) General Commands Manual paste(1)
NAME
paste - Joins corresponding lines of several files or subsequent lines in one file
SYNOPSIS
paste [-d list] [-s] file...
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
paste: XCU5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
OPTIONS
Replaces the delimiter that separates lines in the output (tab by default) with one or more characters from list. If list contains more
than one character, then the characters are repeated in order until the end of the output. In parallel merging, the lines from the last
file always end with a newline character, instead of one from list.
The following special characters can be used in list: Newline character Tab Backslash Empty string (not a null character) [Tru64
UNIX] An extended character
You must quote characters that have special meaning to the shell. Merges all lines from each input file into one line of output
(serial merging). Using this option, the paste command merges all lines in the first input file forcing a newline before at the
end. The command then continues with the next input file, continuing in the same manner until all input files have been completed.
A tab separates the input lines unless you use the -d option. Regardless of the list, the last character of the output is a newline
character.
OPERANDS
The name of an input file. You may specify up to 12 files, including hyphens.
If you specify a -, paste reads standard input recursively, one line for each -.
DESCRIPTION
Specifying the -d option or no options causes the paste command to treat each file as a column, joining them horizontally with a tab char-
acter by default (parallel merging).
Using the -s option, the paste command combines all lines of each input file into one output line (serial merging). These lines are joined
with the tab character by default.
Output lines can be any length.
[Tru64 UNIX] The output of pr -t -m is similar to the output produced by the paste command, but pr with its options creates extra spaces,
tabs, and lines for an enhanced page layout.
RESTRICTIONS
If the -s option is not used, it is an error if any specified file cannot be opened.
EXIT STATUS
The following exit values are returned: Successful completion. An error occurred.
EXAMPLES
To paste several columns of data together, enter: paste names places dates > npd
This creates a file named npd that contains the data from names in one column, places in another, and dates in a third. The columns
are separated by tab characters.
File npd then contains:
rachel New York 28 February jerzy Warsaw 27 April mata Nairobi 21 June michel
Boca Raton 27 July segui Managua 18 November
A tab character separates the name, place, and date on each line. To separate the columns with a character other than a tab (sh
only), enter: paste -d"!@" names places dates > npd
This alternates the apostrophe (!) and the at sign (@) as the column separators. If names, places, and dates are the same as in
Example 1, then npd contains:
rachel!New York@28 February jerzy!Warsaw@27 April mata!Nairobi@21 June michel!Boca Raton@27 July segui!Managua@18 November To dis-
play the standard input in multiple columns, enter: ls | paste - - - -
This lists the current directory in four columns. Each hyphen (-) tells the paste command to create a column containing data read
from the standard input. The first line is put in the first column, the second line in the second column, ... and then the fifth
line in the first column, and so on.
This is equivalent to ls | paste -d"
" -s -
which fills the columns across the page with subsequent lines from the standard input. The -d
defines the character to
insert after each column: a tab character ( ) after the first three columns, and a newline character (
) after the fourth. Without
the -d option, paste -s - displays all of the input as one line with a tab between each column. To merge the lines of the file
names above into one output line, enter: paste -s names
This results in: rachel jerzy mata michel segui
ENVIRONMENT VARIABLES
The following environment variables affect the execution of paste: Provides a default value for the internationalization variables that are
unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari-
ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value,
overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes
of text data as characters (for example, single-byte as opposed to multibyte characters in arguments and input files). Determines the
locale for the format and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the
processing of LC_MESSAGES.
SEE ALSO
Commands: cut(1), grep(1), fold(1), join(1), pr(1)
Standards: standards(5)
paste(1)