12-13-2011
comparing csv files
Hi!
I'm just new to shell scripting n simple tasks looks so tough in initial stage. i need to write a script which will read a property file, property file will be containing count of the csv files, and in a folder(same folder) there will be respective csv files.
like Property file
data1=100
data2=50
data3=45
data4=40
and in a directory corresponding csv files will be there.
I need to make a script that can first read property file and search for the keyword like data1 csv files in folder and match the count, if they are equal proceed proceed further if not send an error mail. i totally confused with this, its like climbing mountain like a newbie for me....plz help me out with this
Thanks a lot..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I've two .csv files as below
file1.csv
abc, tdf, 223, tpx
jgsd, tex, 342, rpy
a, jdjdsd, 423, djfkld
Where as file2.csv is the new version of file1.csv with some added fields in the end of each line and some additional lines.
lfj, eru, 98, jkldj, 39, jdkj9
abc, tdf, 223, tpx,... (3 Replies)
Discussion started by: ganapati
3 Replies
2. Shell Programming and Scripting
Hello,
I have the following problem:
There are two csv files
csv-file #1:
aaa1, aaa2, ... aaan
aaa1, bbb2, ... bbbn
aaa1, ccc2, ... cccn
bbb1, bbb2, ... bbbn
...
zzz1, zzz2, ... zzzn
csv-file #2:
aaa1, matchvalue1
ccc1, matchvalue2 (7 Replies)
Discussion started by: ghl10000
7 Replies
3. Shell Programming and Scripting
EDIT: My problems have been solved thanks to the help of bartus11 and pravin27
This code is just to help me learn. It serves no purpose other than that.
Here's a sample csv that I'm working with -
#listofpeeps.csv
Jackie Chan,1954,M
Chuck Norris,1930,M
Bruce Lee,1940,M
This code is... (13 Replies)
Discussion started by: chickeneaterguy
13 Replies
4. Shell Programming and Scripting
Hi All,
I want to remove the rows from File1.csv by comparing a column/field in the File2.csv. If both columns matches then I want that row to be deleted from File1 using shell script(awk). Here is an example on what I need.
File1.csv:
RAJAK,ACTIVE,1
VIJAY,ACTIVE,2
TAHA,ACTIVE,3... (6 Replies)
Discussion started by: rajak.net
6 Replies
5. Shell Programming and Scripting
Hello,
I have about 10 csv files which range from csv1 - csv10.
Each csv file has same type/set of tabs and we have around 5-6 tabs for each of the csv file which have slightly different content(data).
A sample of CSV1 is shown below:
Joins: Data related to Joins, it can be any number of... (2 Replies)
Discussion started by: bobby1015
2 Replies
6. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
... (1 Reply)
Discussion started by: Naresh101
1 Replies
7. Shell Programming and Scripting
Hi All,
My requirement is to write a shell script to compare two large csv files.
I've created sample files for explaining my problem
i.e., a.csv and b.csv
contents of files:
-----------------
a.csv
------
Type,Memory (Kb),Location HD,Size (Mb),Serial #
XT,640,D402,0,MG0010... (2 Replies)
Discussion started by: vasavi
2 Replies
8. Shell Programming and Scripting
Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison.
Thanks in advance for your help.
File A
A,B,C,45,46... (2 Replies)
Discussion started by: ady_koolz
2 Replies
9. Shell Programming and Scripting
I have two csv files and im trying to compare them. e.g.
SAMPLE DATA:
file one:
ZipCode Name
20878 Washington
10023 Missouri
20304 Maryland
file two:
ID Name City ZipCode
11654 ... (11 Replies)
Discussion started by: dan139
11 Replies
10. UNIX for Beginners Questions & Answers
Hello all,
I have searched high and low for a solution to this, many have come really close but not quite what I'm after.
I have 2 files. One contains GUID's, for example:
8121E002-96FE-4C9C-BC5A-6AFF20DACECD
84468F30-F3B7-418B-81F0-0908E80792BF
A second file, contains a path to the... (8 Replies)
Discussion started by: tirmUK
8 Replies
LEARN ABOUT HPUX
xmactivateprotocol
XmActivateProtocol(library call) XmActivateProtocol(library call)
NAME
XmActivateProtocol -- A VendorShell function that activates a protocol
SYNOPSIS
#include <Xm/Protocols.h>
void XmActivateProtocol(
Widget shell,
Atom property,
Atom protocol);
DESCRIPTION
XmActivateProtocol activates a protocol. It updates the handlers and the property if the shell is realized. It is sometimes useful to allow
a protocol's state information (callback lists, and so on) to persist, even though the client may choose to temporarily resign from the
interaction. This is supported by allowing a protocol to be in one of two states: active or inactive. If the protocol is active and the
shell is realized, the property contains the protocol Atom. If the protocol is inactive, the Atom is not present in the property.
XmActivateWMProtocol is a convenience interface. It calls XmActivateProtocol with the property value set to the atom returned by interning
WM_PROTOCOLS.
shell Specifies the widget with which the protocol property is associated
property Specifies the protocol property
protocol Specifies the protocol Atom
For a complete definition of VendorShell and its associated resources, see VendorShell(3).
RELATED
VendorShell(3), XmActivateWMProtocol(3), XmRemoveProtocols(3) and XmInternAtom(3).
XmActivateProtocol(library call)