Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Print all lines in a row except the last one with awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Print all lines in a row except the last one with awk
# 1  
Old 05-24-2017
Print all lines in a row except the last one with awk
Hi again,
is it possible to do the following using awk?

input file is
Code:
4.465E+17
5.423E+16
1.218E+17
2.600E+16
9.135E+15
1.238E+14
...
6.238E+14

desired output
Code:
4.465E+17 &
5.423E+16 &
1.218E+17 &
2.600E+16 &
9.135E+15 &
1.238E+14 &
...       &
6.238E+14

Thanks,
S.
# 2  
Old 05-24-2017
That's easier with sed unless you process the file with awk anyhow beforehand in which case you should include the append there. Try
Code:
sed '$!s/$/ \&/' file
4.465E+17 &
5.423E+16 &
1.218E+17 &
2.600E+16 &
9.135E+15 &
1.238E+14 &
... &
6.238E+14

This User Gave Thanks to RudiC For This Post:
f_o_555
# 3  
Old 05-24-2017
Hello f_o_555,

Could you please try following and let me know if this helps you.
Code:
awk 'FNR==NR{count++;next} FNR<count{print $0 FS "&";next} 1'  Input_file  Input_file

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
f_o_555
# 4  
Old 05-24-2017
Code:
awk '$1=$1' RS= OFS=" &\n" infile

These 3 Users Gave Thanks to rdrtx1 For This Post:
Don Cragun drl RudiC
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

awk - (URGENT!) Print lines sort and move lines if match found

URGENT HELP IS NEEDED!! I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but - Currently, script is not printing lines to File3.txt in order. - Also the matching lines are not moving out of File1.txt ... (1 Reply)
Discussion started by: High-T
1 Replies

2. UNIX for Dummies Questions & Answers

awk to sum column field from duplicate row/lines

Hello, I am new to Linux environment , I working on Linux script which should send auto email based on the specific condition from log file. Below is the sample log file Name m/c usage abc xxx 10 abc xxx 20 abc xxx 5 xyz ... (6 Replies)
Discussion started by: asjaiswal
6 Replies

3. Shell Programming and Scripting

Print list to row using awk

Hello, can somebody help me on this please. I have a list of numbers and I want to print them in one line seprated by a comma except the last one using awk 34 12 56 76 88 output 34,12,56,76,88 Thanks Sara (15 Replies)
Discussion started by: Sara_84
15 Replies

4. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies

5. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Is it possible to remove redundant names in the 4th column? input cqWE 100 200 singapore;singapore AZO 300 400 brazil;america;germany;ireland;germany .... .... output cqWE 100 200 singapore AZO 300 400 brazil;america;germany;ireland (4 Replies)
Discussion started by: quincyjones
4 Replies

6. Shell Programming and Scripting

print the whole row in awk based on matched pattern

Hi, I need some help on how to print the whole data for unmatched pattern. i have 2 different files that need to be checked and print out the unmatched patterns into a new file. My sample data as follows:- File1.txt Id Num Activity Class Type 309 1.1 ... (5 Replies)
Discussion started by: redse171
5 Replies

7. Shell Programming and Scripting

AWK Script - Print a column - within a Row Range

Hi, Please read the whole thread. I have been working on this script below. It works fine, feel free to copy and test with the INPUT File below as well. example: PACKET DATA PROTOCOL CONTEXT DATA APNID PDPADD EQOSID VPAA PDPCH PDPTY PDPID 10 ... (6 Replies)
Discussion started by: panapty
6 Replies

8. Shell Programming and Scripting

awk print specific columns one row at a time

Hello, I have the following piece of code: roleName =`cat $inputFile | awk -F';' '{ print $1 }'` roleDescription =`cat $inputFile | awk -F';' '{ print $2 }'` roleAuthProfile =`cat $inputFile | awk -F';' '{ print $3 }'` mappedUserID (5 Replies)
Discussion started by: pr0tocoldan
5 Replies

9. Shell Programming and Scripting

awk to print all row to one line

HI , My unix command output look like below , bste-ngh-bt9.hecen.com EA1981, 09/01/2010 17:56:56 03/31/2011 00:00:00 I want this output changed to , all i need in one line with space ! bste-ngh-bt9.hecen.com EA1981 09/01/2010 17:56:56 03/31/2011 00:00:00 need to get all in... (17 Replies)
Discussion started by: gnanasekar_beem
17 Replies

10. Shell Programming and Scripting

shell script(Preferably awk or sed) to print selected number of columns from each row

Hi Experts, The question may look very silly by seeing the title, but please have a look at it clearly. I have a text file where the first 5 columns in each row were supposed to be attributes of a sample(like sample name, number, status etc) and the next 25 columns are parameters on which... (3 Replies)
Discussion started by: ks_reddy
3 Replies
Login or Register to Ask a Question