Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

How to Append a Value to each line of the file

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to Append a Value to each line of the file
# 8  
Old 03-20-2008
Code:
awk '
!infile{infile=FILENAME;nr=1}
infile!=FILENAME{infile=FILENAME;nr++}
{print $0","nr}
' file1 file2 file3 > newfile

Regards
# 9  
Old 03-20-2008
Here is a solution in ksh. I assume the files and the numbers to be given as commandline parameters and i skip any error recovery, parameter validation or job security.

Call the script like: scriptname.sh file1 nr1 [file2 nr2 [..fileN nrN]]

Basically this is what joeyg already has suggested, just for multiple files:

Code:
#! /bin/ksh

typeset fFile=""
typeset chNum=""

while [ $# -gt 0 ] ; do
     fFile="$1"                 # get off the next two parameters
     shift
     chNum="$1"
     shift

     sed 's/$/,'"$chNum"'/' "${fFile}" > "${fFile}.tmp"
     mv "${fFile}.tmp" "${fFile}"
done

exit 0

I hope this helps.

bakunin
# 10  
Old 03-21-2008
Hope this one can help you.Smilie

Code:
n=0
for i in *
do
	n=`expr $n + 1`
	nawk -v num="$n" '{
		print $0""num
	}' $i > ${i}.t
	rm $i
	mv ${i}.t $i
done

# 11  
Old 03-21-2008
Thanks Summer cherry, it worked But a small change is required i want to append the Number with a comma (,) Can you Please help me on this
# 12  
Old 03-21-2008
MySQL
Thanks one and all....It worked Below is the final script which worked

n=0
for i in $i
do
n=`expr $n + 1`
nawk -v num="$n" '{
print $0","num
}' $i > ${i}.t
rm $i
mv ${i}.t $i


done

Sunny Smilie
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Append file name to the beginning of each line

I want to append file names at the beginning of a line for each row file content abc.txt.gz 123|654|987 bcd.txt.gz 876|trf|kjh I want a single output file with below format abc.txt.gz|123|654|987 bcd.txt.gz|876|trf|kjh This one is working but only with unzip files,need to have... (3 Replies)
Discussion started by: rakesh5300
3 Replies

2. Shell Programming and Scripting

conditional append one line in file.

Hi, Unix gurus, I have a requirement as following: checking existing file, if the file only contain one line. then append "No data" else keep existing file as is. can i achieve this by in command line without write a script. :wall: Thanks in advance. (4 Replies)
Discussion started by: ken002
4 Replies

3. Shell Programming and Scripting

Append string to first line of a file

Hi, Please suggest me to write unix command, HEADER20110101 string append to first line of a file.. Regards Akshu (3 Replies)
Discussion started by: akshu.agni
3 Replies

4. Shell Programming and Scripting

How to append text to the second line of a file

Say I have a text file like: 1 3 4 How would I use ksh to put the number '2' into the second line of that file? I'm using OpenBSD so the sed syntax might be a bit different (I have no idea how to use sed, though) (4 Replies)
Discussion started by: guitarscn
4 Replies

5. Shell Programming and Scripting

Append to exisiting file on same line.

File Format ABC|ABC|ABC| need to add another text after last | which would a unix command output. ---------- Post updated at 02:05 PM ---------- Previous update was at 01:45 PM ---------- wc -l file| awk '{print $1}' | sed 's/$//' >> existingfile It still adds to new line (4 Replies)
Discussion started by: dinjo_jo
4 Replies

6. Shell Programming and Scripting

append a line into a file in the top

hi, My code is #!/bin/sh echo "\n\nPlease enter the month of the year(YYYYMM) : \c" read date_rep INPUT_L9_FILE=L9_Recharge_Description_EOM_$date_rep.csv #This part is used to summarise Grand_Total, Balance_Total of file L9_Recharge_Description_EOM_${1}.csv. awk -F"," '{if(NR!=1)... (5 Replies)
Discussion started by: madfox
5 Replies

7. Shell Programming and Scripting

shell script to read a line in gps receiver log file and append that line to new file

Hi, I have gps receiver log..its giving readings .like below Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. GPSD,R=1 $GPGSV,3,1,11,08,16,328,40,11,36,127,00,28,33,283,39,20,11,165,00*71... (3 Replies)
Discussion started by: gudivada213
3 Replies

8. Shell Programming and Scripting

Append each line to next previous line in a file

Hi all, Please help me in providing sample code to append the following 4 lines in one row. Input : A1/EXT "BAPBSC10/07B/00" 523 090530 0115 RXOCF-430 HY1711 1 EXTERNAL ALARM DOOR ALARM Output should be : A1/EXT "BAPBSC10/07B/00" 523 090530 0115 ... (8 Replies)
Discussion started by: sudhakaryadav
8 Replies

9. Shell Programming and Scripting

how to append line of of data to file

hai..i am new to unix..and i've currently learn shell script.. i have this small problem where i would like to save every data from log file into user directory if the data is equal to the name of the user.. i manage to do that with below script.. i would like to ask if there is any solutions so... (1 Reply)
Discussion started by: meggae
1 Replies

10. UNIX for Dummies Questions & Answers

Large file need to append to each line

I have a few large files that need to have a ,A appended to the end of each record. I though about using sed but never used it before and the man is not intuitive nor have I found examples. This is what I tried for file name bob sed '\a,A' bob from what I get if you do not supply a range... (1 Reply)
Discussion started by: r1500
1 Replies
Login or Register to Ask a Question