08-12-2008
Doing Checks on a file
I have a process that I am trying to provide a solution for and have hit a brick wall and would like some pointers in the right direction.
Basically on a daily basis a report is automatically generated in a CSV format (FIRST.CSV) which includes codes and amounts in the following format:
A016ZZ ,, 1400.43
A011ZZ ,, 15000.98
B014ZZ ,, -450.83
B027ZZ ,, 86.90
.....
The amounts can be negative or positive. The codes on the other hand always have to begin with A or B and have to always end with ZZ.
Anyway after this file has been scrutinised it usually needs some amendments, however to amend the file a second CSV file (SECOND.CSV) file is created manually in the same format as above. That is codes and the corresponding values.
These 2 files then need to be merged which is fine, but before it can be merged the second file (SECOND.CSV) needs to have some checks run on to ensure each code begins with an A or B followed by three numrical figures followed by the 'ZZ'post fix.
Could anyone assist as to how this check can be done. I have got as far as this:
if [ `cat ${SECOND.CSV} | egrep -v '^L|^M' | wc -l` -gt 0 ]
then
print "code other than A or B present."
exit 1
fi
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi
i want check for PVCS header in file if its present then check if its in proper format or not i want to do this is in perl on windows.
this is what i am doing :
1 . open file
2 . check for "PVCS information" if found then store the line no to $line var.
3 . check for "sccs" header ... (0 Replies)
Discussion started by: zedex
0 Replies
2. UNIX for Dummies Questions & Answers
Hello
Anyone please help me with a health check script on HP-UX. (1 Reply)
Discussion started by: mahlathini
1 Replies
3. Shell Programming and Scripting
Hi,
I have a file abc.txt with data like this
1 /test/
2 /test/file.txt
3 /data/
4 /data/file1.txt
5 /data/file2.txt
I want to take out every path from the file and check if its a directory or file.
I am trying it with cut with something like this but it doesnt work
... (7 Replies)
Discussion started by: muaz
7 Replies
4. UNIX for Advanced & Expert Users
Need to make a very fast file existence checker. Passing in 20-50K num of files
In the code below ${file} is a file with a listing of +20,000 files. test_speed is the script. I am commenting out the results of <time test_speed try>.
The normal "test -f" is much much too slow when a system... (2 Replies)
Discussion started by: nullwhat
2 Replies
5. AIX
AIX Guys!!!
What pre-checks would you do on a 5.3 server before TL/SP/APAR installation?
Bala (2 Replies)
Discussion started by: balaji_prk
2 Replies
6. UNIX for Dummies Questions & Answers
Hello all,
I'm sorry if this is answered elsewhere, I've used the search function and can't find the specifics of what I'm after.
I am brand new to playing with linux, and ideally I want to get better to help the company that I now work for.
What I want to do:
Create a script that I... (4 Replies)
Discussion started by: Aussiemick
4 Replies
7. Shell Programming and Scripting
Hey Guys,
I'm seeking some assistance in getting this script to run as a cron job for the user oracle.. the script is basically to perform 2 ADRCI checks... see the script below... i'm getting the following error: /export/home/oracle/Daily_Checks/ADRCI_Daily_Checks.sh: syntax error at line 16:... (7 Replies)
Discussion started by: Racegod
7 Replies
8. Shell Programming and Scripting
Hi ,
I need a script for processing below scenario.
I have to check daily by doing ftp IP to check it is logging or not.
So i want this activity to be automated such that if login succesful i will get "FTP LOGIN SUCCESS" in a log file and if fails i want the error message in the same log... (1 Reply)
Discussion started by: sv0081493
1 Replies
9. Shell Programming and Scripting
I have test.xml
<emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp>
<Join><id>101</id><city>london</city><date>06/06/14 2011</date></join>
<Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join>
<Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies