Add leading zeroes to numbers in a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add leading zeroes to numbers in a file
# 1  
Old 06-17-2008
Add leading zeroes to numbers in a file

Hello, I am (trying) to write a script that will check to see how many users are logged on to my machine, and if that number is more than 60 I need to kill off all the oldest sessions that are over 60. So far I have been able to check how many users are on and now I am at the part where I have to actually kill them off. I have chosen to write the idle times for all the logged on users into a file, but I need to add leading zeroes to them in order to properly sort them. How do I do this? the file is /tmp/uidle. This is my code so far:

Code:
numusers=$(who -q | grep Total | tr -s " " | cut -d" " -f3)                
echo Total number of users: ${numusers}                                    
if test $numusers -gt 60; then                                             
diff=$(expr $numusers - 60)                                                
echo "There are $diff too many users, killing the $diff oldest users..."   
who -u | sort -k4.2,6 | grep bhb | tr -s " " | cut -d" " -f5 >> /tmp/uidle 
else                                                                       
echo "There are less than 60 users. Exiting"                               
fi                                                                         
exit 1

Thanks
# 2  
Old 06-17-2008
Hammer & Screwdriver forcing leading zero

This will force to a five-digit field, with leading zero:

Code:
> val=123
> valf=$(printf "%.5d" "$val")
> echo $valf
00123

(Was not sure what field you were trying to format.)
By the way, you can sort on a numeric. Try the following command which looks at all files in your directory, lists owner size name, but sorts on size:
Code:
>ls -l | tr -s " " | cut -d" " -f3,5,9 | sort -n -k2

# 3  
Old 06-17-2008
wish I would have looked around a little more before posting. This is what helped me out:

Code:
awk '{for (i=1; i<NF; i++) $i=sprintf("%02d", $i); print; }' /tmp/uidle

At this point though, I need to reorder the numbers inside the file in descending order. I know how to do it in ascending order with
Code:
cat /tmp/uidle | sort -k1

How do I reverse it? Or just sort the opposite way to begin with?

Last edited by raidzero; 06-17-2008 at 11:53 AM..
# 4  
Old 06-17-2008
Hammer & Screwdriver reverse sort just needs an 'r'

see this example:

Code:
ls -l | tr -s " " | cut -d" " -f3,5,9 | sort -rn -k2

displays files in reverse order based on size.
So, for your example:

Code:
cat /tmp/uidle | sort -r -k1

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Strip leading and numbers from a string.

Hello I have two vars loaded with $VAR1="ISOMETHING103" $VAR2="COTHERTHING04" I need to: 1) Strip the first char. Could be sed 's/^.//' 2) The number has it's rules. If it has "hundreds", it needs to be striped. If it is just two digits it shouldn't. So, for VAR1 output should be... (7 Replies)
Discussion started by: tristezo2k
7 Replies

2. Shell Programming and Scripting

Numbers with leading zeros

Hi, i have a variable which conatins values like 00001,0003,00067,00459. I want to use the values one by one and in the same form as they are like 00001,0003,00067,00459. Also can anyone tell me how to increment those numbers by 1,keeping the format as same like 00002,0004,00068,00460.... (5 Replies)
Discussion started by: arijitsaha
5 Replies

3. Shell Programming and Scripting

rename numbered files to numbered files with leading zeroes

Hi, I have some hundreds/thousands of files named logX.dat, where X can be any integer, and they are sequential, X ranges between 1 and any number: log1.dat log2.dat log3.dat log6.dat log10.dat ... log6000.dat I would like to rename them to scatter_params_0001.dat... (6 Replies)
Discussion started by: pau
6 Replies

4. Shell Programming and Scripting

awk and leading zeroes

I have the following script that renames filenames like: blah_bleh_91_2011-09-26_00.05.43AM.xls and transforms it in: 91_20110926_000543_3_blih.xls for a in *.xls; do b="$(echo "${a}" | cut -d '_' -f4)" dia=`echo ${b} | cut -c9-10` mes=`echo ${b} | cut -c6-7` anio=`echo ${b} | cut -c1-4`... (4 Replies)
Discussion started by: Tr0cken
4 Replies

5. UNIX for Dummies Questions & Answers

Add leading zeros to columns in a file

Hello Gurus, Quick question. I have a file with the following records: A~000000000000518000~SLP ~99991231~20090701~88.50~USD~CS~ A~000000000000518000~SLP ~99991231~20090701~102.00~USD~CS~ A~000000000000772000~SLP ~99991231~20100701~118.08~USD~CS~ I wold like to do the following: 1. Add... (1 Reply)
Discussion started by: chumsky
1 Replies

6. Shell Programming and Scripting

Remove leading zeroes in 2nd field using sed

Hi Forum. I tried searching the forum but couldn't find a solution for my question. I have the following data and would like to have a sed syntax to remove the leading zeroes from the 2nd field only: Before: 2010-01-01|123|1|1000|2000|500|1500|600|700... (18 Replies)
Discussion started by: pchang
18 Replies

7. Shell Programming and Scripting

sed not removing leading zeroes

I have th following file 0000000011 0000000001 0000000231 0000000001 0000000022 noow when i run the following command sed 's/^0+//g' file name I receive the same output and the leading zeroes are not removed from the file . Please let me know how to achieve... (4 Replies)
Discussion started by: asalman.qazi
4 Replies

8. Shell Programming and Scripting

insert leading zeroes based on the character count

Hi, I need add leading zeroes to a field in a file based on the character count. The field can be of 1 character to 6 character length. I need to make the field 14bytes. eg: 8351,20,1 8351,234,6 8351,2,0 8351,1234,2 8351,123456,1 8351,12345,2 This should become. ... (3 Replies)
Discussion started by: gpaulose
3 Replies

9. Programming

how to check and remove leading zeroes from the buffer using c program

Helo , I m writing small module of c.on RHEL 4 I have one buffer (for e.g. buffer = "002" now I want to check whethere buffer contains leading zeroes and if it contains leading zeroes then I want to remove all leading zeroes ( i.e. if buffer = "002" then I want to make buffer = "2") how... (1 Reply)
Discussion started by: amitpansuria
1 Replies

10. Shell Programming and Scripting

How to trim the leading zeroes in a Currency field ?

How do I trim the leading zeroes, and (+,-) in the currency field ? I have a text file. Your bill of +00002780.96 for a/c no. 25287324 is due on 11-06. Your bill of +00422270.48 for a/c no. 28931373 is due on 11-06. I want the O/P file to be like. Your bill of 2780.96 for a/c no. 25287324... (22 Replies)
Discussion started by: Amruta Pitkar
22 Replies
Login or Register to Ask a Question