Need help in file validation by shell script

srichakra · #1 (**permalink**) 07-19-2007

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

matrixmadhan · #2 (**permalink**) 07-19-2007

Please read the rules of the forum

Please don't cross post.

Here is the thread for which I had replied.

http://www.unix.com/unix-for-dummies...ll-script.html

Moderators please

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Validation of character separated lines in a file	kolesunil	UNIX for Dummies Questions & Answers	3	05-27-2008 07:48 AM
UNIX script Validation	matchey	Shell Programming and Scripting	1	05-07-2008 12:56 PM
CSV file parsing and validation	dolo21taf	Shell Programming and Scripting	1	03-06-2008 06:15 AM
validation :file <filename>	u263066	Shell Programming and Scripting	2	09-26-2006 04:59 AM
Reading file names from a file and executing the relative file from shell script	anushilrai	Shell Programming and Scripting	4	03-10-2006 05:25 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by