Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Add lines into file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add lines into file
# 1  
Old 06-02-2005
Error Add lines into file
Hi, i have a file like:

00:00 8
00:01 2
00:04 5
00:07 10
.
.
.

and i need to add the other minutes with value 0 and have a file like:

00:00 8
00:01 2
00:02 0
00:03 0
00:04 5
00:05 0
00:06 0
00:07 10
.
.
.

hoy i can do it? plz i need help with this... or ill be fired.... ji ji ji
# 2  
Old 06-02-2005
you might still be fired for begging, but.....

nawk -f lestat.awk file

lestat.awk:
Code:
BEGIN {
  FS="[ :]"
}

FNR==1{ min=$2; print;next}

min + 1 != $2 {
  while ( ++min < $2 )
     printf("00:%02d 0\n", min)
}
{min=$2;print}

# 3  
Old 06-02-2005
I'm assuming you want this for 24 hour period, if not remove the outer while loop and the HOUR variable.

Code:
#!/bin/ksh
#
# alltimes.ksh
#

INPUTFILE=${1}

typeset -Z2 HOUR
typeset -Z2 MIN

HOUR=0
MIN=0

while [[ ${HOUR} -lt 24 ]] ; do
    while [[ ${MIN} -lt 60 ]] ; do
        grep "${HOUR}:${MIN}" ${INPUTFILE} || echo ${HOUR}:${MIN} 0
        MIN=$((${MIN} + 1))
    done
    HOUR=$((${HOUR} + 1))
    MIN=0
done

Code:
./alltimes.ksh inputfile > outpufile

# 4  
Old 06-02-2005
Thanx a lot.... thanx x 100000
# 5  
Old 06-02-2005
Please explain me what each line do in your script, because i need to do it from 00:00 (min:sec) to 59:59 (min:sec) and with your script i can do it in a day... thanx

Quote:
Originally Posted by vgersh99
you might still be fired for begging, but.....

nawk -f lestat.awk file

lestat.awk:
Code:
BEGIN {
  FS="[ :]"
}

FNR==1{ min=$2; print;next}

min + 1 != $2 {
  while ( ++min < $2 )
     printf("00:%02d 0\n", min)
}
{min=$2;print}

# 6  
Old 06-02-2005
Your script really help me, i have to change some variables like HOUR to MIN and MIN to SEC but i have one problem, i dont have one IMPUTFILE, i have 72 IMPUTFILES and in each one this procces take around 4 minutes, it means all the proccess will be around 288 minutes... could you help me again plz?

Quote:
Originally Posted by reborg
I'm assuming you want this for 24 hour period, if not remove the outer while loop and the HOUR variable.

Code:
#!/bin/ksh
#
# alltimes.ksh
#

INPUTFILE=${1}

typeset -Z2 HOUR
typeset -Z2 MIN

HOUR=0
MIN=0

while [[ ${HOUR} -lt 24 ]] ; do
    while [[ ${MIN} -lt 60 ]] ; do
        grep "${HOUR}:${MIN}" ${INPUTFILE} || echo ${HOUR}:${MIN} 0
        MIN=$((${MIN} + 1))
    done
    HOUR=$((${HOUR} + 1))
    MIN=0
done

Code:
./alltimes.ksh inputfile > outpufile

# 7  
Old 06-02-2005
okay hang on a minute, I do have a more efficient way of doing it.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add 3 new lines for every line in a file

I have a file that I need to add 3 new lines of text for every line in the file - when I attempt the sed scripting below I keep getting 'command garbled' errors. Any suggestions would be greatly appreciated #!/bin/ksh list=`cat /export/home/list` for i in $list do sed ' a \... (7 Replies)
Discussion started by: bjdamon
7 Replies

2. UNIX for Dummies Questions & Answers

Add strings from one file at the end of specific lines in text file

Hello All, this is my first post so I don't know if I am doing this right. I would like to append entries from a series of strings (contained in a text file) consecutively at the end of specifically labeled lines in another file. As an example: - the file that contains the values to be... (3 Replies)
Discussion started by: gus74
3 Replies

3. Shell Programming and Scripting

How to add two common lines on entire file

Hi Hi i have 500 lines of file,each line i need to add another two lines also need to separate with one line for every 3 lines after adding two lines.How to achieve this using shell? For example: Input file : dn: uid=apple,dc=example,dc=com dn: uid=ball,dc=example,dc=com output:... (4 Replies)
Discussion started by: buzzme
4 Replies

4. Shell Programming and Scripting

Extract some lines from one file and add those lines to current file

hi, i have two files. file1.sh echo "unix" echo "linux" file2.sh echo "unix linux forums" now the output i need is $./file2.sh unix linux forums (3 Replies)
Discussion started by: snreddy_gopu
3 Replies

5. Shell Programming and Scripting

How to add lines of a file and average them

I'm reading in numbers from a file and trying to add them together. Here is the code so far. I know the 1+2+3.... part is wrong. The file has five numbers in it with each number on its own line. The numbers are decimals if that matters. Thanks. while read EachLine do echo $EachLine done <... (6 Replies)
Discussion started by: AxlVanDamme
6 Replies

6. Shell Programming and Scripting

add few lines to a file in unix

Hi, I have an xml file <Disp x=y a=b Disp/> <Disp q=1 w=2 Disp/> ..... I want to add a new set in between like this for a set of 100 files. <Disp x=y a=b Disp/> <Disp k=1 z=2 Disp/> <Disp q=1 w=2 (7 Replies)
Discussion started by: naga_5star
7 Replies

7. Shell Programming and Scripting

XML file: add 100 lines

Hi Gurus, I have XML file which i want to add 100 lines.I have no idea in xml how to add or modify data .Any help should be appreciated. Thanks, Akil (6 Replies)
Discussion started by: akil
6 Replies

8. Shell Programming and Scripting

add lines in file with perl

How to search string like: a and replace to a a a : : a in a file with perl? Thanks, Grace (6 Replies)
Discussion started by: jinsh
6 Replies

9. Shell Programming and Scripting

Add Lines in middle of file

I need to add a new lines with certain data, to an existing file, every 5 lines in the file. There is no way to find any distinct charater pattern so I will have to do a line count and then insert the new line. I think using awk or sed is what I need to do. Any help is appreciated. Kunder (2 Replies)
Discussion started by: kunder
2 Replies

10. HP-UX

Add a column at the end of all the lines in a file

Hi Guys, :D I am very much new to UNIX. I dont have much basics of coding in UNIX, so please help me out of thi ssituation. I have a file say for ex: ABC.dtd and it contains "|" delimited data as test1|testing|test3|moving past1|runing|test4|going I need to add a column at the end... (6 Replies)
Discussion started by: ruthless
6 Replies
Login or Register to Ask a Question