UNIX for Dummies Questions & Answers

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.

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