10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I'm on Linux version 2.6.32-696.3.1.el6.x86_64, using the Ksh shell.
I'm working with the input file:
John Daggett, 341 King Road, Plymouth MA
Alice Ford, 22 East Broadway, Richmond VA
Orville Thomas, 11345 Oak Bridge Road, Tulsa OK
Terry Kalkas, 402 Lans Road, Beaver Falls PA
Eric Adams,... (2 Replies)
Discussion started by: prooney
2 Replies
2. Shell Programming and Scripting
In file1 field $18 is removed.... column header is "Otherinfo", then each line in file1 is used to search file2 for a match. When a match is found the last four strings in file2 are copied to file1.
Maybe:
cut -f1-17 file1 and then match each line to file2
file1
Chr Start End ... (6 Replies)
Discussion started by: cmccabe
6 Replies
3. Shell Programming and Scripting
I have a CSV with carriage returns in place of newlines. I am trying to use tr to remove them, but it isn't working.
Academic year,Term,Course name,Period,Last name,Nickname
2012-2013,First Semester,English 12,4th Period,Arnold,Adam
2012-2013,First Semester,English 12,4th Period,Adams,Jim... (1 Reply)
Discussion started by: nextyoyoma
1 Replies
4. Shell Programming and Scripting
Hi,
I have a pipe delimited file. There are around 700 columns in the file.
The 65th column has carriage return which is causing read issue with our ETL process. I would like to replace the new line characters in 65th field with "nothing"
i have return the following code and need help to... (7 Replies)
Discussion started by: pinnacle
7 Replies
5. Shell Programming and Scripting
Hi,
I have a file which is having some carriage return in one of the field for which single line is coming in multiple lines.
I want to combine all those multiple lines of that field into one line.
Eg:
Input:
Id, Name, Location, Comments, Dept
2, John, US, I am from US.
I... (5 Replies)
Discussion started by: mahish20
5 Replies
6. Shell Programming and Scripting
Hi
I have a text file that looks like this:
A
B
C
D
E
F
G
H
I
I want it to be reformatted to
A;B;C;
D;E;F;
G;H;I; (4 Replies)
Discussion started by: coolnfunky
4 Replies
7. Shell Programming and Scripting
Hello, I have read a few threads on this subject and tried a few things out, but still come up short.
There was one good example, then the last reply was something to the effect of 'Use Sed' & 'Read a book'...
Well I read a bunch of online tutorials on sed, awk, tr, but still can't get the... (2 Replies)
Discussion started by: Majiktom
2 Replies
8. Shell Programming and Scripting
I need to replace thousands of carriage returns/line breaks in a large xml file and with spaces. I hope to do so with a script, called, for example, "removeCRs." I would invoke this at the command line as
ml5003$ sed -f /Users/ml5003/removeCRs oldFile > newFile
The script, I presume, would... (4 Replies)
Discussion started by: ml5003
4 Replies
9. Shell Programming and Scripting
How do we delete all carriage returns after a particular string using sed inside a K Shell?
e.g. I have a text file named file1 below:
$ more file1
Group#=1 User=A
Role=a1
Group#=2 User=B
Role=a1
Role=b1
Group#=3 User=C
Role=b1
I want the carriage returns to be delete on the... (12 Replies)
Discussion started by: stevefox
12 Replies
10. Shell Programming and Scripting
As the title suggests, i am having some trouble figuring out how to pass spaces and carriage returns to a 'here document' ie
#!/bin/bash
/usr/local/install_script.sh <<SCRIPT
yes
no
<pass carriage retun here>
yes
no
<pass a space and then a carriage return here>
exit
SCRIPT
any... (0 Replies)
Discussion started by: hcclnoodles
0 Replies
join(1) User Commands join(1)
NAME
join - relational database operator
SYNOPSIS
join [-a filenumber | -v filenumber] [-1 fieldnumber] [-2 fieldnumber] [-o list] [-e string] [-t char] file1 file2
join [-a filenumber] [-j fieldnumber] [-j1 fieldnumber] [-j2 fieldnumber] [-o list] [-e string] [-t char] file1 file2
DESCRIPTION
The join command forms, on the standard output, a join of the two relations specified by the lines of file1 and file2.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2. This format can be changed by using
the -o option (see below). The -a option can be used to add unmatched lines to the output. The -v option can be used to output only
unmatched lines.
The default input field separators are blank, tab, or new-line. In this case, multiple separators count as one field separator, and leading
separators are ignored. The default output field separator is a blank.
If the input files are not in the appropriate collating sequence, the results are unspecified.
OPTIONS
Some of the options below use the argument filenumber. This argument should be a 1 or a 2 referring to either file1 or file2, respectively.
-a filenumber In addition to the normal output, produce a line for each unpairable line in file filenumber, where filenumber is 1
or 2. If both -a 1 and -a 2 are specified, all unpairable lines will be output.
-e string Replace empty output fields in the list selected by option -o with the string string.
-j fieldnumber Equivalent to -1fieldnumber -2fieldnumber.
-j1 fieldnumber Equivalent to -1fieldnumber.
-j2 fieldnumber Equivalent to -2fieldnumber. Fields are numbered starting with 1.
-o list Each output line includes the fields specified in list. Fields selected by list that do not appear in the input
will be treated as empty output fields. (See the -e option.) Each element of which has the either the form filenum-
ber.fieldnumber, or 0, which represents the join field. The common field is not printed unless specifically
requested.
-t char Use character char as a separator. Every appearance of char in a line is significant. The character char is used as
the field separator for both input and output. With this option specified, the collating term should be the same as
sort without the -b option.
-v filenumber Instead of the default output, produce a line only for each unpairable line in filenumber, where filenumber is 1 or
2. If both -v 1 and -v 2 are specified, all unpairable lines will be output.
-1 fieldnumber Join on the fieldnumberth field of file 1. Fields are decimal integers starting with 1.
-2fieldnumber Join on the fieldnumberth field of file 2. Fields are decimal integers starting with 1.
OPERANDS
The following operands are supported:
file1
file2 A path name of a file to be joined. If either of the file1 or file2 operands is -, the standard input is used in its place.
file1 and file2 must be sorted in increasing collating sequence as determined by LC_COLLATE on the fields on which they are to be joined,
normally the first in each line (see sort(1)).
USAGE
See largefile(5) for the description of the behavior of join when encountering files greater than or equal to 2 Gbyte (2**31 bytes).
EXAMPLES
Example 1: Joining the password file and group file
The following command line will join the password file and the group file, matching on the numeric group ID, and outputting the login name,
the group name and the login directory. It is assumed that the files have been sorted in ASCII collating sequence on the group ID fields.
example% join -j1 4-j2 3 -o 1.1 2.1 1.6 -t:/etc/passwd /etc/group
Example 2: Using the -o option
The -o 0 field essentially selects the union of the join fields. For example, given file phone:
!Name Phone Number
Don +1 123-456-7890
Hal +1 234-567-8901
Yasushi +2 345-678-9012
and file fax:
!Name Fax Number
Don +1 123-456-7899
Keith +1 456-789-0122
Yasushi +2 345-678-9011
where the large expanses of white space are meant to each represent a single tab character), the command:
example% join -t"tab" -a 1 -a 2 -e '(unknown)' -o 0,1.2,2.2 phone fax
would produce
!Name Phone Number Fax Number
Don +1 123-456-7890 +1 123-456-7899
Hal +1 234-567-8901 (unknown
Keith (unknown) +1 456-789-012
Yasushi +2 345-678-9012 +2 345-678-9011
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of join: LANG, LC_ALL, LC_CTYPE, LC_MES-
SAGES, LC_COLLATE, and NLSPATH.
EXIT STATUS
The following exit values are returned:
0 All input files were output successfully.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO
awk(1), comm(1), sort(1), uniq(1), attributes(5), environ(5), largefile(5), standards(5)
NOTES
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of the join, sort, comm, uniq, and awk commands are wildly incongruous.
SunOS 5.10 8 Feb 2000 join(1)