insert txt in the row


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting insert txt in the row
# 1  
Old 10-05-2009
insert txt in the row

hi

i am having text file like this

444 raju
666 ranga Clerk
999 rani officer
111 juhi

i want to get the out put as

444 raju NA
666 ranga Clerk
999 rani officer
111 juhi NA


pls help
# 2  
Old 10-05-2009
One way:

Code:
awk 'NF<3{$3="NA"}1' file

# 3  
Old 10-05-2009
use below:-

Code:
nawk '(NF<3) {$0=$0" NA" }1'  input_file

BR
# 4  
Old 10-05-2009
Code:
#! /bin/ksh

cat xyz | while read abc
do
	col1=`echo $abc | awk '{print $1}'`
	col2=`echo $abc | awk '{print $2}'`
	col3=`echo $abc | awk '{print $3}'`

	if [[ -z $col3 ]]
	then
		col3=NA
		echo "${col1} ${col2} ${col3}" >> output
	else
		echo "${col1} ${col2} ${col3}" >> output
	fi
done

# 5  
Old 10-05-2009
Code:
awk '{ if ( NF != 3 ) print $0, "N/A"; else print $0;}' file

# 6  
Old 10-05-2009
Code:
$sed -e 's/\([0-9]\+\) \([a-zA-Z]\+\)$/\1 \2 NA/g' filename

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Phrase txt file row to column

Hi Guys, I have one Big txt file and i what to phrase specific part as below. Input :- Event Event { recordLength 160118, recordType 411, eventId 3102118, INTERNAL_PER_RO_ME_TA { EVVXX_TIMESTAMP_HOUR 16, EVVXX_TIMESTAMP_MINUTE 15, EVVXX_TIMESTAMP_SECOND 3, ... (6 Replies)
Discussion started by: pareshkp
6 Replies

2. UNIX for Dummies Questions & Answers

Insert row into empty file...how?

Greetings: I generate an empty flat file just fine when there's no data returned from my process, as the customer wants one always (using the 1st line of the below script). However, they also want at least the column names in this flat file (row 1, the only row to be in the emply file). I'm... (7 Replies)
Discussion started by: Benrosa
7 Replies

3. UNIX for Dummies Questions & Answers

shell script : log to txt and insert new line everytime

Hi, I have this script, while do ps ax|grep 5060 > log.txt echo " " sleep 1 done } I want to actually put a new line everytime the loop is executed in log.txt , but I do not know how to "embed" the echo " " inside the log.txt. (so to say... (1 Reply)
Discussion started by: peuceul
1 Replies

4. Shell Programming and Scripting

Insert row without deleting previous data using sed

Hello, I want to add a new row to a file to insert data without deleting the previous data there. Example: file a b c d Output a b newtext c (6 Replies)
Discussion started by: joseamck
6 Replies

5. Shell Programming and Scripting

split row into lines and insert file name

I have a directory with several hundred files. The file format is a space delimited row with an unknown number of columns: A B C D E F G ... I need to turn this format File1 A File1 B File2 A File3 A File3 B File3 C ... I can use grep to display the filename next to each row of... (2 Replies)
Discussion started by: newreverie
2 Replies

6. UNIX for Dummies Questions & Answers

sed insert content of file.txt to multi files

Ive this sed & find command find /home/www/ -name footer.php -exec sed -i 's/<\/body>/file.txt\n<\/body>/' what I need to place content of file.txt before </body> in all footer.php files file.txt content is google analytic script which is like 7 lines any help to adjust my command to... (2 Replies)
Discussion started by: xmoe
2 Replies

7. Shell Programming and Scripting

Insert file.txt recursively

Anyone knows how I can change this script so that it works recursively as well (meaning: *.c files in sub directories will get changed as well)? for file in *.c do cat file.txt "$file" > tempfile cat tempfile > "$file" done rm tempfile (5 Replies)
Discussion started by: psve
5 Replies

8. Shell Programming and Scripting

How to insert data befor some field in a row of data depending up on values in row

Hi I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example. The original data record should be some thing like this 60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies

9. UNIX for Dummies Questions & Answers

insert header row into .xls

Hello, I am building an .xls file extracting info from a DB to be eventually emailed. All is good except how do I put in a header row.. like date, name of report etc. before the columns with the actual column name and data? Thanks for any assistance.. the below is after I have signed into... (11 Replies)
Discussion started by: Tish
11 Replies

10. Shell Programming and Scripting

Insert rows with computations of next row

Hello folks, I have data collected in every 3 hours. But, I would like to expand this to 1 hour interval by equally dividing with next row. For example, I want to keep the first value 1987-01-01-00z 2.0, but following all record should be re-written as follow. 1987-01-01-03z 5.0 becomes... (11 Replies)
Discussion started by: Jae
11 Replies
Login or Register to Ask a Question