Please help develop script for below requirement
Here is the List of Validation. We need to send mail for each validation failure. First Char is Type of Record Say Header/Detail/Trailer
1. The first record in the file must be the header record.
2. The file can have at most one header record.
3. The date on the header should match the date received (Note: If a file in error is retransmitted the next day, this may not be so. The purpose of this edit is to make sure that we are not picking up a duplicate of an earlier file.)
4. The last record in the file must be a trailer record. (This means that the file can have at most one trailer record, and that there should be no header or detail records following the trailer record.)
5. Every record between the header record and the trailer record must be a detail record.
6. The trailer count should match the calculated number of detail records in the file.
1. Is the file name same i ment for the one validation has to be done?
it will be <filename><receivedate>.txt format.
2. The date feild in the first line can be validated with system date ?
Yes
3. The first line i ment header is always with time stamp and footer is always with no. of records?
Yes...Header will be date & time stamp and footer will be with total records
4. Will ther be a common patern matcher for the record... in teh below case like "DARMAR"
D stands for detail...after that records will be changed.
First Char is Type of Record Say Header/Detail/Trailer
Last records contains number of detail records i.e. 11 it can be 105 or 1230 also but position will be same always.
First record has date which is 20090115011817 in yyyymmddhhmmss format position in header will be same always
The script does the following:
1. Checks if the files header corresponds to the current date.
else the output is "record not of todays date"
2. Checks if the file has more than one header it wil fail with error "record is corrept"
3. Checks the date in the header with the system date if ther is a missmatch it wil fail with "record not of todays date"
4. If there are more than one trailer record it wil give output "record is corrept"
5. Every record between the header and trailer is considered as a Detail record. I was not able to check the consistancy of that as u did not give me any standard on that.
6. The trailer count will match the records found if sucessful it wil give message "record is perfect" else fails with the message its corrept.
I have not considered output to be redirected to a file.
Example:
record is perfect
----
2nd case :
---
record is corrupt
---
I guess its clear now...
Regards,
Bips.
Last edited by Franklin52; 02-24-2009 at 03:20 PM..
Reason: adding code tags
I have shell program as below
#!/bin/sh
echo ======= LogManageri start ==========
#This directory is getting the raw data from remote server
Raw_data=/opt/ftplogs
# This directory is ready for process the data
Processing_dir=/opt/processing_dir
# This directory is prcoessed files and... (4 Replies)
I need to write a C-Shell script with these properties: It should accept two arguments on the command line. The first argument is the name of a file which contains a list of names, and the second argument is the name of a directory. For each file in the directory, the script should print the... (1 Reply)
I have a shell script that takes 2 arguments. I will have to execute this script multiple times with different values for the arguments.
for example,
./shscript env1 value1
./shscript env1 value2
./shscript env2 value3
./shscript env3 value4
./shscript env1 value5
./shscript env3... (24 Replies)
Hi All,
I'm writing a script to read a file line by line and then perform awk function on it. I am getting an error . My file has one name in it "James". I'm expecting my o/p to be youareJamesbond
James
./users.sh: line 7: =: command not found
#script to read file line by line
#adding... (5 Replies)
Hi!
i need a script that can read a property file.
i.e., A script to read a "property" from property file.
Read the property value and
based on value of property, decide whether to start the some dataload activity or not.
Its urngent. Can anyone help me out???:( (7 Replies)
How to validate a date and optionly a time in shell scripting when i get the date and time as pararmeters that sent out with the call of the file? (in my case sh union.sh `first parameter ,second parameter...` (4 Replies)
For reading a file through shell script I am using yhe code :
while read line
do
echo $line
done<data.txt
It reads all the line of that file data.txt.
Content of data.txt looks like:
code=y
sql=y
total no of sql files=4
a.sql
b.sql
c.sql
d.sql
cpp=n
c=y
total no of c files=1 (4 Replies)
There is one Text file data.txt.
Data within this file looks like:
a.sql
b.sql
c.sql
d.sql
.....
.....
want to write a shell script which will access these values within a loop, access one value at a time and store into a variable. can anyone plz help me. (2 Replies)
Hi
I am new to this forum.I need a help in the following:
We receve pipe delimited file with
transaction ID,tran_date,Quest_cd,Ans_cd,ans_value.
Same transaction ID can be repeated with different quest_cd and ans_cd.
Basically I need to check if a perticular pair of quest_cd and ans_cd... (1 Reply)
Hi
How can i dynamically read files names from a list file and execute them from a single shell script.
Please help its urgent
Thanks in Advance (4 Replies)