Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Converting Horizontal items into vertical plz

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Converting Horizontal items into vertical plz
# 1  
Old 08-03-2009
Converting Horizontal items into vertical plz
i have one scenario
i want to convert horizontal rows into vertical rows.
For eg
Input file contains:
Code:
1001,34.7,43.7,34.99|1002,34,243,34|1003,34,43,34|1004,34,43,34|1005,34,43,34

Output file contains
Code:
1001,34.7,43.7,34.99
1002,34,243,34
1003,34,43,34
1004,34,43,34
1005,34,43,34

Here 1001 is a item with diff prices 34.7,43.7 and 34.99
so i want each item in diff rows as above
Please solve for me asap
Thanks
Prakash
Last edited by Yogesh Sawant; 08-03-2009 at 09:59 AM.. Reason: added code tags
# 2  
Old 08-03-2009
Code:
tr '|' '\n'

# 3  
Old 08-03-2009
using Perl:
Code:
perl -pi -e 's/\|/\n/g' newfile.txt

# 4  
Old 08-05-2009
Code:
awk -F"|" '{$1=$1}1' OFS="\n" file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Print vertical to horizontal

Hi Masters, I need help to change my vertical data to horisontal input 2015-04-13|JS|741667 2015-04-13|JSJ|2272 2015-04-13|TMS|107099 2015-04-12|JMD|47945 2015-04-13|TM|760024 2015-04-13|JM|484508 2015-04-14|JMJ|318 2015-04-14|JSD|54436 2015-04-13|JM|15410 Output... (2 Replies)
Discussion started by: radius
2 Replies

2. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

I need to change data from vertical to horizontal but with condition input USA|80 AUS|40 BRA|33 VEGAS|40 KENTUCKY|50 NEWYORK|21 DARWIN|33 ADELAIDE|21 SAOPAOLO|44 RIO|89 GAPIZA|44 BENFLEX|32 AXIS|44 ACRE|56 HEIGHT|22 (5 Replies)
Discussion started by: radius
5 Replies

3. Shell Programming and Scripting

Help! output format from vertical to horizontal

Hi All, please help to achieve the desired output Example: I have a file which contains the below data empname robert empid 787 design consultant empname alex empid 898 design advocate Desired output should be empname empid design robert 787 consultant (19 Replies)
Discussion started by: rocky2013
19 Replies

4. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies

5. Shell Programming and Scripting

Vertical And Horizontal Pivoting

Hi All, My Input data is: A=1 B=2 My desired Output should be: A|B 1|2 Thanks in advance... (3 Replies)
Discussion started by: kmsekhar
3 Replies

6. UNIX for Dummies Questions & Answers

vertical to horizontal

dear all, i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2. example text : Data DATE XXXXX MAX 47 53 49 51 48 48 7 46 51 8 25 (6 Replies)
Discussion started by: andrisetia
6 Replies

7. UNIX for Dummies Questions & Answers

Horizontal to vertical

Hi, Silly question, if I have an excel file that looks something like this: ................. Subject 1 Subject 2 Subject 3 Subject 4 Fever..............13...........9.............23..........14 Headache.........2............12...........18..........23... (3 Replies)
Discussion started by: Xterra
3 Replies

8. Shell Programming and Scripting

combine files in horizontal way, not vertical.

Hi Everyone, I have three files. FileA: aaaa aaaa bb ccc FileB: 21 2 FileC: eeeeeee e eee ee Would like to combine three of them, not like cat, to cat three files, but the output should be like: (3 Replies)
Discussion started by: jimmy_y
3 Replies

9. Shell Programming and Scripting

Converting vertical items into Horizontal plz

Hi all im able to convert vertical into horizontal as follows using tr '\n' ',' to convert 1111 2222 3333 4444 as to 1111,2222,3333,4444, but im getting comma at end.. i want to remove the comma at end.. using sed we can do.... but it is limited to some numbers only... can... (3 Replies)
Discussion started by: dprakash
3 Replies

10. UNIX for Dummies Questions & Answers

converting horizontal line to vertical line

how to use "tr" command to display horizontal line to vertical line for vertical to horizontal, the command is tr '\n' '\t' <inputfile but what is the command for horizontal to vertical Thanks Vasikaran (3 Replies)
Discussion started by: vasikaran
3 Replies
Login or Register to Ask a Question