03-03-2017
awk doesn't ALWAYS allow for breaking lines. Put the opening { on the same line OR use a "line continuation" character: \ .
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have two files file1 and file2 as shown below:
file1:
name
nameabc
bcd
nameabcdefg
file2:
age
age1111
age2345
age6743
I have pasted one file on the other with the delimiter "|" and the resulttant file is:
name|age
nameabc|age1111
bcd|age2345
nameabcdefg|age6743 (1 Reply)
Discussion started by: udiptya
1 Replies
2. Shell Programming and Scripting
Hi,
I have a file with only data 1 row:
AA#?BB#?CC#?DD
Assume '#?' is the delimiter, i want the output in another file to be:
AA
BB
CC
DD
Pls let me know if this is possible by sed ?
Thanks in advance. (3 Replies)
Discussion started by: smc3
3 Replies
3. Shell Programming and Scripting
Hi,
I am new to unix , I have a requirement for formating the input file and generate the output file as per the downstream requirement ..
My application receiving a text input file having 4 field and my application need to check each field and if some value of a field is blank ..then it need... (1 Reply)
Discussion started by: julirani
1 Replies
4. UNIX for Dummies Questions & Answers
I have a file called vm.cfg .
content of file.
acpi = 1
apic = 1
builder = 'hvm'
How would i write a script which will add
boot = 'd' at 3rd line.
For example.
after running the script the file should be like below.
acpi = 1
apic = 1
boot = 'd'
builder = 'hvm'
I dont want to... (3 Replies)
Discussion started by: pinga123
3 Replies
5. Shell Programming and Scripting
I am new ot unix. Is there one or two lines of command (sed may be) to format a file.
My source is..
<tag1>
<tag2>
<datatag1>
data1
</datatag1>
<datatag2>
data2
</datatag2>
<datatag3>
data3
</datatag3>
<datatag4>
data1
</datatag3>
</tag2>
</tag1> (2 Replies)
Discussion started by: reachsam11
2 Replies
6. Shell Programming and Scripting
Pls help in formatting a txt file using shell scripting
Input file format:
Name priya 2010-09-21 10:43:49
TEXT ID 1
hi
TEXT ID 2
how
TEXT ID 3
r
TEXT ID 4
u
Output required:
name priya hi how r u (4 Replies)
Discussion started by: bha148
4 Replies
7. Shell Programming and Scripting
hi thanks a lot
But pls help me if my input file is the below format:
Name priya 2010-09-21 10:43:49
TEXT ID 1
hi
TEXT ID 2
how
TEXT ID 3
r
TEXT ID 4
u
Name2 priya2 2010-09-21 10:43:49
TEXT ID 1
hi1
TEXT ID 2
how1
TEXT ID 3
r1 (4 Replies)
Discussion started by: bha148
4 Replies
8. UNIX for Beginners Questions & Answers
Hi All,
Need to modify a file basically join the extra line to one I am having a file like below
And would like to make it as below . (4 Replies)
Discussion started by: arunkumar_mca
4 Replies
9. UNIX for Beginners Questions & Answers
Hi all,
I am having the file below
I need that as below
Thanks,
Arun (12 Replies)
Discussion started by: arunkumar_mca
12 Replies
10. Shell Programming and Scripting
I have a file like below
position1 0 7802 7802 0 client1 - -
position1 8 8032 8032 0 client1 ... (7 Replies)
Discussion started by: manas_ranjan
7 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [-an] [-e s] [-o list] [-tc] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
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.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1).
BUGS
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 join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)