04-25-2013
Quote:
Originally Posted by
ks_reddy
Thank you so much Skrynesaver for your quick reply.
But my data has many context columns(10) in each pair of files and also many data columns in both files.
The total pairs of files I have is around 5000.
So any generic script to couple every 2 similar context files will be highly helpful.
Thanks
Try adapting my scriptlet to your data and come back with (suitably anonimised) examples of where you are having difficulty.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I have two files file1 and file2. I have to merge the columns of those two files into file3 based on common column of two files. To be simple.
file1:
Row-id name1
13456 Rahul
16789 Vishal
18901 Karan
file2 :
Row-id place
18901 Mumbai
... (2 Replies)
Discussion started by: manneni prakash
2 Replies
2. Shell Programming and Scripting
Hi All,
I do have 2 files
file 1 has 4 tab delimited columns
234 a c dfgyu
294 b g fih
302 c h jzh
328 z c san
597 f g son
File 2 has 2 tab delimted columns
234 23
302 24
597 24
I want to merge file 2 with file 1 based on the data common in both files which is the first column so... (6 Replies)
Discussion started by: Lucky Ali
6 Replies
3. UNIX for Dummies Questions & Answers
So I have two text files. The first one looks like this:
refsnp_id chr_name chrom_start
1 rs1000000 12 126890980
2 rs10000010 4 21618674
3 rs10000012 4 1357325
4 rs10000013 4 37225069
5 rs1000002 3 183635768
And the second one looks like this:
AUC rs1000000 0.03 0.1240
AUC ... (4 Replies)
Discussion started by: evelibertine
4 Replies
4. UNIX for Dummies Questions & Answers
I have two text files. One has two columns and looks like below:
rs# otherallele_freq
rs10399749 0
rs4030303 0
rs4030300 0
rs940550 1.000
rs13328714 0
rs11490937 0
rs6683466 0
rs12025928 1.000
rs6650104 0
rs11240781 0... (5 Replies)
Discussion started by: evelibertine
5 Replies
5. Shell Programming and Scripting
Hi,
I need help to read file in a directory on basis of time stamp.
e.g. If file access in last 2 minutes it should not be copy to remote directory.
Below is my script.
+++++++++++++++++++++++++
#!/bin/ksh
DATE=`date +"%Y-%m-%d_%H%M"`
SEPARATER=" "
exec < out_interfaces.cfg... (1 Reply)
Discussion started by: qamar.alam
1 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have to text files that I want to merge by the first column. The values in the first column pretty much match for the first part. However there are some values that are present in column 1 and not present in column 2 or vice versa. For such values I would like to substitute X for the... (9 Replies)
Discussion started by: evelibertine
9 Replies
7. Shell Programming and Scripting
Hi, I am trying to merge information across 2 files. The first file is a "master" file, with all IDS. File 2 contains a subset of IDs of those in File 1.
I would like to match up individuals in File 1 and File 2, and add information in File 2 to that of File 1 if they appear. However, if an... (3 Replies)
Discussion started by: hubleo
3 Replies
8. Shell Programming and Scripting
Hi
I have file1 as
IJU_NSOMOW;
SOWWOD_TWUIQ;
and file2 as
how are you?;
fine there;
Now my problem is i need the output file as
IJU_NSOMOW; how are you?;
SOWWOD_TWUIQ; fine there; (2 Replies)
Discussion started by: Priya Amaresh
2 Replies
9. Shell Programming and Scripting
Hi Folks,
Need a clarification on files with date and time stamp.
Here is my requirement. There is a file created everyday with the following format "file.txt.YYYYMMDDHHMMSS".
Now i need to check for this file and if it is available then i need to do some task to the file.
I tried... (6 Replies)
Discussion started by: jayadanabalan
6 Replies
10. Shell Programming and Scripting
Hi ,
I want to add a new column 'current_time stamp' in my existing csv file with current time stamp for all the records.I tried something this but this is printing 0 with date & time and printed date one line above header.Please help
awk -F "," 'BEGIN{ OFS="," } {$6=system("date... (5 Replies)
Discussion started by: netdbaind
5 Replies
quot(1M) System Administration Commands quot(1M)
NAME
quot - summarize file system ownership
SYNOPSIS
quot [-acfhnv] filesystem...
quot -a [-cfhnv]
DESCRIPTION
quot displays the number of blocks (1024 bytes) in the named filesystem (one or more) currently owned by each user. There is a limit of
2048 blocks. Files larger than this will be counted as a 2048 block file, but the total block count will be correct.
OPTIONS
The following options are supported:
-a Generate a report for all mounted file systems.
-c Display three columns giving a file size in blocks, the number of files of that size, and a cumulative total of blocks containing
files of that size or a smaller size.
-f Display three columns giving, for each user, the number of blocks owned, the count of number of files, and the user name. This
option is incompatible with the -c and -v options.
-h Estimate the number of blocks in the file. This does not account for files with holes in them.
-n Attach names to the list of files read from standard input. quot -n cannot be used alone, because it expects data from standard
input. For example, the pipeline
ncheck myfilesystem | sort +0n | quot -n myfilesystem
will produce a list of all files and their owners. This option is incompatible with all other options.
-v In addition to the default output, display three columns containing the number of blocks not accessed in the last 30, 60, and 90
days.
OPERANDS
filesystem mount-point of the filesystem(s) being checked
USAGE
See largefile(5) for the description of the behavior of quot when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes).
EXIT STATUS
0 Successful operation.
32 Error condition (bad or missing argument, bad path, or other error).
FILES
/etc/mnttab Lists mounted file systems.
/etc/passwd Used to obtain user names
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
du(1), mnttab(4), passwd(4), attributes(5), largefile(5)
NOTES
This command can only be used by the super-user.
SunOS 5.10 30 May 2001 quot(1M)