Additonal Line in Text File


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Additonal Line in Text File
# 8  
Old 12-13-2011
It brings back 11 which I assume is the line count if you don't count the header row.

This is brilliant and if I could just ask you to explain how the command is put together so I can use it for other files which have a slight different validation.

---------- Post updated at 04:50 PM ---------- Previous update was at 04:47 PM ----------

Looking at the original file it showed me that the error was on line 243 which when I checked was exactly right!
# 9  
Old 12-13-2011
Just for interest. Open logic Shell version. Should find most situations where records are out of place.

Code:
#!/bin/ksh
recno=0         # Record number
recid=""        # Record ID 1/2/3/4
prev_recid="0"  # Previous record ID
#
cat filename.txt | while read line
do
        recno=$(( $recno + 1 ))
        recid=$(echo "${line}"|cut -c1-1)
        case "${recid}" in
                "1")
                        prev_recid="${recid}"
                        continue
                        ;;
                "2")
                        if [ "${prev_recid}" = "1" ]
                        then
                                prev_recid="${recid}"
                                continue
                        fi
                        if [ "${prev_recid}" = "3" ]
                        then
                                prev_recid="${recid}"
                                continue
                        fi
                        # Error. Do not use for subsequent compares
                        echo "Out of sequence : record ${recno}"
                        echo "${line}"
                        continue
                        ;;
                "3")
                        if [ "${prev_recid}" = "2" ]
                        then
                                prev_recid="${recid}"
                                continue
                        fi
                        # Error. Do not use for subsequent compares
                        echo "Out of sequence : record ${recno}"
                        echo "${line}"
                        continue
                        ;;
                "4")
                        prev_recid="${recid}"
                        continue
                        ;;
                *)
                        # Error. Do not use for subsequent compares
                        echo "Unknown record type : record ${recno}"
                        echo "${line}"
                        continue
                        ;;
        esac
done

./script.sh
Out of sequence : record 12
3PLAYER25 000011000003000


Last edited by methyl; 12-13-2011 at 01:32 PM.. Reason: paste error
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script UNIX to read text file line by line

i have a text file as belows, it includes 2 columns, 1st is the column name, 2nd is the file_name data_file.txt column_name file_name col1 file1 col2 file2 col3 file1 col4 file1 col5 file2 now, i would like to... (4 Replies)
Discussion started by: tester111
4 Replies

2. Shell Programming and Scripting

How to read a text file line by line and insert into a database table?

I have a test file that I want to read and insert only certain lines into the the table based on a filter. 1. Rread the log file 12 Hours back Getdate() -12 Hours 2. Extract the following information on for lines that say "DUMP is complete" A. Date B. Database Name C.... (2 Replies)
Discussion started by: JolietJake
2 Replies

3. Shell Programming and Scripting

Reading text file, comparing a value in a line, and placing only part of the line in a variable?

I need some help. I would like to read in a text file. Take a variable such as ROW-D-01, compare it to what's in one line in the text file such as PROD/VM/ROW-D-01 and only input PROD/VM into a variable without the /ROW-D-01. Is this possible? any help is appreciated. (2 Replies)
Discussion started by: xChristopher
2 Replies

4. UNIX for Dummies Questions & Answers

Extracting lines from a text file based on another text file with line numbers

Hi, I am trying to extract lines from a text file given a text file containing line numbers to be extracted from the first file. How do I go about doing this? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

5. Shell Programming and Scripting

PERL or SHELL Scrript to search in Directories by taking line by line from a text file

Unix box server version *********** >uname -r B.11.00 >echo $SHELL /usr/bin/ksh --> in this server, I have the path like /IMbuild/dev/im0serv1 ---> in that directory I have the folders startup(.jsp files nearly 100 jsp's ) and scripts(contains .js files nearly 100 files) ... (9 Replies)
Discussion started by: pasam
9 Replies

6. Shell Programming and Scripting

Shell script to read a text file line by line & process it...

Hi , I am trying to write an shell, which reads a text file (from a location) having a list of numbers of strictly 5 digits only ex: 33144 Now my script will check : 1) that each entry is only 5 digits & numeric only, no alphabets, & its not empty. 2)then it executes a shell script called... (8 Replies)
Discussion started by: new_to_shell
8 Replies

7. Shell Programming and Scripting

get the fifth line of a text file into a shell script and trim the line to extract a WORD

FOLKS , i have a text file that is generated automatically of an another korn shell script, i want to bring in the fifth line of the text file in to my korn shell script and look for a particular word in the line . Can you all share some thoughts on this one. thanks... Venu (3 Replies)
Discussion started by: venu
3 Replies

8. Shell Programming and Scripting

Search text from a file and print text and one previous line too

Hi, Please let me know how to find text and print text and its previous line. Please don't get irritated few days back I asked text and next line. I am using HP-UX 11.11 Thanks for your help. (6 Replies)
Discussion started by: kamranjalal
6 Replies

9. Shell Programming and Scripting

How to insert some constant text at beginig of each line within a text file.

Dear Folks :), I am new to UNIX scripting and I do not know how can I insert some text in the first column of a UNIX text file at command promtp. I can do this in vi editor by using this command :g/^/s//BBB_ e,g I have a file named as Test.dat and it containins below text: michal... (4 Replies)
Discussion started by: Muhammad Afzal
4 Replies

10. Shell Programming and Scripting

Adding specific text and spaces to each line in a text file

Hi, I wanted to add specific text to each row in a text file containing three rows. Example: 0 8 7 6 5 5 7 8 9 0 7 9 7 8 9 0 1 2 And I want to add a 21 at the beginning of the first row, and blank spaces at the beginning of the second two rows. To get this: 21 0 8 7 6 5 5 7 8... (4 Replies)
Discussion started by: hertingm
4 Replies
Login or Register to Ask a Question