Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to duplicate rows using awk or any other method?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to duplicate rows using awk or any other method?
# 1  
Old 09-11-2014
How to duplicate rows using awk or any other method?
I want to duplicate each row in my file

Eg
Code:
file.txt
Name State Age
Jack NJ 34
John MA 23
Jessica FL 45


I want the code to produce this output
Code:
Name State Age
Jack NJ 34
Jack NJ 34
John MA 23
John MA 23
Jessica FL 45
Jessica FL 45

I have no idea how to do this

Any help would be greatly appreciated
# 2  
Old 09-11-2014
Using awk:

Code:
awk 'NR>1{print}1' file.txt

# 3  
Old 09-11-2014
Either be explicitSmilie
Code:
awk 'NR>1{print} {print}' file.txt

or consequently crypticSmilie
Code:
awk 'NR>1;1' file.txt

With sed (always cryptic):
Code:
sed '1!p' file.txt

This User Gave Thanks to MadeInGermany For This Post:
junior-helper
# 4  
Old 09-11-2014
Quote:
Originally Posted by MadeInGermany
sed '1!p' file.txt
Smilie


sed 's/^\(.*\)$/\1\n\1/' list | sed 1d shame on me Smilie
# 5  
Old 09-12-2014
Quote:
Originally Posted by MadeInGermany
Either be explicitSmilie
Code:
awk 'NR>1{print} {print}' file.txt

or consequently crypticSmilie
Code:
awk 'NR>1;1' file.txt

With sed (always cryptic):
Code:
sed '1!p' file.txt


Thanks the sed command worked , but got syntax error for all the awk

---------- Post updated at 11:20 PM ---------- Previous update was at 11:20 PM ----------

Quote:
Originally Posted by pilnet101
Using awk:

Code:
awk 'NR>1{print}1' file.txt


Thanks but I got syntax error
# 6  
Old 09-12-2014
What is your OS and version? On Solaris use /usr/xpg4/bin/awk rather than awk.
# 7  
Old 09-12-2014
Or use nawk
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Median and max of duplicate rows

Hi all, plz help me with this, I want to to extract the duplicate rows (column 1) in a file which at least repeat 4 times. then I want to summarize them by getting the max , mean, median and min. The file is sorted by column 1, all the repeated rows appear together. If number of elements is... (5 Replies)
Discussion started by: ritakadm
5 Replies

2. Shell Programming and Scripting

Delete duplicate rows

Hi, This is a followup to my earlier post him mno klm 20 76 . + . klm_mango unix_00000001; alp fdc klm 123 456 . + . klm_mango unix_0000103; her tkr klm 415 439 . + . klm_mango unix_00001043; abc tvr klm 20 76 . + . klm_mango unix_00000001; abc def klm 83 84 . + . klm_mango... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

3. Shell Programming and Scripting

remove consecutive duplicate rows

I have some data that looks like, 1 3300665.mol 3300665 5177008 102.093 2 3300665.mol 3300665 5177008 102.093 3 3294015.mol 3294015 5131552 102.114 4 3294015.mol 3294015 5131552 102.114 5 3293734.mol 3293734 5129625 104.152 6 3293734.mol ... (13 Replies)
Discussion started by: LMHmedchem
13 Replies

4. Shell Programming and Scripting

How to extract duplicate rows

Hi! I have a file as below: line1 line2 line2 line3 line3 line3 line4 line4 line4 line4 I would like to extract duplicate lines (not unique, triplicate or quadruplicate lines). Output will be as below: line2 line2 I would appreciate if anyone can help. Thanks. (4 Replies)
Discussion started by: chromatin
4 Replies

5. Ubuntu

delete duplicate rows with awk files

Hi every body I have some text file with a lots of duplicate rows like this: 165.179.568.197 154.893.836.174 242.473.396.153 165.179.568.197 165.179.568.197 165.179.568.197 154.893.836.174 how can I delete the repeated rows? Thanks Saeideh (2 Replies)
Discussion started by: sashtari
2 Replies

6. Shell Programming and Scripting

awk script to remove duplicate rows in line

i have the long file more than one ns and www and mx in the line like . i need the first ns record and first www and first mx from line . the records are seperated with tthe ; i am try ing in awk scripting not getiing the solution. ... (4 Replies)
Discussion started by: kiranmosarla
4 Replies

7. HP-UX

How to get Duplicate rows in a file

Hi all, I have written one shell script. The output file of this script is having sql output. In that file, I want to extract the rows which are having multiple entries(duplicate rows). For example, the output file will be like the following way. ... (7 Replies)
Discussion started by: raghu.iv85
7 Replies

8. Shell Programming and Scripting

How to extract duplicate rows

I have searched the internet for duplicate row extracting. All I have seen is extracting good rows or eliminating duplicate rows. How do I extract duplicate rows from a flat file in unix. I'm using Korn shell on HP Unix. For.eg. FlatFile.txt ======== 123:456:678 123:456:678 123:456:876... (5 Replies)
Discussion started by: bobbygsk
5 Replies

9. Shell Programming and Scripting

how to delete duplicate rows in a file

I have a file content like below. "0000000","ABLNCYI","BOTH",1049,2058,"XYZ","5711002","","Y","","","","","","","","" "0000000","ABLNCYI","BOTH",1049,2058,"XYZ","5711002","","Y","","","","","","","","" "0000000","ABLNCYI","BOTH",1049,2058,"XYZ","5711002","","Y","","","","","","","",""... (5 Replies)
Discussion started by: vamshikrishnab
5 Replies

10. Shell Programming and Scripting

duplicate rows in a file

hi all can anyone please let me know if there is a way to find out duplicate rows in a file. i have a file that has hundreds of numbers(all in next row). i want to find out the numbers that are repeted in the file. eg. 123434 534 5575 4746767 347624 5575 i want 5575 please help (3 Replies)
Discussion started by: infyanurag
3 Replies
Login or Register to Ask a Question