Visit Our UNIX and Linux User Community


while read line do..


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting while read line do..
# 1  
Old 11-03-2009
while read line do..

I have a base file FILE1 with the following data

FILE1.dat
21111111110001343 000001004OLF 029100020091112
21111111110000060 000001004ODL-CH001000020091112
22222222220000780 000001013OLF 006500020091112
23333333330001695 000001039OLF 030600020091112
23333333330000111 000001039ODL-SP002000020091112
23333333330000060 000001039ODL-CH001000020091112
24444444440001416 000001045OLF 011800020091112
......
......
..etc
i want to write a program in .KSH that the FILE2.dat should have only 4 records like below appending two new columns spouse_col & child_col at the end of each line remember this should be in while read line do loop
ODL-Ch = child_col ,
ODL-Sp = spouse_col

FILE2.DAT
spouse_col child_col
21111111110001343 000001004OLF 029100020091112 0000000 0000060
22222222220000780 000001013OLF 006500020091112 0000000 0000000
23333333330001695 000001039OLF 030600020091112 0000111 0000060
24444444440001416 000001045OLF 011800020091112 0000000 0000000

write now i am doing like this but

Code:
while read line 
 do
rec_no=`echo $line|cut -c2-10`
ben_type=`echo $line|cut -c28-33`
amount=`echo $line|cut -c11-18`
if [[ $rec_cnt -eq 1 ]]
then
     prior_rec_no=$rec_no
     prev_line=$line
else
    if [[ $rec_no -eq $prior_rec_no ]]
    then

           if [[ $ben_type =  "ODL-SP" ]]
               then
               spouse_amt=$amount
               prev_line="$prev_line  $spouse_amt"

           elif  [[ $ben_type = "ODL-CH" ]]
                then
	       child_amt=$amount
               prev_line="$prev_line  $child_amt"
           fi
    else
        echo $prev_line >>  FILE2.DAT
        prev_line=$line
	prior_rec_no=$rec_no
    fi
     spouse_amt=""
     child_amt=""
fi 
(( rec_cnt=rec_cnt + 1 )) 
  prior_rec_no=$rec_no
done <FILE1.DAT

i getting the outfile FILE2.DAT for the above code


spouse_col child_col
21111111110001343 000001004OLFXXX029100020091112 0000060 (this is wrong as this should map to child_column)
22222222220000780 000001013OLFXXX006500020091112
23333333330001695 000001039OLFXXX030600020091112 0000111 0000060
24444444440001416 000001045OLFXXX011800020091112

Last edited by kshuser; 11-03-2009 at 03:52 PM..
# 2  
Old 11-03-2009
Your script seems a bit complicated as your explanations. I don't really understand what you want to do.
Why not use 'join' which seems to me a good tool for doing such a job.
join

Last edited by frans; 11-03-2009 at 05:52 PM.. Reason: add link
# 3  
Old 11-03-2009
This is how I would do it in ksh:
Code:
#!/bin/ksh
echo|cat FILE1.DAT -|while read line; do
  case ${line:27:6} in
    ODL-SP) spouse=${line:10:7} ;;
    ODL-CH) child=${line:10:7} ;;
    *)  if [[ -n $prev ]]; then
          print $prev $spouse $child
        fi
        prev=$line
        spouse="0000000"
        child="0000000"   ;;
  esac
done > FILE2.DAT

Code:
$> cat FILE2.DAT
21111111110001343 000001004OLF 029100020091112 0000000 0000060
22222222220000780 000001013OLF 006500020091112 0000000 0000000
23333333330001695 000001039OLF 030600020091112 0000111 0000060
24444444440001416 000001045OLF 011800020091112 0000000 0000000


Last edited by Scrutinizer; 11-03-2009 at 08:08 PM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #349
Difficulty: Easy
AWK was originally written in 1977 and distributed with Version 7 Unix.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

With script bash, read file line per line starting at the end

Hello, I'm works on Ubuntu server My goal : I would like to read file line per line, but i want to started at the end of file. Currently, I use instructions : while read line; do COMMAND done < /var/log/apache2/access.log But, the first line, i don't want this. The file is long... (5 Replies)
Discussion started by: Fuziion
5 Replies

2. Shell Programming and Scripting

[BASH] read 'line' issue with leading tabs and virtual line breaks

Heyas I'm trying to read/display a file its content and put borders around it (tui-cat / tui-cat -t(ypwriter). The typewriter-part is a 'bonus' but still has its own flaws, but thats for later. So in some way, i'm trying to rewrite cat using bash and other commands. But sadly it fails on... (2 Replies)
Discussion started by: sea
2 Replies

3. Shell Programming and Scripting

How to read file line by line and compare subset of 1st line with 2nd?

Hi all, I have a log file say Test.log that gets updated continuously and it has data in pipe separated format. A sample log file would look like: <date1>|<data1>|<url1>|<result1> <date2>|<data2>|<url2>|<result2> <date3>|<data3>|<url3>|<result3> <date4>|<data4>|<url4>|<result4> What I... (3 Replies)
Discussion started by: pat_pramod
3 Replies

4. Shell Programming and Scripting

Bash script to read a file from particular line till required line and process

Hi All, Am trying to write wrapper shell/bash script on a utility tool for which i need to pass 2 files as arugment to execute utility tool. Wraper script am trying is to do with above metion 2 files. utility tool accepts : a. userinfo file : which contains username b. item file : which... (2 Replies)
Discussion started by: Optimus81
2 Replies

5. Shell Programming and Scripting

Need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line...

Hello, I need a program that read a file line by line and prints out lines 1, 2 & 3 after an empty line... An example of entries in the file would be: SRVXPAPI001 ERRO JUN24 07:28:34 1775 REASON= 0000, PROCID= #E506 #1065: TPCIPPR, INDEX= 003F ... (8 Replies)
Discussion started by: Ferocci
8 Replies

6. Shell Programming and Scripting

Shell script to read multiple options from file, line by line

Hi all I have spent half a day trying to create a shell script which reads a configuration file on a line by line basis. The idea of the file is that each will contain server information, such as IP address and various port numbers. The line could also be blank (The file is user created). Here... (1 Reply)
Discussion started by: haggismn
1 Replies

7. Shell Programming and Scripting

how to read the contents of two files line by line and compare the line by line?

Hi All, I'm trying to figure out which are the trusted-ips and which are not using a script file.. I have a file named 'ip-list.txt' which contains some ip addresses and another file named 'trusted-ip-list.txt' which also contains some ip addresses. I want to read a line from... (4 Replies)
Discussion started by: mjavalkar
4 Replies

8. 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

9. Shell Programming and Scripting

bash: read file line by line (lines have '\0') - not full line has read???

I am using the while-loop to read a file. The file has lines with null-terminated strings (words, actually.) What I have by that reading - just a first word up to '\0'! I need to have whole string up to 'new line' - (LF, 10#10, 16#A) What I am doing wrong? #make file 'grb' with... (6 Replies)
Discussion started by: alex_5161
6 Replies

10. Shell Programming and Scripting

cat file1 read line-per-line then grep -A 15 lines down in fileb

STEP 1 # Set variable FILE=/tmp/mainfile SEARCHFILE =/tmp/searchfile # THIS IS THE MAIN FILE. cat /tmp/mainfile Interface Ethernet0/0 "outside", is up, line protocol is up Hardware is i82546GB rev03, BW 100 Mbps Full-Duplex(Full-duplex), 100 Mbps(100 Mbps) MAC address... (6 Replies)
Discussion started by: irongeekio
6 Replies

Featured Tech Videos