I re-post my question to seek your help and critique. I was required to verify a very large and tab-delimited file, named 'MyFile'.

1. The each line in 'MyFile' has 7 columns, and that the values in the 5th column are integers. I need to use shell functions (and standard LINUX/UNIX filters) to verify that these conditions were satisfied in 'MyFile'. My code looks like this:

Code:

#! /bin/sh
#  The nested function to verify columns in file and data type in 5th column.
echo “ Check the columns in the file”
func_x () {
awk ‘ {print $0} ‘ MyFile’
}
echo “ Check the data type in 5th column”
func_int () {
awk – F “|” ‘ $5 ~ “^ [0 – 9] [0 – 9] *$” {print $5}’ MyFile.
}

2. 2. In the same file, the each value in 1st column is unique. How to verify this with UNIX function? My code is:

Code:

#!/bin/ksh
# Verify the unique value in the 1st column
func_u () {
cat MyFile | awk  ‘ {print $1} ‘ | sort | uniq  | wc –l
}

3. Write a shell function that counts the number of occurrences of the word “SpecWord” in the file 'MyFile'. My code is:

Code:

#! /bin/sh
# counts the number of SpecWord in the file
Func_n () {
grep –io “SpecWord” MyFile | wc –l
}

Thanks for your help in advance.