07-19-2007
Need help in file validation by shell script
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 (say Q1234,A1234) is present under a transaction ,then another pair of quest_cd and ans_cd (say Q5678,A5678) should also be present.
Otherwise I need to remove the isolated row from input file and write to a bad file which should have the complete row in defect and with a comment that Q1234A1234 present but Q5678A5678 not present Or vice versa.
The balance good records sholud be written to a good file.
I hope I am clear in my explanation.As this is VERY urgent I appreciate immediate help
Regards
SRK
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Please help develop script for below requirement
-------Sample file-------------------------------
HSVSHOSTRECON 20090115011817BP
DARMAR60064966247003504720000000000000000000066626000000000000133000003D003463001332 ... (14 Replies)
Discussion started by: niraj_bhatt
14 Replies
2. Shell Programming and Scripting
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)
Discussion started by: tal
4 Replies
3. Shell Programming and Scripting
Hi,
Can anyone provide me the code snippet for EMail Address Validation.
User is going to enter the email address in form window. I need to validate the format is correct.
Thanks in Advance
BS (3 Replies)
Discussion started by: balajiora
3 Replies
4. Shell Programming and Scripting
PICKUPDIR=/home/ready/
DROPDIR=/home/downloaded/
TODAY=$(date '+%d%m%y')
LOGFILE=xyz-$TODAY.log
###########
#FUNCTIONS#
###########
#function to perform file transfer to servercopy folder
opalO ()
{
cd $PICKUPDIR
for fileName in `ls -1 TES_ONE*`
do
cp $fileName $DROPDIR
done
} >>... (4 Replies)
Discussion started by: ravigupta2u
4 Replies
5. Shell Programming and Scripting
Hi All,
I have a shell script in Linux and it will be invoked by 2 methods,
1) An automated background process .
2) Logining into the box and directly executing the script.
I need to put a validation in my shell script such that it will be executed successfully on when an... (11 Replies)
Discussion started by: vininx
11 Replies
6. Shell Programming and Scripting
Hi All,
I am a newbie...I would like to have a function which ll check if a file contains valid strings before "=" operator. Just to give you my requirement:
assume my file has content:
hello= gsdgsd sfdsg sgdsg sgdgdg
world= gggg hhhh iiiii
xxxx= pppp ppppp pppp
my... (1 Reply)
Discussion started by: rtagarra
1 Replies
7. Shell Programming and Scripting
Hi All,
I am completely new to Unix Shell Scripting.
I m validating(Basic File Validation) an .HHT file in TIBCO.
After that i need to do Data Validation through UNIX Shell scripting.
Rules in DataValidation:
1.) Need to Check Every field wheather it is a Char or Number?(Fields are... (1 Reply)
Discussion started by: Chaitanya K
1 Replies
8. UNIX for Dummies Questions & Answers
Hi Guys,
I am trying to find a way within a bash script to check a file that exists in the same directory to ensure every line starts with 44 and is 12 digits long. If it doesn't then print some sort of text advising of the error and stop the script from going any further. If all lines... (1 Reply)
Discussion started by: mutley2202
1 Replies
9. UNIX for Dummies Questions & Answers
I need help with one of my shell script. The script is working fine but i need to add two condition -
i need to get rid of all the below ftp messages and need to have only ftp completed or failed message.
example when i run the script i get below lines -
Connected to xxxx
220 (vsFTPd... (1 Reply)
Discussion started by: chandraprakash
1 Replies
10. Shell Programming and Scripting
hello every one
I wrote the script to validate all the urls from my server . sourcing text file which contains the list of urls and trying to check every url and based on response printing url is up or not. the issue when i use the below code with url is printing url exist and and in loop it's... (3 Replies)
Discussion started by: markjohn1
3 Replies
LEARN ABOUT DEBIAN
af_commit
af_transact(3) Attribute Filesystem (AtFS) af_transact(3)
NAME
af_transaction, af_commit, af_abort - a simple transaction mechanism for AtFS
SYNOPSIS
#include <atfs.h>
int af_transaction (void)
int af_commit (void)
int af_abort (void)
DESCRIPTION
These functions implement a simple transaction mechanism for AtFS. A transaction starts with calling af_transaction. All changes to exist-
ing ASOs performed hereafter have no immediate permanent effect. They rather get into effect, when the transaction is ended. Calling
af_commit ends the transactions and causes all changes to be saved to disk. af_abort aborts the transaction without saving the changes.
These will then be discarded.
Only modification of the state of existing source ASOs will be deferred. Creation or deletion of ASOs have immediate effect, regardless if
a transaction is in effect or not. Additionally, all operations on derived ASOs (all operations on the derived object cache) are not
affected by the transaction.
All archive files that are to be changed when the transaction is finished are locked until the end of the transaction. The lock prevents
all other applications to perform any modifications on the archive file. You should make sure, that ending a transaction should never be
dependent on the successful termination of another application (deadlock danger).
DIAGNOSTICS
Upon error, -1 is returned and af_errno is set to the corresponding error number.
BUGS
Changes to the contents of busy versions have immediate effect.
AtFS-1.71 Fri Jun 25 14:33:21 1993 af_transact(3)