Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Rows to columns with first field constant

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Rows to columns with first field constant
# 1  
Old 07-17-2014
Debian Rows to columns with first field constant
Hi Friends,

I have tried many options to convert rows to column in below fashion. Can you help me pls?

input file:

Code:
kamal|1,2,3|4,5,6|7,8,9
mich|4,7,4|6,7,9
jose|1,1,2|3,3,2|5,5,0

output required:

Code:
kamal|1,2,3
kamal|4,5,6
kamal|7,8,9
mich|4,7,4
mich|6,7,9
jose|1,1,2
jose|3,3,2
jose|5,5,0


Thanks,
Suresh
Last edited by Scrutinizer; 07-17-2014 at 05:29 AM.. Reason: CODE Tags
# 2  
Old 07-17-2014
Hi, try:
Code:
 awk -v FS="|" -v OFS="|" '{for (i=2;i<=NF;i++){print $1,$i}}' input_file

Regards.
# 3  
Old 07-17-2014
Thank You so much.. It is working
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Rows to columns

trying to sort an array, only the 4th column is uniq, have this: dog cat bird house1 dog cat bird house2 dog cat bird house3 rose daisy tulip house1 rose daisy tulip house3 would like this: dog cat bird house1 house2 house3 rose daisy tulip house1 missing house3 any help... (6 Replies)
Discussion started by: jimmyf
6 Replies

2. Shell Programming and Scripting

Pivot Rows to Columns, with field separator

Hi All, I have a requirement to flatten data out, based on the value in COL_2. Our file is pipe delimited, however COL_2 contains a comma separated string, which we would like to pivot out from one row into multiple rows. Please see my example input data below: Input Data ... (4 Replies)
Discussion started by: RichZR
4 Replies

3. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

4. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies

5. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

6. Shell Programming and Scripting

rows to columns

Hi Friends, I have a input file as below. how to convert rows to columns? Friday:recharge 3861140 Monday:recharge 4036228 Saturday:recharge 3996376 Sunday:recharge 3777749 Thursday:recharge 3858537 Tuesday:recharge 4047045 Wednesday:recharge 3954798 desinred output Sunday ... (3 Replies)
Discussion started by: suresh3566
3 Replies

7. Shell Programming and Scripting

how I can add a constant to a field without changing the file format

Hi, I need to edit a file Protein Data Bank (pdb) and then open that file with the program VMD but when I edit the file with awk, it changes pdb format and the VMD program can not read it. I need to subtract 34 to field 6 ($ 6). this is a pdb file : ATOM 918 N GLY B 103 -11.855 8.675... (8 Replies)
Discussion started by: bio_
8 Replies
Login or Register to Ask a Question