12-17-2013
Combine files
i have 3 files: file1, file2 and file3
file1 has this content:
#!/bin/ksh
sqlplus username/password@Servername << EOF
file2 has this content:
drop table dropme cascade constraints;
file3 has this content:
EOF
all said and done, file1, file2 and file2 will look like this:
#!/bin/ksh
sqlplus username/password@Servername << EOF
EOF
---------- Post updated at 09:04 PM ---------- Previous update was at 08:51 PM ----------
cat test2 >> test1
cat test3 >> test1
worked for me. if you know a better way, please reach out. thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi all
i have 2 files f1 and f2
i have to combine these 2 files and make a new file f3
when i use paste f1 f2 >f3 its pasting vertically
but i want to paste horizontally
How to do ..
pls let me know (2 Replies)
Discussion started by: ravi.sadani19
2 Replies
2. Shell Programming and Scripting
I have two files: file1 and file2
the content of files1 is:
13
22
333
42
56
55
...
the content of file2 is:
aa
dd
cc
ee
ff
gg
... (1 Reply)
Discussion started by: fredao1
1 Replies
3. Shell Programming and Scripting
I have 2 files that I need to combine.
One file is looks like this:
71664107;1;1;05-FEB-07;12-FEB-07;
The other file looks like this:
U;71664107;dummy;Pirovano;M;04-SEP-75;Georgia;MI;1;1;31;S;S;;;Y;05-02-2007;0;12-FEB-07;
I need to combine both files together. I need the shorter... (4 Replies)
Discussion started by: goodmis
4 Replies
4. HP-UX
Hi :
I have a file containing the print queues with their IP address. I wanted to combine the 'lpstat' output with their respective IP address.
For example :
zebhtrmb-6078 lgonzale priority 0 Mar 17 11:50 on zebhtrmb
with
zebhtrmb-6078 lgonzale priority 0 ... (1 Reply)
Discussion started by: rdasari
1 Replies
5. Shell Programming and Scripting
Hi All ,
Any one help me to combine two files in shell scripting .Below is my requrement
i have 2 files as follows
filea
newyork America
Texas America
london Engalad
Fileb
abc
def
xyz
i have to combine this file as follows
newyork America abc
Texas ... (1 Reply)
Discussion started by: ajmalc
1 Replies
6. Shell Programming and Scripting
Ok here is what I have
file a
{{BEGIN}}
{{FAX
File b
5555464584
5555465292
5555465828
5555485930
5555474939
File C
}}
ON ORDERS LESS THAN 70 LBS AND THE PACKAGE IS A
COMBINED LENGTH AND GIRTH EQUAL TO OR LESS THAN
108" PLEASE UTILIZE UPS. ... (4 Replies)
Discussion started by: sctxms
4 Replies
7. Shell Programming and Scripting
I have multiple files; each file contains a certain data in a column view
simply i want to combine all those files into one file in columns
example
file1:
a
b
c
d
file 2:
1
2
3
4
file 3:
G (4 Replies)
Discussion started by: ahmedamro
4 Replies
8. Shell Programming and Scripting
Hi,
i have two files. i want to combine records from these two files in below manner :-
first line from first file(1st line)
2nd line from 2nd file(1st line)
3rd line from 1st file(2nd line)
4th line from 2nd file(2nd line)
so on.... (1 Reply)
Discussion started by: deepakiniimt
1 Replies
9. Shell Programming and Scripting
I have n of files with ending with _ZERO.txt
need to combine all file ending with _ZERO.txt into 1 file
ex:
A_ZERO.txt
1
2
B_ZERO.txt
3
4
Output:
FINAL.txt
1
2 (3 Replies)
Discussion started by: satish1222
3 Replies
10. UNIX for Beginners Questions & Answers
i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)
Discussion started by: malaika
2 Replies
comm(1) User Commands comm(1)
NAME
comm - select or reject lines common to two files
SYNOPSIS
comm [-123] file1 file2
DESCRIPTION
The comm utility reads file1 and file2, which must be ordered in the current collating sequence, and produces three text columns as output:
lines only in file1; lines only in file2; and lines in both files.
If the input files were ordered according to the collating sequence of the current locale, the lines written will be in the collating
sequence of the original lines. If not, the results are unspecified.
OPTIONS
The following options are supported:
-1 Suppresses the output column of lines unique to file1.
-2 Suppresses the output column of lines unique to file2.
-3 Suppresses the output column of lines duplicated in file1 and file2.
OPERANDS
The following operands are supported:
file1 A path name of the first file to be compared. If file1 is -, the standard input is used.
file2 A path name of the second file to be compared. If file2 is -, the standard input is used.
USAGE
See largefile(5) for the description of the behavior of comm when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes).
EXAMPLES
Example 1: Printing a list of utilities specified by files
If file1, file2, and file3 each contain a sorted list of utilities, the command
example% comm -23 file1 file2 | comm -23 - file3
prints a list of utilities in file1 not specified by either of the other files. The entry:
example% comm -12 file1 file2 | comm -12 - file3
prints a list of utilities specified by all three files. And the entry:
example% comm -12 file2 file3 | comm -23 -file1
prints a list of utilities specified by both file2 and file3, but not specified in file1.
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of comm: LANG, LC_ALL, LC_COLLATE,
LC_CTYPE, LC_MESSAGES, and NLSPATH.
EXIT STATUS
The following exit values are returned:
0 All input files were successfully output as specified.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWesu |
+-----------------------------+-----------------------------+
|CSI |enabled |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO
cmp(1), diff(1), sort(1), uniq(1), attributes(5), environ(5), largefile(5), standards(5)
SunOS 5.10 3 Mar 2004 comm(1)