General :: Compare Semicolon Separated Data In 2 Files Using Shell Script?
Nov 16, 2009
I have some data ( seperated by semicolon ) with close to 240 rows in a text file temp1. temp2.txt stores 204 rows of data ( seperated by semicolon ). I want to : Sort the data in both files by field1.i.e first data field in every row. compare the data in both files and print out the rows that are not equal in seperate files. I was trying to do this with excel using vlookup, without a great deal of success. hence, i'm exploring the shell script option.
Code:
temp1.txt
1000xyz400100xyzA00680xyz0;19722.83;19565.7;157.13;11;2.74;11.00
1000xyz400100xyzA00682xyz0;7210.68;4111.53;3099.15;216.95;1.21;216.94
1000xyz430200xyzA00651xyz0;146.70;0.00;0.00;0.00;0.00;0.00
[code]....
View 4 Replies
ADVERTISEMENT
Jul 16, 2011
Dear expertsI have files like
ABD : 5869 events, relative ratio : 1.173800E-01 , sum of ratios : 1.173800E-01
VBD : 12147 events, relative ratio : 2.429400E-01 , sum of ratios : 3.603200E-01
SDF : 17000 events, relative ratio : 3.400000E-01 , sum of ratios : 7.003200E-01
[code]....
View 3 Replies
View Related
Mar 29, 2010
I have a script generating some containing multiple lines. But I want to merge all lines using comma separated.
View 6 Replies
View Related
Nov 10, 2010
I have 2 files to compare and then print out information that match a certain pattern. I know basic scripting and was heading down the path of merging the 2 files together but this is the wrong approach. Would really appreciate a script that can do what is required:
file 1 contains dates, times and ID's:
2010-10-28 10:42 5939697357
2010-10-28 11:56 5919543491
[code]...
View 4 Replies
View Related
Jul 29, 2010
what command is to be used to call strings from other files to the script and then comparing strings from two different files in the script to check if strings are matched then return the result to another script.
View 1 Replies
View Related
Jul 22, 2010
What is the best and simplest way to compare two directory structures without actually comparing the data in files. This works fine:
diff -qr dir1 dir2
But it's really slow because it's comparing files too. Is there a switch for diff or another simple cli tool to do this?
View 4 Replies
View Related
Oct 10, 2010
I wanted to randomize the comma separated string.String like "test1,test34,test5,test6".And it would be displayed differently when I ran each time.
Expected output like "test5,test6,test1,test34".
View 13 Replies
View Related
Mar 8, 2010
I want to compare the following two tab-delimited .txt files (both were subsets of the original files) by comparing Columns 3 and 4 simultaneously. It is easy to compare C3 because both C3s are just numbers. But how to compare C4s?Basically, in File1, "G,G" = G in File2, "C,C" = C in File2, "A,A" = A in File2, "T,T"= T in File2.In File2, A/T in Column4 just equals "A,T" or "T,A" in Column4 of File1. C/T in Column4 just equals "C,T" or "T,C" in Column4 of File1, and etc.
File1:
C1C2 C3C4
ih509rs12345467244750"G,G"
ih499rs6049687244911"C,C"
ih508- 7244977"A,A"
[code]....
View 2 Replies
View Related
Aug 9, 2011
file 1 :
DB_NAME FIRST_ACTIVE_LOG DBPARTITIONNUM
-------- -------------------- --------------
BP1 279231 0
BP1 12735 1
BP1 12734 2
BP1 12735 3
BP1 12616 4
[Code]...
View 4 Replies
View Related
Oct 27, 2009
I want to compare two files in perl, I have two files file1.txt & file2.txt. if column1 on file2.txt match column1 on file1.txt then I want my result on file3.txt (column1 column2 file1.txt + column1 column2 column3 file2.txt). this problem was solved with "awk" but I want to do in perl.
file1.txt
---------
column1 column2
------- -------
linux-2049 1
linux-2817 1
[code]....
View 5 Replies
View Related
Jan 13, 2011
i have file1 and file2.
[Code]...
Here i want to compare these two files with diff command and need to take the common things in a separate file. File contents are 7 strings in length and everything will start with the character e. File 3 contents should be
[Code]...
View 5 Replies
View Related
Mar 29, 2010
I need to compare two binary files and get output in form
for every different byte. So if file1.bin is code...
what is the easiest way to accomplish the goal? Standard tool? Some 3rd party tool?
View 5 Replies
View Related
Apr 12, 2010
How to compare files on ftp-server and in a folder in Linux?
View 4 Replies
View Related
Mar 7, 2010
I want to compare 2 name files, for instance. I got the package foo1.tgz and the foo2.tgz. and I want a script in bash that detects foo2 is newer than foo1 and delete foo1. Can it be done for managing collection of slackware packages.
View 2 Replies
View Related
May 20, 2011
How to compare the files differences between 2 virtualbox snapshots?
View 1 Replies
View Related
Jul 21, 2011
in the shell. how do i compare 2 text files and change matching lines in one of the files ?
example:
cat file_1.txt
line_1
[code]...
View 6 Replies
View Related
Apr 5, 2011
How can I use diff to compare the files of similar directories on to diferent linux boxes.
View 1 Replies
View Related
Feb 15, 2011
I'm working with Radiotap headers right now. I want to get the RSSI data. I came through a problem that I can't figure out right now.The value that I need to get is:
Code:
s8 IEEE80211_RADIOTAP_DBM_ANTSIGNAL
now, when I printf it:
[code]...
View 4 Replies
View Related
Nov 19, 2008
I have this program:
#! /usr/bin/perl
use DBI ;
use strict ;
[code]....
and I get this error simply running the program from the command line: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ./submit.cgi line 24.
is this the right syntax to use, both, for this line:
my (@param) = $cgi->param("firstname","lastname","type") ;
as well as this one:
$sth=$dbh->prepare ("SELECT firstname,lastname,type FROM dts WHERE firstname LIKE $param[0] AND lastname LIKE $param[1] and type LIKE $param[2]" );
or should there be quotes around the $param[0] or something? (also is it $param[0] or $param(0)?)
View 1 Replies
View Related
Jun 16, 2011
I am using the diff command with the -r option, to compare a large number of files and files in subdirectories. My main interest is to find out which files have been changed, and not what the actual changes are, and since a lot of files has been changed, it would be a lot easier to view the file names only. Is there and option for diff that might do this, or does there exist a similar tool/command that could do the job?
View 1 Replies
View Related
Feb 8, 2011
this is how we append a file at command line its like
cat>>file.txt
adasds
^D
but how to write the code for appending a file in a shell script i tried but its not running
cho "the contents of the file before appending"
cat ab.txt
echo `cat >> ab.txt
[code]....
View 3 Replies
View Related
May 7, 2011
1. Every Sunday2. Find all files older than 1 day3. Gzip these file4. Tar up the gzipped files into one tar file.5. Name the tarball with a date stamp indicating what day it was created, so we know that week's files are in the file
View 3 Replies
View Related
Mar 24, 2010
I have two files (not sorted) and need to compare line by line (i.e. first line of file1 to be compared to all the lines of file2 and so as for the rest of file1). Output will be an array of length of file2. Any suggestion in BASH other than a grep inside two read line loops ( which is time consuming for files ~1000s of lines).
View 2 Replies
View Related
Mar 10, 2010
How can I compare two pdf files for text differences
View 3 Replies
View Related
Dec 20, 2010
I would like to compare them, in terms of amplitude, length, tempo, ... Which program could basically analyse them giving an sufficient output data
View 2 Replies
View Related
Sep 12, 2010
I have to write a script that accepts two directory names (JIIT, JUIT) as positional parameters and checks which files are identical in both directories and files having same contents are also considered as identical in same directory. I tried using diff:
#both directories contain three files...file1, file2, file3
echo "Enter the directories:"
read d1
read d2
cd $d1
if diff file1.sh file2.sh > /dev/null
then echo same 1,2
else echo different
fi
if diff file1.sh file3.sh > /dev/null
then echo same 1,3
else echo different
fi
if diff file2.sh file3.sh > /dev/null
then echo same 3,2
else echo different
fi
cd ../
cd $d2
.....
I used the same code in the other directory for the three files. This is not running. I also want to know what to do when I need to compare files from different directories. i.e., JIIT, JUIT..
View 3 Replies
View Related
Mar 28, 2011
I have two files with user DN's that exported from two different LDAP directories. I wanted to write a script that reads(checks) users (cn=user1) in file Ack to see if users(cn=user1) exists in file B and give me nice output with what users are missing in file B.I have around 30k users in file A with following format..Quote:
cn=user1,ou=some,o=org
cn=user2,ou=some,o=org
cn=user3,ou=some,o=org
[code]...
View 7 Replies
View Related
Aug 27, 2009
I wrote a script which analysis apache logs. This script generates a tab separated data file. There is two columns in the data. The first column is a file name accessed from remote. The second column shows how many times a file access.
I am looking for a linux command drawing a chart corresponding data.of course, I know that I can draw the chart in OpenOffice Calc. That's not what I need. Because there is some steps to do for a simple chart drawing. If there is a command line tool, then I can write a script that drawing a chart when the data file is updated.
View 6 Replies
View Related
Nov 5, 2010
I would like to compare two md5sum outputs to see if the files match. in my script I have
Code:
ORG_FILE="/path/to/org/file.zip"
NEW_FILE="path/to/new/file.zip"
MD5_ORIG=$(md5sum -b "$ORG_FILE")
[code]....
How do I get just the MD5 hash and not the */.... stuff so I can compare them. i tried Code: JUST_HASH=${$MD5_ORIG:0:32} but All I get is
dir_mon_notify.sh: line 79: ${$MD5_ORIG:0:32}: bad substitution
View 1 Replies
View Related
Feb 1, 2011
got a situation where if i process a command i get a numeric output something like below:
for example:
# cat example.txt
856589
856470
987866
656658
876897
now i want to see this output in single line like below:
856589 856470 987866 656658 876897
how do i get this?
View 10 Replies
View Related
