08-01-2008
Concatenate rows in to 2 files
I have 2 files
FILEA
1232342
1232342
2344767
4576823
2325642
FILEB
3472328
2347248
1237123
1232344
8787890
I want the output to go into a 3rd file and look like:
FILEC
1232342 3472328
1232342 2347248
2344767 1237123
4576823 1232344
2325642 8787890
Can you please suggest how can i concatenate contents of these 2 files and rows.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to search a file for two values (valueA & valueB). ValueA will be on a different row than valueB, and concatenate the two together on the same row of my output.
Example: search input file for strings "node" and "OS", combine the two results into one row
input
node A
text
text
OS... (4 Replies)
Discussion started by: indianadoug
4 Replies
2. Shell Programming and Scripting
need a shell which perform following function
file 1 ( every time new data comes)
1212
2323
3434
4545
5656
.
.
.
.
file 2 (fixed line)
update bc_tbl set aix=data , bix=back where cix=U and serial=;
now when i execute shell it will concatinate file 1, file 2 & make file 3 as... (3 Replies)
Discussion started by: The_Archer
3 Replies
3. Shell Programming and Scripting
i have a file as below and i need to load it into oracle. The problem is, some of the rows are in 2 lines.
123456_PosWlist ----- ----- IN 0/0
123456_PosWListRpt ----- ----- IN 0/0
123456_PosWListCSV
----- -----... (7 Replies)
Discussion started by: Amit.Sagpariya
7 Replies
4. Shell Programming and Scripting
Hi Guys,
I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language
the text file contains data in a pipe delimited format
sdfsdfs
sdfsdfsd
START_ROW
sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Discussion started by: manish2009
9 Replies
5. UNIX for Dummies Questions & Answers
Hi guys;
TBH I am an absolute novice, when it comes to scripting; I do have an idea of the basic commands...
Here is my problem;
I have a flatfile 'A' containing a single column with multiple rows. I have to create a script which will use 'A' as input and then output a string in in the... (0 Replies)
Discussion started by: carlos_anubis
0 Replies
6. Shell Programming and Scripting
Hi guys;
TBH I am an absolute novice, when it comes to scripting; I do have an idea of the basic commands...
Here is my problem;
I have a flatfile 'A' containing a single column with multiple rows. I have to create a script which will use 'A' as input and then output a string in in the... (6 Replies)
Discussion started by: carlos_anubis
6 Replies
7. Shell Programming and Scripting
I have a file named "file1" which has the following data
10000
20000
30000
And I have a file named "file2" which has the following data
ABC
DEF
XYZ
My output should be
10000ABC
20000DEF (3 Replies)
Discussion started by: bobby1015
3 Replies
8. UNIX for Dummies Questions & Answers
- Concatenate files and delete source files. Also have to add a comment.
- I need to concatenate 3 files which have the same characters in the beginning and have to remove those files and add a comment and the end.
Example:
cat REJ_FILE_ABC.txt REJ_FILE_XYZ.txt REJ_FILE_PQR.txt >... (0 Replies)
Discussion started by: eskay
0 Replies
9. Shell Programming and Scripting
I need to concatenate the rows that are broken (because of carriage return and line feed) in unix.
Input
123|456|789|""
987|786|"GRT
"|""
3455|896|654|456|""
457|234|"RT"|"PR
TY"|""
Output
123|456|789|""
987|786|"GRT"|""
3455|896|654|456|""
457|234|"RT"|"PRTY"|"" (16 Replies)
Discussion started by: meet_calramz
16 Replies
10. Shell Programming and Scripting
I'm trying to find a way to concatenate consecutive rows (key is column $1 and $2) if column $5 an $6 are integers and redefine ranges in columns $3&$4 and $5&$6
Unfortunately I'm still learning the very basics so I cannot figure a way of doing this with awk.
Input file
15 30 21 21 25.0... (11 Replies)
Discussion started by: alex2005
11 Replies
CAT(1) BSD General Commands Manual CAT(1)
NAME
cat -- concatenate and print files
SYNOPSIS
cat [-beflnstuv] [-] [file ...]
DESCRIPTION
The cat utility reads files sequentially, writing them to the standard output. The file operands are processed in command line order. A
single dash represents the standard input, and may appear multiple times in the file list.
The word ``concatenate'' is just a verbose synonym for ``catenate''.
The options are as follows:
-b Implies the -n option but doesn't number blank lines.
-e Implies the -v option, and displays a dollar sign ('$') at the end of each line as well.
-f Only attempt to display regular files.
-l Set an exclusive advisory lock on the standard output file descriptor. This lock is set using fcntl(2) with the F_SETLKW command.
If the output file is already locked, cat will block until the lock is acquired.
-n Number the output lines, starting at 1.
-s Squeeze multiple adjacent empty lines, causing the output to be single spaced.
-t Implies the -v option, and displays tab characters as '^I' as well.
-u The -u option guarantees that the output is unbuffered.
-v Displays non-printing characters so they are visible. Control characters print as '^X' for control-X; the delete character (octal
0177) prints as '^?'. Non-ascii characters (with the high bit set) are printed as 'M-' (for meta) followed by the character for the
low 7 bits.
EXIT STATUS
The cat utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
The command:
cat file1
will print the contents of file1 to the standard output.
The command:
cat file1 file2 > file3
will sequentially print the contents of file1 and file2 to the file file3, truncating file3 if it already exists. See the manual page for
your shell (i.e., sh(1)) for more information on redirection.
The command:
cat file1 - file2 - file3
will print the contents of file1, print data it receives from the standard input until it receives an EOF ('^D') character, print the con-
tents of file2, read and output contents of the standard input again, then finally output the contents of file3. Note that if the standard
input referred to a file, the second dash on the command-line would have no effect, since the entire contents of the file would have already
been read and printed by cat when it encountered the first '-' operand.
SEE ALSO
head(1), hexdump(1), lpr(1), more(1), pr(1), tail(1), view(1), vis(1), fcntl(2)
Rob Pike, "UNIX Style, or cat -v Considered Harmful", USENIX Summer Conference Proceedings, 1983.
STANDARDS
The cat utility is expected to conform to the IEEE Std 1003.2-1992 (``POSIX.2'') specification.
The flags [-belnstv] are extensions to the specification.
HISTORY
A cat utility appeared in Version 1 AT&T UNIX. Dennis Ritchie designed and wrote the first man page. It appears to have been cat(1).
BUGS
Because of the shell language mechanism used to perform output redirection, the command ``cat file1 file2 > file1'' will cause the original
data in file1 to be destroyed! This is performed by the shell before cat is run.
BSD
September 23, 2006 BSD