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 CENTOS

xmdirectiontostringdirection

XmDirectionToStringDirection(library call)								XmDirectionToStringDirection(library call)

NAME

       XmDirectionToStringDirection -- A function that converts an XmDirection value to an XmStringDirection value

SYNOPSIS

       #include <Xm/Xm.h>
       XmStringDirection XmDirectionToStringDirection (dir)
	       XmDirection     dir;
       (void)

DESCRIPTION

       XmDirectionToStringDirection  converts  the specified XmDirection direction value to its equivalent XmStringDirection value.  Basically, if
       the XmDirection value has a horizontal direction specification, that horizontal element is used; otherwise, the XmStringDirection value	is
       interpreted as XmSTRING_DIRECTION_L_TO_R.  This function provides backward compatibility with the XmStringDirection data type.

       Note  that the Motif toolkit also contains an XmStringDirectionToDirection routine to convert an XmStringDirection value to its XmDirection
       equivalent.

       dir	 Specifies the XmDirection value to be converted.

RETURN

       Returns the following XmStringDirection values:

       XmSTRING_DIRECTION_R_TO_L
		 If the dir argument has a right to left horizontal direction value in it, for example XmRIGHT_TO_LEFT_TOP_TO_BOTTOM.

       XmSTRING_DIRECTION_L_TO_R
		 If the dir argument has a left to right horizontal direction in it, for example XmLEFT_TO_RIGHT_TOP_TO_BOTTOM, or if the horizon-
		 tal direction value in the dir argument is ambiguous, such as in the XmTOP_TO_BOTTOM value.

       XmSTRING_DIRECTION_DEFAULT
		 If there was no horizontal direction specified.

RELATED INFORMATION

       XmDirection(3),	XmDirectionMatch(3),  XmDirectionMatchPartial(3),  XmDirectionToStringDirection(3), XmString(3), XmStringDirection(3), and
       XmStringDirectionToDirection(3),

													XmDirectionToStringDirection(library call)