09-12-2008
Sorry I am not sure of fully understanding what you are trying to achieve. Is is about concatenating the 6 files in one? can you not use cat file1 >> OutputFile and then cat file2 >> OutputFile and so on?
As per the common key, you mean there is a field content that is shared by all the files? Can you provide a shorter example (just 2 or 3 files) with some contents and the expected output file? Like:
File1
xxxxxxxxxx
File2
xxxxxxxxxx
Output File
xxxxxxxxxxxxxxxxxxx
If you want to extract the first field from your files using awk then you can do
cat theFile | awk -F, '{print $1}'
but I am not sure if that's what you are looking for.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
My query is now a bit simplified.
file1.txt
names; ID; value1 ; values N;
ABC; 1 ; a18 ; ...
CDF; 2 ; b16 ; ..
ABC; 1 ; c13 ; ......
EFG; 3 ;d12 ; ...
file2.txt
ID(Unique);smVals; smVal1; smVal N;
1; ...; ...; ...;
2; ..; ..; ..;
3; ..; ..; ..; ... (1 Reply)
Discussion started by: szchmaltz
1 Replies
2. Shell Programming and Scripting
Hello,
I have a text file like this:
NONE FILE_Rename
frompath: /log_audit/AIX/log/current/AIXAFTPP.log
NONE FILE_Unlink
filename /audit/tempfile.14041142
NONE FILE_Rename ... (8 Replies)
Discussion started by: carloskl
8 Replies
3. Programming
By launching two SQL scripts I get two html files report_1.html and report_2.html with different background and text colors (white/blue for the former and silver/black for the latter) but if I try to concat the two html by using the CAT function on UNIX Server where Oracle is installed (cat... (1 Reply)
Discussion started by: Mark1970
1 Replies
4. Web Development
By launching two SQL scripts I get two html files report_1.html and report_2.html with different background and text colors (white/blue for the former and silver/black for the latter) but if I try to concat the two html by using the CAT function on UNIX Server where Oracle is installed (cat... (2 Replies)
Discussion started by: Mark1970
2 Replies
5. Shell Programming and Scripting
Hi All
this may be somewhere in internet , but couldnt find the it.
i have file as
abc01
2010-07-01 12:45:24
2010-07-01 12:54:35
abc02
2010-07-01 12:59:24
2010-07-01 01:05:13
abc03
.
.
.
the output using awk should look like this
abc01|2010-07-01 12:45:24|2010-07-01 12:54:35... (3 Replies)
Discussion started by: posner
3 Replies
6. Shell Programming and Scripting
Hi ,
Need help in concating two lines based on certain character, for example my file has the messages :
:57A:qweqweww
:58A:qeqewqeqe
-}$
{1:fffff2232323}{2:123123dasds}{4:
:20:121323232323232
:21:sdsadasdasddadad
if the line ends with "-}$" or if a line starts with "{1:" then it... (5 Replies)
Discussion started by: ulin
5 Replies
7. Shell Programming and Scripting
Hello Unix gurus,
how to concat 3 files content side by side .
i have 3 files
more report1.txt
select *from tab1 A JOIN tab1 B ON
more report2.txt
A.PK1=B.PK1 where
more report3.txt
A.AAA <> B.AAA or
A.BBB <> B.BBB or
A.CCC<> B.CCCC or
..
..
..
A.ZZZ <> B.ZZZ;
if i concatinate... (3 Replies)
Discussion started by: kanakaraju
3 Replies
8. Shell Programming and Scripting
I would like to print string between two sequent digits and concatenate it into one single line.
input.txt
99 cord, rope, strand, twine,
twist, 100 strand, twine, twist,
cord, rope 101 strand, twine,
twist, twine, twist, cord, rope
105 cord, rope ,twi ... (8 Replies)
Discussion started by: sdf
8 Replies
9. UNIX for Dummies Questions & Answers
I have a file with line 4 : F SITE SPA_M2 SPA_M3 SPA_M4
and a line 237 with: BV_N4 VbdGO_PW Rs_NW_STI Rc_N+OD
need a awk liner to concat the two lines so that line 2 sits next to line1 and looks like:
F SITE SPA_M2 SPA_M3 SPA_M4 BV_N4 VbdGO_PW ... (8 Replies)
Discussion started by: awkaddict
8 Replies
10. Shell Programming and Scripting
Here is the structure of my file:
MyFile.txt
g-4.n.g.fr 10.147.243.63 g-4.n.g.fr-w1
Here is my sript:
test.sh
#! /bin/sh
ip=10.147.243.63
worker=$(grep -e $ip $1 | awk '{ print $3; }')
echo ""
echo $worker
echo ""
echo $worker
echo ""
echo "$worker.v.1"
echo... (7 Replies)
Discussion started by: chercheur111
7 Replies
LEARN ABOUT OPENSOLARIS
gnomevfs-cat
gnomevfs-cat(1) User Commands gnomevfs-cat(1)
NAME
gnomevfs-cat - print a file to standard output using the VFS system
SYNOPSIS
gnomevfs-cat URI
DESCRIPTION
gnomevfs-cat is obsolete. It has been superseded by gvfs-cat. See gvfs-cat(1).
gnomevfs-cat prints a file to standard output using the virtual file system to access the file via a URI.
OPERANDS
The following operands are supported:
URI Specifies the file location in standard URI format.
EXAMPLES
Example 1: Cat a File From a Web Server
example% gnomevfs-cat http://www.sun.com
Example 2: Cat a Local File
example% gnomevfs-cat file:///home/user/README.txt
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables: NLSPATH.
EXIT STATUS
The exit value 0 is returned regardless of success or failure.
FILES
The following files are used by this application:
/usr/bin/gnomevfs-cat Executable to print a file to standard output using the VFS system
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-vfs |
+-----------------------------+-----------------------------+
|Interface stability |Obsolete Volatile |
+-----------------------------+-----------------------------+
SEE ALSO
gnomevfs-copy(1), gnomevfs-info(1), gnomevfs-ls(1), gnomevfs-mkdir(1), gvfs-cat(1), attributes(5), environ(5)
NOTES
Written by Stephen Browne, Sun Microsystems Inc., 2004.
SunOS 5.11 14 May 2008 gnomevfs-cat(1)