File Validation

Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers File Validation
# 1  
Old 08-19-2009
File Validation

Hi All,

I am new to UNIX scripting.
I need to validate a file. I need to check whether the file has a header , detail records and footer.

If all the file is good I need to create a status file with the status 'Y' else 'N'.

I have pasted the an example of the file below:

H:2009-07-24 10:42:07
2614| |21|||| |7976 Jytc Nl |Henderson NV |89011||1| |
26698| |50|||| |6624 Xhxdxll Ays |Arvada CO |80005||| |
67527| |11|N||| |73809 Jydlfxvby Nl |Sepulveda CA |91343||| |
68660| |777|||| |77822 HYVJUDL YHX |SYLMAR CA |91342||| |
69035| |15|||| |477 N Rxvldx Nl |San Pedro CA |90731||| |
74680| |62|||| |1516 V 62lf Jt |Scottsdale AZ |85257||| |
75661| |70|||| |217 Kpdd Uye Rl |Virginia Beach VA |23454||| |
77302| |72|||| |611 Tyvrx Gd |Newport News VA |23601||| |
77990| |74|||| |9291 CrZpbdx Gd |Richmond VA |23224||| |
80003| |77|||| |1493 Kdxvlauug Rbd |Richmond VA |23237||D| |

Please Advice.


Last edited by vgersh99; 08-19-2009 at 02:34 PM.. Reason: code tags, PLEASE!
# 2  
Old 08-19-2009
To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums
# 3  
Old 08-19-2009
Hi Vgersh99,

Sorry for that.

Thanks ,
# 4  
Old 08-19-2009
Hi Kumar,


$cat >
FILECOUNT=`cat ${FILENAME} | wc -l`
COUNT=`expr ${FILECOUNT} - 2`
if [ `head -1 ${FILENAME} | cut -c 1` = H ]
        if [ `tail -1 ${FILENAME} | cut -c 1` = T ] && [ ${COUNT} -eq `tail -1 ${FILENAME} | cut -d ":" -f2`  ]
                echo "Valid file"
                echo "Invalid file(T)"
        echo "Invalid file(H)"

$./ testfile

Last edited by; 08-19-2009 at 06:30 PM..
# 5  
Old 08-20-2009
Hi Scripter,

Thanks a lot for your kindly help.

Thanks & Regards,
# 6  
Old 08-20-2009
Originally Posted by kumar66
Hi Scripter,

Thanks a lot for your kindly help.

Thanks & Regards,

You are most welcome
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Validation before moving the File

Hi, Before moving the files from source directory to target directory I need to check if the files have these strings 'Error', 'Not Valid' ,' YTF-' or if the file is a zero byte file, if the file contains these strings or if it is a zero byte file i should log a entry in the log file and fail... (5 Replies)
Discussion started by: gaur.deepti
5 Replies

2. Shell Programming and Scripting

File validation

Hi there, As a part of file validation, I needed to check for delimiter count in the file. My aim is to find, how many records have failed to have predefined numbers of delimiters in the file. My code looks like below i=`awk -F '|' 'NF != 2 {print NR, $0} ' ${pinb_fldr}/${pfile}DAT |... (3 Replies)
Discussion started by: anandapani
3 Replies

3. Shell Programming and Scripting

Unicode file validation

I don't want HTML_CONTENT,RICH_CONTENT,TEXT_CONTENT columns data in the file and reset of data we need to extract. Find the attached file. Need to extract date in between DI_UX_ROW_END tag. Can help me using unix command using AWK. Thanks, (2 Replies)
Discussion started by: bmk
2 Replies

4. Shell Programming and Scripting

XML file validation

Hi, i am new to unix script. i have two xml files. one is orderinfo.xml and another one is xsd file(EmailMessage.xml). we need to compare the both file for poper nodes exists are not. for example: <xsd:element name="EmailMessage"> tag in the EmailMessage.xml file(xsd sheet),this tag... (2 Replies)
Discussion started by: bmk
2 Replies

5. Shell Programming and Scripting

File validation

Hello, File contains 1,3 and 5 are required columns. it's working use this command. awk -F\| '$1 && $3 && $5' test1.txt > test2.txt How can use this unix programming.while using runnign this scirpt,it's raising the error. awk: ^ syntax error #!/usr/bin/ksh `awk -F\| '$1 &&... (3 Replies)
Discussion started by: bammidi
3 Replies

6. Shell Programming and Scripting

Input validation of file

Hi, I'm trying to do input validation for a file. If the user fails to enter a file name, the script should prompt for the file name or exit. I'm using this script to integrate with a bigger script which does ftp of the files which are "read". #!/bin/ksh echo "enter a file name" if then... (16 Replies)
Discussion started by: sam_bd
16 Replies

7. Shell Programming and Scripting

File Name Validation

Hi All, I am trying to validate the file name against the naming convention mentioned in configuration file. In the configuration file, the file name convention is mentioned as: Myfile_SQ<NN>_<NN>_YYYYMMDD_HHMMSS.xml The actual file received is Myfile_SQ10_30_20110423_073002.xml How do... (1 Reply)
Discussion started by: angshuman
1 Replies

8. UNIX for Dummies Questions & Answers

file name with timestamp validation

Hi , I am trying to write a shell script which will validate all .csv file names in a directory , my file name format is as below. CDR_SCAN_Report_YYYYMMDDHHMI.csv 1. I need to validate the name should start with CDR_SCAN_Report. 2. And the time stamp part is a valid time stamp,if it is... (1 Reply)
Discussion started by: shruthidwh
1 Replies

9. Shell Programming and Scripting

File name and format validation

Hi Gurus, I used unix long time back. I need help for writing a unix script which can be automated and execute every day on specific time. 1.) This is the actual functional requirement. Informatica should reject incoming files that have invalid filenames or file formats 2.) My File... (6 Replies)
Discussion started by: vsmeruga
6 Replies

10. Shell Programming and Scripting

validation :file <filename>

My user is ftp a CSV file from window. There is possiblity to doing FTP through different mode. This file is then picked by another program, but I want to make sure the FTP file would be always ascii format, bu releasing a commaon File <file name> Can any one provide input , abut how to put a... (2 Replies)
Discussion started by: u263066
2 Replies
Login or Register to Ask a Question