Validating the file Post: 302874209

Sponsored Content

Top Forums Shell Programming and Scripting Validating the file Post 302874209 by karumudi7 on Thursday 14th of November 2013 12:25:12 PM

11-14-2013

Registered User

Validating the file

Hello All,

I have the following file. The first column is Type. Always the file will have one H and one T type in between all D type reocrds.
Need todo some validations.

Code:

 
H|ABCD
D|TAB N0003107809CD2013-11-14|RYAN|FRY|7 DR|RICHMOND HILL|GA|32431|X|C95|000009999|000000001|TAB||C0001
D|TAB N0004251713CD2013-11-14|JOHN|Mc|3 DR|MAYS LANDING|NJ|33058|Y|C95|000009999|000000001|TAB||C0001
D|TAC N0002375248CD2013-11-14|MICHAEL|Clarid|3 RD|MOUNT SINAI|NY|76611|F|C95|000009999|000000001|TAC||C0001
D|TAC N0006321198CD2013-11-14|John|MILLER|44 RD|BASTROP|LA|65220|G|C95|000009999|000000001|TAC||C0001
D|TAC N0009983305CD2013-11-14|PAUL|Jame|40 DR NW|GRAND RAPIDS|M|94534|X|C95|000009999|000000001|TAC||C0001
T|C95|000009999|000000001|5

Validations:
1. Number of "D" type records should be same as count mentioned in 5th field of "T" type record.
2. 10, 11 & 12 fileds should be same in all "D" type records and match with "T" type record of 2, 3 and 4 fileds respectively.

Thanks in Advance!

karumudi7

View Public Profile for karumudi7

Visit karumudi7's homepage!

Find all posts by karumudi7

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Validating inputs from a file

Hi, I have a file called inputs. Now that file has the values like this: 1 2 3 Now In my script called 'get.sh' I do this : exec < inputs read a b c d Now I know that there will not be any value in d. How can I check it. I need the exact condition for checking whether the variable has...

2. Shell Programming and Scripting

validating a file or directory

Hi there, im writing a script and trying the get the 2nd parameter and check it if its valid file or valid directory, Example: ./test -a quiz1 i need to check quiz1 ($2) if it matches any name of a file or directory. Thanks

3. Shell Programming and Scripting

validating a file based on conditions

i have a file in unix in which the records are like this aaa 123 233 aaa 234 222 aaa 242 222 bbb 122 111 bbb 122 123 ccc 124 222 In the output i want only the below records aaa ccc The validation logic is 1st column and 2nd column need to be considered if both columns values are...

4. Shell Programming and Scripting

validating a input file for numeric and character

i have a input file like this 001|rahim|bajaj|20090102 while reading the file i need to check whether the first column is a number second column is a name is there any methodology to check for the same thanks in advance

5. Shell Programming and Scripting

Shell script for validating fields in a file

Hi, I have not used Unix in a very long time and I am very rusty. I would appreciate any help I can get from the more experienced and experts in Shell script. I am reading one file at a time from a folder. The file is a flat file with no delimeters or carriage return. Col1 through col6 is...

6. UNIX for Dummies Questions & Answers

Validating a file

Pardon my ignorance but I am lost on how to do this I have a file called "Sample.txt", it is pipe delimited, it should have 13 fields. But some of the records do not, I would like to set up a shell script where I can pass in a parameter "Sample.txt" and it would split the file into records...

7. Shell Programming and Scripting

Validating XML file using XSD in UNIX

Hi, I have a xml file and a xsd file(xml schema file). Here using unix script i wanted to validate the xml file by referring to xsd file. The validation is in terms of Datatype,Field length and null values. If the data present in the xml file is not matching in terms of datatype,field length...

8. Shell Programming and Scripting

Csv file parsing and validating

Hi, I have basic knowledge on unix shell scripting(not an expert). My requirement is reading the csv file using the schema defined in the configuration file and if the condition is not mached then move the unmatched record to a error file and matched good records into other file. In brief: ...

9. Shell Programming and Scripting

Validating a file in ksh

Ladies and Gents, I need to be able to verify the file and validate the file format. Is there a way to verify this using ksh? Please forgive me, I'm very new to UNIX scripting. 12345_dbname_1_sqlname.sql 12345 - change number dbname - database name 1 - sequence sqlname - sql...

LEARN ABOUT SUSE

tac

TAC(1)								   User Commands							    TAC(1)

NAME

       tac - concatenate and print files in reverse

SYNOPSIS

       tac [OPTION]... [FILE]...

DESCRIPTION

       Write each FILE to standard output, last line first.  With no FILE, or when FILE is -, read standard input.

       Mandatory arguments to long options are mandatory for short options too.

       -b, --before
	      attach the separator before instead of after

       -r, --regex
	      interpret the separator as a regular expression

       -s, --separator=STRING
	      use STRING as the separator instead of newline

       --help display this help and exit

       --version
	      output version information and exit

AUTHOR

       Written by Jay Lepreau and David MacKenzie.

REPORTING BUGS

       Report tac bugs to bug-coreutils@gnu.org
       GNU coreutils home page: <http://www.gnu.org/software/coreutils/>
       General help using GNU software: <http://www.gnu.org/gethelp/>

COPYRIGHT

       Copyright (C) 2009 Free Software Foundation, Inc.  License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
       This is free software: you are free to change and redistribute it.  There is NO WARRANTY, to the extent permitted by law.

SEE ALSO

       The  full  documentation  for tac is maintained as a Texinfo manual.  If the info and tac programs are properly installed at your site, the
       command

	      info coreutils 'tac invocation'

       should give you access to the complete manual.

GNU coreutils 7.1						     July 2010								    TAC(1)