How to add a new line between different column data content?

Login or Register to Ask a Question and Join Our Community

How to add a new line between different column data content?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to add a new line between different column data content?

12-10-2009

Registered User

242, 1

Join Date: Sep 2009

Last Activity: 24 August 2018, 1:52 AM EDT

Posts: 242

Thanks Given: 27

Thanked 1 Time in 1 Post

How to add a new line between different column data content?

Input file:

Code:

Germany 10 500 5000
Germany 20 500 5000
Germany 50 10 500
England 5 10 25
USA 30 25 55
USA 20 35 90
Japan 2 5 60
Singapore 50 30 90
Singapore 150 230 290

Output file:

Code:

Germany 10 500 5000
Germany 20 500 5000
Germany 50 10 500

England 5 10 25

USA 30 25 55
USA 20 35 90

Japan 2 5 60

Singapore 50 30 90
Singapore 150 230 290

I plan to add new line between different column data content based on column 1 data similarity. As I know,"\n" able to add new line. Unfortunately I can't add new line based on the column 1 data similarity to determine it

Thanks a lot for sharing.

patrick87

View Public Profile for patrick87

Find all posts by patrick87

12-10-2009

Registered User

40, 0

Join Date: Nov 2009

Last Activity: 24 May 2010, 8:43 AM EDT

Posts: 40

Thanks Given: 0

Thanked 0 Times in 0 Posts

Code:

while read line; do
	current=$(echo $line | awk '{print $1}')
	[ "$current" != "$check" ] && echo ""
	echo $line
	check=$current
done < your_file

momo.reina

View Public Profile for momo.reina

Find all posts by momo.reina

12-10-2009

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

Alternatively awk, (works the same):

Code:

awk 'p!=$1&&NR>1{p=$1;printf "\n"}1' infile

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

12-10-2009

Registered User

242, 1

Join Date: Sep 2009

Last Activity: 24 August 2018, 1:52 AM EDT

Posts: 242

Thanks Given: 27

Thanked 1 Time in 1 Post

Thanks momo.reina.
Your code worked perfectly and solved my problem

Thanks a lot.

---------- Post updated at 02:21 AM ---------- Previous update was at 02:19 AM ----------

Hi Scrutinizer,
Your awk code worked perfectly and very fast to solve my problem.
Thanks a lot for your sharing ^^

patrick87

View Public Profile for patrick87

Find all posts by patrick87

12-10-2009

Registered User

7,747, 559

Join Date: Feb 2007

Last Activity: 20 April 2020, 11:28 AM EDT

Location: The Netherlands

Posts: 7,747

Thanks Given: 139

Thanked 559 Times in 520 Posts

Quote:

Originally Posted by Scrutinizer

Alternatively awk, (works the same):

Code:

awk 'p!=$1&&NR>1{p=$1;printf "\n"}1' infile

Scrutinizer,

Your command above gives an empty line after the first line, try this:

Code:

awk 'NR==1{s=$1}NR>1 && s!=$1{print "";s=$1}1'  file

Franklin52

View Public Profile for Franklin52

Find all posts by Franklin52

12-10-2009

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

Quote:

Originally Posted by Franklin52

Scrutinizer,

Your command above gives an empty line after the first line, try this:

Code:

awk 'NR==1{s=$1}NR>1 && s!=$1{print "";s=$1}1'  file

Thanks , and then we can leave out the NR>1 test
Code:
awk 'NR==1{s=$1}s!=$1{print "";s=$1}1'

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

12-10-2009

Registered User

871, 12

Join Date: Feb 2007

Last Activity: 12 January 2020, 6:30 AM EST

Location: Singapore/Cochin

Posts: 871

Thanks Given: 0

Thanked 12 Times in 11 Posts

Another one, with asso.array in awk

Code:

awk ' { if((++A[$1]==1)&&NR>1) { print "\n"$0;}else { print} }' file

dennis.jacob

View Public Profile for dennis.jacob

Find all posts by dennis.jacob

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to add a column of another data from another column?

Hola Como hacer: C:\System\SystemRun.4gl C:\System\SystemRunPrint.4gl C:\System\SystemViews.4gl Resultado: SystemRun.4gl C:\System\SystemRun.4gl SystemRunPrint.4gl C:\System\SystemRunPrint.4gl SystemViews.4gl C:\System\SystemViews.4gl...

2. Shell Programming and Scripting

Break a line content and print as column

Hi, I have urls in my input file like this

3. Shell Programming and Scripting

Add Column base on other Column Data

HI Guys, I want add one extra Column base on 3rd Column . Input :- M204 MS204_154 :vsDataUeMe M204 MS204_154 es:sMeasure 0 M204 MS204_154 es:90ilterCoe 9 M204 MS204_154 es:searchE9090ortTime 40 M204 MS204_154 es:servOrPrioI90HoTimer 4000 M204 MS204_154 es:ueMeajllls154545 TRUE...

4. Shell Programming and Scripting

Insert data in first column(if blank) from previous line first column

Dear Team I need to insert field(which is need to taken from previous line's first field) in first column if its blank. I had tried using sed but not find the way. Detail input and output file as below. Kindly help for same. INPUT: SCGR SC DEV DEV1 NUMDEV DCP ...

5. Shell Programming and Scripting

Help to print the line that share exactly same with column one content

Input file : AAAG TC AACCCT AACCCT AACCCT AACCCT TCTG TCTG TCTG AC AC TCTG TCTG AC AC AC AC AC AGTG AC AGTG TCC Desired output file : AACCCT AACCCT AACCCT AACCCT AC AC I would like to print out the line that share exactly same as the first column data content. Column one data...

6. Shell Programming and Scripting

Break a line content and print as column

Hi, I have urls in my input file like this http://unix.com/abc/def http://unix.com/kil/min I want to use the / as separator and print the last content as another column like this http://unix.com/abc/def def http://unix.com/kil/min min I was using awk -F option and then joining the...

7. Shell Programming and Scripting

Column content match and add suffix

My input chr3 galGal3_xenoRefFlat CDS 4178235 4178264 0.000000 + 0 gene_id "T6J4.19; T6J4_19"; transcript_id "T6J4.19; T6J4_19"; chr3 galGal3_xenoRefFlat exon 4178235 4178264 0.000000 + . gene_id "T6J4.19; T6J4_19"; transcript_id "T6J4.19;...

8. Shell Programming and Scripting

Help with analysis data based on particular column content

Input file: Total_counts 1306726155 100% Number_of_count_true 855020282 Number_of_count_true_1 160014283 Number_of_count_true_2 44002825 Number_of_count_true_3 18098424 Number_of_count_true_4 24693745 Number_of_count_false 115421870 Number_of_count_true 51048447 Total_number_of_false ...

9. Shell Programming and Scripting

Help with add new line in between each content

Input file: 48458951 49529947 46700865 46207063 52639785 47012578 55872838 49258996 Desired output file: 48458951 49529947 46700865 46207063

10. Shell Programming and Scripting

column data to rows every n line

Hi every one, I am trying to organise an input text file like: input 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 into an output as following: output file 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Login or Register to Ask a Question