Visit Our UNIX and Linux User Community


Concatenating column values with unique id into single row


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Concatenating column values with unique id into single row
# 8  
Old 08-18-2009
Hi

This works fine. But there is more space between the words
K_25_5 Analysis ,
Coding , Post deli
very phase
DU0182_17_42 P05 ,
P06 , P07
, P08
, Post delivery phase
# 9  
Old 08-18-2009
Quote:
Originally Posted by jsaravana
This works fine. But there is more space between the words
To keep the forums high quality for all users, please take the time to format your posts correctly.
  1. Use Code Tags when you post any code or data samples so others can easily read your code.
    You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)
  2. Avoid adding color or different fonts and font size to your posts.
    Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.
  3. Be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums
Reply With Quote
# 10  
Old 08-18-2009
Thanks for the advice Danmero.. I will surely follow it in future.

I see that you have edited the code posted. But that again gives me the output with space issues. Where exactly was the code changed. When I compared both codes I was not able to find the change.

---------- Post updated at 03:55 AM ---------- Previous update was at 03:52 AM ----------

Code:
KU0506_25_7          Analysis                                                                                            ,
      Coding                                                                                              ,         Post deli
very phase
DU0182_17_44         Post delivery phase                                                                                 ,
     P05                                                                                                 ,        P06

This is how output looks. Used # this time Smilie
# 11  
Old 08-20-2009
Hi

I was not able to solve the space issue could you please help
# 12  
Old 08-20-2009
Quote:
Originally Posted by jsaravana
This is how output looks. Used # this time Smilie
We need both , input sample and output required to be able to find a solution.
# 13  
Old 08-20-2009
Quote:
Originally Posted by danmero
We need both , input sample and output required to be able to find a solution.
Please find the sample below
Code:
ID               PHASE
-------------------------------------------
D1_5_18          IM propagation and review
D1_5_18          System Testing - Process
D1_5_18          System Test - Process
D1_5_18          IPS Module Build/Packaging
D1_5_18          Implementation
D1_5_18          PVT Regression 
D1_5_18          Post delivery phase
D1_5_18          MTP
D1_5_18          HLTD
D1_5_18          Detailed Design
D1_5_18          IPTA
D1_5_18          SIT Test Cases
D1_5_18          Test Environment Support
D1_5_18          Coding
D1_5_18          Unit Test Case Preperation
D1_5_18          Code testing & delivery

The required output is
Code:
del_id       phase
D1_5_18   IM propagation and review,System Testing - Process,System Test - Process,IPS Module Build/Packaging,Implementation,PVT Regression,Post delivery phase,MTP,HLTD,Detailed Design,IPTA,SIT Test Cases,Test Environment Support,Coding,Unit Test Case Preperation,Code testing & delivery

# 14  
Old 08-20-2009
Reuse the code of Tytalus with a little modification:
Code:
awk -F "          " '{t[$1]?t[$1]=t[$1]","$2:t[$1]=$2}END{for (i in t){print i,t[i]}}'  yourfile.txt


Previous Thread | Next Thread
Test Your Knowledge in Computers #386
Difficulty: Medium
The Linux telnet command provides a user interface to a remote system using the SSH protocol.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Find unique values but only in column 1

Hi All, Does anyone have any suggestions/examples of how i could show only lines where the first field is not duplicated. If the first field is listed more than once it shouldnt be shown even if the other columns make it unique. Example file : 876,RIBDA,EC2 876,RIBDH,EX7 877,RIBDF,E28... (4 Replies)
Discussion started by: mutley2202
4 Replies

2. Shell Programming and Scripting

Bring values in the second column into single line (comma sep) for uniq value in the first column

I want to bring values in the second column into single line for uniq value in the first column. My input jvm01, Web 2.0 Feature Pack Library jvm01, IBM WebSphere JAX-RS jvm01, Custom01 Shared Library jvm02, Web 2.0 Feature Pack Library jvm02, IBM WebSphere JAX-RS jvm03, Web 2.0 Feature... (10 Replies)
Discussion started by: kchinnam
10 Replies

3. Shell Programming and Scripting

awk to filter out lines containing unique values in a specified column

Hi, I have multiple files that each contain four columns of strings: File1: Code: 123 abc gfh 273 456 ddff jfh 837 789 ghi u4u 395 File2: Code: 123 abc dd fu 456 def 457 nd 891 384 djh 783 I want to compare the strings in Column 1 of File 1 with each other file and Print in... (3 Replies)
Discussion started by: owwow14
3 Replies

4. UNIX for Dummies Questions & Answers

Unique values in a row sum the next column in UNIX

Hi would like to ask you guys any advise regarding my problem I have this kind of data file.txt 111111111,20 111111111,50 222222222,70 333333333,40 444444444,10 444444444,20 I need to get this file1.txt 111111111,70 222222222,70 333333333,40 444444444,30 using this code I can... (6 Replies)
Discussion started by: reks
6 Replies

5. Shell Programming and Scripting

Print every 5 4th column values as separate row with different first column

Hi, I have the following file, chr1 100 200 20 chr1 201 300 22 chr1 220 345 23 chr1 230 456 33.5 chr1 243 567 90 chr1 345 600 20 chr1 430 619 21.78 chr1 870 910 112.3 chr1 914 920 12 chr1 930 999 13 My output would be peak1 20 22 23 33.5 90 peak2 20 21.78 112.3 12 13 Here the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

6. 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

7. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

8. Shell Programming and Scripting

duplicate row based on single column

I am a newbie to shell scripting .. I have a .csv file. It has 1000 some rows and about 7 columns... but before I insert this data to a table I have to parse it and clean it ..basing on the value of the first column..which a string of phone number type... example below.. column 1 ... (2 Replies)
Discussion started by: mitr
2 Replies

9. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Discussion started by: amigarus
6 Replies

10. Shell Programming and Scripting

Converting Column values to comma delimted single Row

I have a requirement in which i have to read a file which has multiple columns seperated by a pipe "|" from this i have to read each column values seperately and create a comma seperated row for the column and write to another file. eg: Input file: ColA ColB 1 2 2 x 3 y... (5 Replies)
Discussion started by: nvuradi
5 Replies

Featured Tech Videos