Doing Checks on a file Post: 302224067

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Doing Checks on a file Post 302224067 by SAMZ on Tuesday 12th of August 2008 07:16:05 AM

08-12-2008

Registered User

OK the above works a treat thanks. This leads me to mu next and final issue but will need to explain a little first.

Once the first file (FIRST.CSV) has been generated with codes and ammount column adjustments have to be made to certain accounts. This is done my the use of the second file (SECOND.CSV). If the codes in the first file and second file agree then the amount in the second file is added/substracted to the first file. If the code in the second file does not agree to any code in the first file then the code and amount are appended to bottom:

e.g
FIRST.CSV
A001ZZ ,, 400
A002ZZ ,, 300

SECOND.CSV
A001ZZ ,, -200
A002ZZ ,, 100
A003ZZ ,, 10

THIRD.CSV
A001ZZ ,, 200
A002ZZ ,, 400
A003ZZ ,, 10

The above isd done by using the code:
join -t, -a1 -a2 ${SECOND.CSV} ${FIRST.CSV} > ${THIRD.CSV}
nawk -F, '{ printf $1",," "%011.2f\n",$3+$5 }' ${THIRD.CSV} > ${FINAL.CSV}

The problem with the above is that if for example A001ZZ needs two adjustmentss at the same time meaning the SECOND.CSV file will look like:
SECOND.CSV
A001ZZ ,, -200
A001ZZ ,, 300
A002ZZ ,, 100
A003ZZ ,, 10

my code will only pick up the first instance of A001ZZ and adjust as required and the second occurence of A001ZZ will then be treated as a new code and be appended to the bottom of FINAL.CSV.

Could anyone please assist as to how I can resolve this issue?

SAMZ

View Public Profile for SAMZ

Find all posts by SAMZ

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

perform some checks on file using perl

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 ...

2. UNIX for Dummies Questions & Answers

health checks

Hello Anyone please help me with a health check script on HP-UX.

3. Shell Programming and Scripting

to perform checks line by line on a file

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 ...

4. UNIX for Advanced & Expert Users

speed test +20,000 file existance checks too slow

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...

5. AIX

Pre-checks

AIX Guys!!! What pre-checks would you do on a 5.3 server before TL/SP/APAR installation? Bala

6. UNIX for Dummies Questions & Answers

Daily File Checks

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...

7. Shell Programming and Scripting

Daily Checks

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:...

8. Shell Programming and Scripting

Script to do the following checks

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...

9. Shell Programming and Scripting

Extract timestamp from first record in xml file and it checks if not it will replace first record

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...

LEARN ABOUT DEBIAN

sarg-reports

SARG-REPORTS(1) 					      General Commands Manual						   SARG-REPORTS(1)

NAME

       sarg-reports - Daily/Weekly/Monthly squid usage reports creation tool

SYNOPSIS

       sarg-reports [OPTIONS]

DESCRIPTION

       This manual page documents briefly the sarg-reports command.

       sarg-reports is a script written to automate the SARG (a powerful squid log analyzer) reports and log management.  Sarg it self, provide to
       end user a generic interface to create reports based on squid access log (begin of log to current date).  sarg-reports is useful because it
       allow you to easly create and manage Daily, Weekly and Monthly reports.

OPTIONS

       A summary of options is included below.

       manual
	      Create Manual report

       today  Create Today report

       daily  Create Daily report

       weekly Create Weely report

       monthly
	      Create Monthly report

CRONTAB

       If  you	want  the  reports can be generated automatically insert the following lines (the today report creation time depend mostly of your
       sarg server load average, tune it):

       PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
       00 08-18/1 * * * sarg-reports today
       00 00	  * * * sarg-reports daily
       00 01	  * * 1 sarg-reports weekly
       30 02	  1 * * sarg-reports monthly

       REMEMBER: if you use logrotate, configure it to rotate the logs within MONTHLY basis, AFTER sarg-reports created the monthly html report.

VARIABLES

       Check before using the sarg-reports that the following variables are set to file /etc/sarg/sarg.conf

       SARG
	      The sarg executable location

       CONFIG
	      The sarg main configuration file location

       HTMLOUT
	      Location where will be saved the reports

       PAGETITLE
	      The title of main index page

       LOGOIMG
	      Image logo to view in main index page

       LOGOLINK
	      HTTP web page link of logo

       DAILY
	      Word 'daily' translation, translate it to your language

       WEEKLY
	      Word 'weekly' translation, translate it to your language

       MONTHLY
	      Word 'monthly' translation, translate it to your language

       EXCLUDELOG1
	      Exclude text from cron emails (normally, sarg, during cron activity, if it don't find any valid records,

       EXCLUDELOG2
	      It will output an error message (usually on 'today' reports). I don't want to be warned by email about this, so, i wrote the  'text'
	      that will be never logged. This is useful to receive email of real problems only.

AUTHOR

       sarg-reports was written by Ugo Viti <ugo.viti@initzero.it>

       This manual page was written by Juan Angulo Moreno <juan@apuntale.com>, for the Debian project (but may be used by others).

								   may 17, 2008 						   SARG-REPORTS(1)