07-20-2010
Help with shell scripting for accepting .csv files as CLA
I want to automate test script on shell scripting.
There are 2 .csv files named account.csv and balance.csv.These files needs to passed as command line arguments and the following logic needs to applied further.
Any account with a balance that was due before Oct 23, 2007 has an overdue value of 1
Any account without an overdue balance has a NULL overdue value (empty in the csv files) or an overdue value of 0
Write an automated test script to verify that the data in the files is correct. Your script should take in 2 command line arguments - the name of the account file and the name of the balance file. The output should indicate any problem accounts and nothing for accounts that have their overdue value properly set.
Files with 2 sample accts
accounts.csv
id name date acctno overdue
1 A 9/13/2007 15.36 12345 1
2 B 11/24/2006 15.36 12346
balance.csv
id acctno balance balance_due
1 12345 482.69 11/28/2007 15.54
2 12356 226.69 10/9/2007 15.54
Thanks in advance
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I need a shell script which could insert a sequence number column inside a dat file(pipe delimited).
I have the dat file similar to the one as shown below..
|A|B|C||D|E
|F|G|H||I|J
|K|L|M||N|O
|P|Q|R||S|T
As shown above, the column 4 is currently blank and i need to insert sequence... (5 Replies)
Discussion started by: nithins007
5 Replies
2. Shell Programming and Scripting
Hello friends,
I have a file as follows:
"empty line"
content1
content2
content3
content1
content2
content3
content1
content2
content3
It starts with an empty line,
how can i get a csv like this: (12 Replies)
Discussion started by: kraterions
12 Replies
3. Shell Programming and Scripting
Hi,
Can anyone help me how to convert a .csv file to a .pdf file using shell script
Thanks (2 Replies)
Discussion started by: ssk250
2 Replies
4. Shell Programming and Scripting
hi all i have a reporting work and i want it to be automated using shell scripting kindly let me know how can i make that possibe .
eg data are :... (2 Replies)
Discussion started by: Avinash shaw
2 Replies
5. Shell Programming and Scripting
Hi,
I need to calculate the average of the following values using shell scripitng.
Can anyone please suggest a solution?
... (10 Replies)
Discussion started by: karan pratap si
10 Replies
6. Shell Programming and Scripting
Hi,
Very good wishes to all!
Please help to provide the shell script for generating the record counts in filed wise from the .csv file
My question:
Source file:
Field1 Field2 Field3
abc 12f sLm
1234 hjd 12d
Hyd 34
Chn
My target file should generate the .csv file with the... (14 Replies)
Discussion started by: Kirands
14 Replies
7. Shell Programming and Scripting
Hi,
I need to remove first column from a csv file and i can do this by using below command.
cut -f1 -d, --complement Mytest.csv
I need to implement this in shell scripting, Whenever i am using the above command alone in command line it is working fine.
I have 5 files in my directory and... (3 Replies)
Discussion started by: Samah
3 Replies
8. Shell Programming and Scripting
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies
9. UNIX for Beginners Questions & Answers
I have two CSV files file1, file2 as below
File 1:
Key, Value1, Value2, Value3, Value4,......value
A,50,100,50,40,....,100
File 2:
Key, value1,Value2,Value3,Value 4 so on...
A,50,80,45,50.....
Now, I want to check if key from file 1 is present in file 2 or not if present I want to... (9 Replies)
Discussion started by: hustler
9 Replies
10. UNIX for Beginners Questions & Answers
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
LEARN ABOUT CENTOS
processcsv.py
PROCESSCSV.PY(1) Virtualization Support PROCESSCSV.PY(1)
NAME
processcsv.py - process virt-top CSV files
SUMMARY
virt-top --csv data.csv
processcsv.py < data.csv
DESCRIPTION
virt-top is a top(1)-like utility for showing stats of virtualized domains.
processcsv.py is a simple Python script that post-processes the output of "virt-top --csv".
It is used like this:
virt-top --csv data.csv
processcsv.py < data.csv
The second command will overwrite the following files in the current directory:
"global.csv"
This contains the global (host) statistics columns from the CSV file.
"domainNN.csv" (multiple files)
For each libvirt domain ID NN, a file is created containing the per-domain statistics from the CSV file.
SEE ALSO
virt-top(1)
AUTHORS
Richard W.M. Jones <rjones @ redhat . com>
COPYRIGHT
(C) Copyright 2007-2012 Red Hat Inc., Richard W.M. Jones http://libvirt.org/
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
virt-top-1.0.8 2013-12-29 PROCESSCSV.PY(1)