Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help with While loop using if else

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with While loop using if else
# 8  
Old 07-01-2017
Hi Rudic , zaxxon
Below is another example of what I am looking for :
Can you all please help ?

sample file.txt
Code:
Line,count,symbol
1,3,A
2,4,B
3,5,C
4,1,D
5,2,E
6,6,F
7,7,G
8,8,H

Expected result:
Group records based on the cumulative sum of second column "count" ,
such that the records fall under the same group till the cumulative sum of the coulmn "count" exceeds 12.
Once the cumulative sum exceeds , the loop should restart . for eg below , the first three records fall under group '1'
as their cumulative sum is 12.Similarily the records from 4 to 6 falls under group '2' as the cumulative sum (1+2+6)=9 which is less than 12.Similarily , the records 7 and 8 will be in groups 3 and 4 respectively

sample output
Code:
Line,count,symbol,group
1,3,A,1
2,4,B,1
3,5,C,1
4,1,D,2
5,2,E,2
6,6,F,2
7,7,G,3
8,8,H,4

Last edited by vbe; 07-01-2017 at 01:42 PM.. Reason: all was between code tags...
# 9  
Old 07-01-2017
Hello paul1234,

Could you please try following and let me know if this helps you.
Code:
awk -v val=1 -F, 'NR==1{print;next} {SUM+=$2} SUM>12{val++;SUM=$2} SUM<=12{print $0 FS val}'  Input_file

Thanks,
R. Singh
# 10  
Old 07-01-2017
@bakunin,
you promote bash,
where the last part of a pipe is run in a subshell, so the following does not work
Code:
    echo "$line" | IFS=, read junk var1 junk
    echo "$var1"

It only works in ksh and its derivatives.
You can use a here string
Code:
    IFS=, read junk var1 junk <<< "$line"
    echo "$var1"

If there is a while loop anyway, consider to immediately apply the field splitting, because composing the line is easy
Code:
while IFS=, read field1 var1 last
do
    line="$field1,$var1,$last"
    echo "$line"
    echo "$var1"
done < file_size_num

.txt
# 11  
Old 07-01-2017
Hi Ravinder ,
Its not working Smilie grouping column is incorrect . PFB the output
Code:
-bash-4.2$ awk -v val=1 -F, 'NR==1{print;next} {SUM+=$2} SUM>12{val++;SUM=$2} SUM<=12{print $0 FS val}'  file_size_num1.txt
1,3,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1900
2,4,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,1
3,5,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,1
4,1,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,1
5,2,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1900,1
6,6,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,2
7,7,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,3
8,8,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,4

# 12  
Old 07-01-2017
Hello paul1234, That's because your previous post's sample Input_file has headers and the data you are trying is NOT having it, so when you will have headers it should fly then, let me know how it goes then. Thanks, R. Singh
# 13  
Old 07-01-2017
Hi Ravinder ,
Thank you so much .. I slightly changed the code that you provided and it seems to be working now.
Thank you allSmilie

Code:
 awk -v val=1 -F, 'NR==N-1{print;next} {SUM+=$2} SUM>12{val++;SUM=$2} SUM<=12{print $0 FS val}' < file_size_num1.txt
  
 output as expected:
1,3,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1900,1
2,4,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,1
3,5,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,1
4,1,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,2
5,2,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1900,2
6,6,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,2
7,7,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,3
8,8,/informatica/apps/logs/fin/ote/TgtFiles/Destination/CWXX/CW1901,4

# 14  
Old 07-01-2017
Hello paul1234, You could THANKS button to thank any helpful post to any person here forum. I wanted to let you know that you need not to put NR==1 {print;next} since you don't have headings, if you have headers then you could add this condition to code. Thanks, R. Singh
Last edited by RavinderSingh13; 07-01-2017 at 12:18 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

For loop or while loop from a text file

Hi all, i developed a script to measure the uptime of a process in a Solaris 10/11 environments. All is well, but i came across a situation where there are multiple processes of the same name. Basically i have the following result file: beVWARS 13357 19592122 beVWARS 14329 19591910... (4 Replies)
Discussion started by: nms
4 Replies

2. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Here's my code: awk -F '' 'NR==FNR { if (/time/ && $5>10) A=$2" "$3":"$4":"($5-01) else if (/time/ && $5<01) A=$2" "$3":"$4-01":"(59-$5) else if (/time/ && $5<=10) A=$2" "$3":"$4":0"($5-01) else if (/close/) { B=0 n1=n2; ... (2 Replies)
Discussion started by: klane
2 Replies

3. Shell Programming and Scripting

Reset while loop to loop same file multiple times

Hi, I want to read file multiple times. Right now i am using while loop but that is not working. ex. While read line do while read line2 do echo stmt1 #processing some data based on data., done < file2.txt done < file1.txt # This will have 10... (4 Replies)
Discussion started by: tmalik79
4 Replies

4. Shell Programming and Scripting

Array Variable being Assigned Values in Loop, But Gone when Loop Completes???

Hello All, Maybe I'm Missing something here but I have NOOO idea what the heck is going on with this....? I have a Variable that contains a PATTERN of what I'm considering "Illegal Characters". So what I'm doing is looping through a string containing some of these "Illegal Characters". Now... (5 Replies)
Discussion started by: mrm5102
5 Replies

5. Shell Programming and Scripting

My for loop decides to become an infinite loop?

Hi, I was debating if I should put this in the dummies or scripts section, I apologize in advance if I chose poorly. Fairly new to Unix and BASH scripting but I thought I made it fairly well given my limited understanding. However, the output indicates that it's looping and I'm ending up with a... (5 Replies)
Discussion started by: gotreef
5 Replies

6. Shell Programming and Scripting

S# in a for loop - concatenate $(loop counter)

Hi, hope I am posting in the right section. My problem is that I have 2 or more arguments passed and I want to check if the arguments passed exists or not. The first argument should not exist and the remaining others should exist. example: ./shells.sh argument1 argument2 argument3 ... (5 Replies)
Discussion started by: fight4love
5 Replies

7. Shell Programming and Scripting

BASH loop inside a loop question

Hi all Sorry for the basic question, but i am writing a shell script to get around a slightly flaky binary that ships with one of our servers. This particular utility randomly generates the correct information and could work first time or may work on the 12th or 100th attempt etc !.... (4 Replies)
Discussion started by: rethink
4 Replies

8. Shell Programming and Scripting

Null Handling in Until loop. . .loop won't stop

Hi Im running this script, which is supposed to find the max value build some tables and then stop running once all the tables are built. Thing is , it keeps assigning a null value to $h and then $g is null so it keep building tables i.e. testupdateNUL. How can I stop this? Here is what I have: ... (4 Replies)
Discussion started by: brandono66
4 Replies

9. Shell Programming and Scripting

Using variables created sequentially in a loop while still inside of the loop [bash]

I'm trying to understand if it's possible to create a set of variables that are numbered based on another variable (using eval) in a loop, and then call on it before the loop ends. As an example I've written a script called question (The fist command is to show what is the contents of the... (2 Replies)
Discussion started by: DeCoTwc
2 Replies

10. Shell Programming and Scripting

Is there a better way I could have run this loop. (For loop with two variables)

Sorry for such a dreadful title, but I'm not sure how to be more descriptive. I'm hoping some of the more gurutastic out there can take a look at a solution I came up with to a problem, and advice if there are better ways to have gone about it. To make a long story short around 20K pieces of... (2 Replies)
Discussion started by: DeCoTwc
2 Replies
Login or Register to Ask a Question