Doing Checks on a file Post: 302224049

Sponsored Content

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

08-12-2008

Registered User

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

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

slags2.f

slags2.f(3)							      LAPACK							       slags2.f(3)

NAME

       slags2.f -

SYNOPSIS

   Functions/Subroutines
       subroutine slags2 (UPPER, A1, A2, A3, B1, B2, B3, CSU, SNU, CSV, SNV, CSQ, SNQ)
	   SLAGS2

Function/Subroutine Documentation
   subroutine slags2 (logicalUPPER, realA1, realA2, realA3, realB1, realB2, realB3, realCSU, realSNU, realCSV, realSNV, realCSQ, realSNQ)
       SLAGS2

       Purpose:

	    SLAGS2 computes 2-by-2 orthogonal matrices U, V and Q, such
	    that if ( UPPER ) then

		      U**T *A*Q = U**T *( A1 A2 )*Q = ( x  0  )
					( 0  A3 )     ( x  x  )
	    and
		      V**T*B*Q = V**T *( B1 B2 )*Q = ( x  0  )
				       ( 0  B3 )     ( x  x  )

	    or if ( .NOT.UPPER ) then

		      U**T *A*Q = U**T *( A1 0	)*Q = ( x  x  )
					( A2 A3 )     ( 0  x  )
	    and
		      V**T*B*Q = V**T*( B1 0  )*Q = ( x  x  )
				      ( B2 B3 )     ( 0  x  )

	    The rows of the transformed A and B are parallel, where

	      U = (  CSU  SNU ), V = (	CSV SNV ), Q = (  CSQ	SNQ )
		  ( -SNU  CSU )      ( -SNV CSV )      ( -SNQ	CSQ )

	    Z**T denotes the transpose of Z.

       Parameters:
	   UPPER

		     UPPER is LOGICAL
		     = .TRUE.: the input matrices A and B are upper triangular.
		     = .FALSE.: the input matrices A and B are lower triangular.

	   A1

		     A1 is REAL

	   A2

		     A2 is REAL

	   A3

		     A3 is REAL
		     On entry, A1, A2 and A3 are elements of the input 2-by-2
		     upper (lower) triangular matrix A.

	   B1

		     B1 is REAL

	   B2

		     B2 is REAL

	   B3

		     B3 is REAL
		     On entry, B1, B2 and B3 are elements of the input 2-by-2
		     upper (lower) triangular matrix B.

	   CSU

		     CSU is REAL

	   SNU

		     SNU is REAL
		     The desired orthogonal matrix U.

	   CSV

		     CSV is REAL

	   SNV

		     SNV is REAL
		     The desired orthogonal matrix V.

	   CSQ

		     CSQ is REAL

	   SNQ

		     SNQ is REAL
		     The desired orthogonal matrix Q.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   November 2011

       Definition at line 152 of file slags2.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.1							  Sun May 26 2013						       slags2.f(3)