Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

while read line do

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting while read line do
# 1  
Old 10-23-2009
while read line do
I have a .dat file like below eg: sample.DAT


Code:
21111111110000652 B86860003OLFXXX000000120081227
21111111110000652 B86860003ODL-SP000000220081227
21111111110000652-B94030001ODL-CH000000320081227
22222222220000653-B94030001OLFXXX000001120081227
23333333330000654-E71060001OLFXXX000001220081227
24444444440000655 E71060002OLFXXX000001420081227
24444444440000655 E71060002ODL-SP000001520081227
 
111111111 is a ssno with 3 records self(amt is 0000001), spouse(amt is 0000002),child (amt is 0000003)
222222222 is a ssno with just 1 record self
333333333 is a ssno with just 1 record self
444444444 is a ssno with just 2 record self(amt is 0000014),spouse(amt is 0000015)

after reading the above file in the WHILE READ LINE DO loop

Basically i am creating 2 more new columns amt_1 and amt_2 in the flat file (sampleout.txt) seperating if any records exists with spouse or child.
for eg: record 21111111110000652 we have 3 records self,spouse & child, i need to create only one record seperating the spouse or child record exists with the amount coulumns seperate spouse amt is 0000002 & child amt is 0000003 like wise the loop should check

Code:
21111111110000652 B86860003OLFXXX000000120081227 0000002 0000003
22222222220000653-B94030001OLFXXX000001120081227
23333333330000654-E71060001OLFXXX000001220081227
24444444440000655 E71060002OLFXXX000001420081227 0000015

-----
-----
...etc

Any help is appreciated.

Thanks in adv.
Last edited by kshuser; 10-27-2009 at 10:27 PM.. Reason: code tags, please!
# 2  
Old 10-23-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.)
# 3  
Old 10-23-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
# 4  
Old 10-23-2009
while read line do...no solution for this
No reply on this...
Quote:
Originally Posted by kshuser
I have a .dat file like below eg: sample.DAT


Code:
21111111110000652 B86860003OLFXXX000000120081227
21111111110000652 B86860003ODL-SP000000220081227
21111111110000652-B94030001ODL-CH000000320081227
22222222220000653-B94030001OLFXXX000001120081227
23333333330000654-E71060001OLFXXX000001220081227
24444444440000655 E71060002OLFXXX000001420081227
24444444440000655 E71060002ODL-SP000001520081227
 
111111111 is a ssno with 3 records self(amt is 0000001), spouse(amt is 0000002),child (amt is 0000003)
222222222 is a ssno with just 1 record self
333333333 is a ssno with just 1 record self
444444444 is a ssno with just 2 record self(amt is 0000014),spouse(amt is 0000015)

after reading the above file in the WHILE READ LINE DO loop

Basically i am creating 2 more new columns amt_1 and amt_2 in the flat file (sampleout.txt) seperating if any records exists with spouse or child.
for eg: record 21111111110000652 we have 3 records self,spouse & child, i need to create only one record seperating the spouse or child record exists with the amount coulumns seperate spouse amt is 0000002 & child amt is 0000003 like wise the loop should check

Code:
21111111110000652 B86860003OLFXXX000000120081227 0000002 0000003
22222222220000653-B94030001OLFXXX000001120081227
23333333330000654-E71060001OLFXXX000001220081227
24444444440000655 E71060002OLFXXX000001420081227 0000015

-----
-----
...etc
Code:
rec_cnt=1 
while read line 
do
ssn=`echo $line|cut -c2-10`
ben_type=`echo $line|cut -c28-33`
amount=`echo $line|cut -c34-40`
if [ $rec_cnt -eq 1 ]
then
outline=$line
prior_ssn=$ssn
rec_cnt=2
fi
if [ $ssn -eq $prior_ssn ]
then
if [ $ben_type = "ODL-SP" ]
then
sp_amount=$amount
elif [ $ben_type = "ODL-CH" ]
then
ch_amount=$amount
else
echo 'invalid ben_type'
fi
else
echo $outline $sp_amount $ch_amount >> $DATADIR/OUTFILE.txt
outline=$line
prior_ssn=$ssn
sp_amount=""
ch_amount="" 
fi
done <$DATADIR/sample.dat

Any help is appreciated.

Thanks in adv.
Login or Register to Ask a Question

Previous Thread | Next Thread

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
Login or Register to Ask a Question