UNIX for Dummies Questions & Answers

Hello,

I am having trouble calculating some numbers and I was hoping someone could help me solve this.

I have one file with 1 column and what I'm trying to do is add up the lines until a certain value is reach, then jump to where it last finished counting and continue.

so for ex: if I want to count up until the value of 10 is reached in the file below, then I would stop in line 7 And then continue counting in line 8 until the end of the file.

does anyone have any ideas?

Without seeing the output you want, I'm left guessing what you really want, but so far it sounds like simple modulous.

Code:

awk '{ N += $1; $2=N%10 } 1' filename

What I am trying to do is just add up a column by segments, and a segment will be defined when the addition of several lines add up to a certain value -- 10 in this case.

so if the input is:

then the output should be


does this help?

Code:

awk 'N>=10 { $2=10; N=0 } 1; { N+=$1 }' filename

Thanks! that seems to be in the direction I am looking for!

When I tried

however, it did not produce the same result as >=. Why is that?

Because it's possible for it to skip straight past 10. Sometimes it might end up 11, or 12, if the numbers don't sum to an even 10.

Hi, Corona688:
Can you please explain a little bit what the "1" means in your script?

Code:

awk 'N>=10 { $2=10; N=0 } 1; { N+=$1 }' filename

I think I can catch the rest except the "1". Thanks