Skip to main content
Unix & Linux

Return to Question

fix a typo and grammar
Source Link
edit approved Oct 20, 2015 at 0:31
Thomas Dickey
edit approved Oct 20, 2015 at 0:31
Thomas Dickey
  • 79.3k
  • 9
  • 189
  • 290

Merge duplicated lines which have the same fistfirst three filedfields

I have the below input (thousanda thousand lines). I want a sed command to merge duplicated lines with the same fistfirst three filed but addsfields which adds only different fields and delete Nor deletes "N/AA":

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);N/A;SM-1-1 LE040A;1;363;(27.4);N/A;SM-1-2

Expected output:

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);(27.4);SM-1-1/SM-1-2

Merge duplicated lines which have the same fist three filed

I have the below input (thousand lines). I want a sed command to merge duplicated lines with the same fist three filed but adds only different fields and delete N/A:

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);N/A;SM-1-1 LE040A;1;363;(27.4);N/A;SM-1-2

Expected output:

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);(27.4);SM-1-1/SM-1-2

Merge duplicated lines which have the same first three fields

I have the below input (a thousand lines). I want a sed command to merge duplicated lines with the same first three fields which adds only different fields or deletes "N/A":

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);N/A;SM-1-1 LE040A;1;363;(27.4);N/A;SM-1-2

Expected output:

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);(27.4);SM-1-1/SM-1-2
deleted 3 characters in body; edited tags
Source Link
cuonglm
cuonglm
  • 158.2k
  • 41
  • 342
  • 420

I have the below input (thousand lines). I want a SEDsed command to merge duplicated lines with the same fist three filed but adds only different fields and delete N/A:

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);N/A;SM-1-1 LE040A;1;363;(27.4);N/A;SM-1-2 OUTPUT

Expected output:

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);(27.4);SM-1-1/SM-1-2

I have the below input (thousand lines). I want a SED command to merge duplicated lines with the same fist three filed but adds only different fields and delete N/A

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);N/A;SM-1-1 LE040A;1;363;(27.4);N/A;SM-1-2 OUTPUT  D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);(27.4);SM-1-1/SM-1-2

I have the below input (thousand lines). I want a sed command to merge duplicated lines with the same fist three filed but adds only different fields and delete N/A:

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);N/A;SM-1-1 LE040A;1;363;(27.4);N/A;SM-1-2

Expected output:

D04005;4;279;0;0;SSM-4-1 D04005;5;40;0;0;SSM-5-1 LE040A;1;363;(26.3);(27.4);SM-1-1/SM-1-2
edited tags
Link
Tony
Tony
  • 91
  • 6
Source Link
Tony
Tony
  • 91
  • 6