Hello frans,we can't use the join command directly to solve this problem.Because,mr_monocyte wants to deal with 1000 files not only two files which is accepted by join command.But,its a good idea if we have less number of files.mr_monocyte,use the following script to do your requirement.
Code:
k=0
for i in $* #reading the command line arguments which are all files given
do
k=0
while read line #reading line by line from the file
do
if [[ $i == $1 ]];then #checking whether the file received is first file
arr[$k]=$line
let k+=1
else
val=`echo $line | cut -d ' ' -f 1` #getting the first id to match
if [[ $val == `echo ${arr[$k]} | cut -d ' ' -f 1` ]];then #checking whether both the values are equal
result[$k]=${result[$k]},`echo $line | cut -d ' ' -f 2` #storing it in an array
let k+=1 #incrementing the array index
fi
fi
done < $i
done
for((l=0;l<${#result[@]};l++)) #traversing the list stored in an array
do
echo `echo ${arr[$l]} | cut -d ' ' -f 1`,`echo ${arr[$l]} | cut -d ' ' -f 2`${result[$l]} #printing the resulting output
#If you want the output to be in file,use the following command
echo `echo ${arr[$l]} | cut -d ' ' -f 1`,`echo ${arr[$l]} | cut -d ' ' -f 2`${result[$l]} >> result #printing the resulting output
done
hi!
i would like to process two input text files
text1
9835023 20051004F2_011
9835021 20060904FAL0132006
8835099 20051004HOL011
8835044 20051004H1_011
6835023 20061002HAL0132006
4835099 20050721F1_011
4835088 ... (6 Replies)
I have a task to move more than 35000 files every two hours, from the same directory to another directory based on a file that has the list of filenames
I tried the following logics
(1)
find . -name \*.dat > list
for i in `cat list` do mv $i test/ done
(2)
cat list|xargs -i mv "{}"... (7 Replies)
I have a large Filesystem on an AIX server and another one on a Red Hat box. I have syncd the two filesystems using rsysnc.
What Im looking for is a script that would compare to the two filesystems to make sure the bits match up and the number of files match up.
its around 2.8 million... (5 Replies)
Hellow i have a large number of files that i want to concatenate to one. these files start with the word 'VOICE_' for example
VOICE_0000000000
VOICE_1223o23u0
VOICE_934934927349
I use the following code:
cat /ODS/prepaid/CDR_FLOW/MEDIATION/VOICE_* >> /ODS/prepaid/CDR_FLOW/WORK/VOICE
... (10 Replies)
Hi. I need to delete a large number of files listed in a txt file. There are over 90000 files in the list. Some of the directory names and some of the file names do have spaces in them.
In the file, each line is a full path to a file:
/path/to/the files/file1
/path/to/some other/files/file 2... (4 Replies)
I have one space delimited file with multiple columns and one tab delimited file with multiple columns (They have the same number of rows). I want to basically combine these two text files into a new text file by column. How would I go about doing that? (1 Reply)
Hi All,
I have searched this forum for related posts but could not find one that fits mine. I have a shell script which removes all the XML tags including the text inside the tags from some 4 million XML files.
The shell script looks like this (MODIFIED):
find . "*.xml" -print | while read... (6 Replies)
Hi,
I have a large number of subdirectories (>200), and in each of these directories there is a file with a name like "opp1234.dat".
I'd like to know how I could change the names of these files to say "out.dat" in all these subdirectories in one go.
Thanks! (5 Replies)
Want to sftp large number of files ... approx 150 files will come to server every minute. (AIX box)
Also need make sure file has been sftped successfully...
Please let me know :
1. What is the best / faster way to transfer files?
2. should I use batch option -b so that connectivity will be... (3 Replies)
Hi All,
I am having a situation now to delete a huge number of temp files created during run times approx. 16700+ files. We have never imagined that we will get this this much big list of files during run time. It worked fine for lesser no of files in the list. But when list is huge we are... (7 Replies)
Discussion started by: mad man
7 Replies
LEARN ABOUT OPENSOLARIS
sccs-val
sccs-val(1) User Commands sccs-val(1)NAME
sccs-val, val - validate an SCCS file
SYNOPSIS
val [-s] [-m name] [-rsid] [-y type] s.filename...
DESCRIPTION
The val utility determines if the specified s.files meet the characteristics specified by the indicated arguments. val can process up to 50
files on a single command line.
val has a special argument, `-', which reads the standard input until the end-of-file condition is detected. Each line read is indepen-
dently processed as if it were a command line argument list.
val generates diagnostic messages on the standard output for each command line and file processed and also returns a single 8-bit code upon
exit as described below.
The 8-bit code returned by val is a disjunction of the possible errors, that is, it can be interpreted as a bit string where (moving from
left to right) the bits set are interpreted as follows:
bit 0 = missing file argument
bit 1 = unknown or duplicate option
bit 2 = corrupted s.file
bit 3 = can not open file or file not in s.file format
bit 4 = the SCCS delta ID (SID) is invalid or ambiguous
bit 5 = the SID does not exist
bit 6 = mismatch between Y% and -y argument
bit 7 = mismatch between sccs-val.1 and -m argument
val can process two or more files on a given command line, and in turn can process multiple command lines (when reading the standard
input). In these cases, an aggregate code is returned which is the logical OR of the codes generated for each command line and file pro-
cessed.
OPTIONS
The following options are supported:
-s Silent. Suppresses the normal error or warning messages.
-m name Compares name with the %M% ID keyword in the s.file.
-rsid Checks to see if the indicated SID is ambiguous, invalid, or absent from the s.file.
-y type Compares type with the %Y% ID keyword.
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of val: LANG, LC_ALL, LC_CTYPE, LC_MES-
SAGES, and NLSPATH.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsprot |
+-----------------------------+-----------------------------+
|Interface Stability |Committed |
+-----------------------------+-----------------------------+
|Standard |See standards(5). |
+-----------------------------+-----------------------------+
SEE ALSO sccs(1), sccs-admin(1), sccs-delta(1), sccs-get(1), sccs-help(1), what(1), sccsfile(4), attributes(5), environ(5), standards(5)DIAGNOSTICS
Use the SCCS help command for explanations (see sccs-help(1)).
SunOS 5.11 17 Jan 2008 sccs-val(1)