Visit Our UNIX and Linux User Community


Converting vertical items into Horizontal plz


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Converting vertical items into Horizontal plz
# 1  
Old 08-10-2009
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 anybody give me the alternate solution so that it can apply for n no of numbers (ex 10000 numbers) and remove the comman at the end..
as output below
1111,2222,3333,4444


Thanks in advance

Prakash
# 2  
Old 08-10-2009
To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, 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.)

Second, 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.

Third, 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

******************************************************

Not sure if I got the problem; example with GNU sed:
Code:
> cat infile
11111111111111
22222222222222
33333333333333
44444444444444
55555555555555
$> sed -e :a -e '{N; s/\n/,/g; ta}' infile
11111111111111,22222222222222,33333333333333,44444444444444,55555555555555

# 3  
Old 08-10-2009
Quote:
Originally Posted by dprakash
...
can anybody give me the alternate solution so that it can apply for n no of numbers (ex 10000 numbers) and remove the comman at the end..
...
One way of doing it with Perl:

Code:
$
$ cat f1
1111
2222
3333
4444
$
$ perl -ne 'chomp; push @x,$_; END {print join ",", @x; print "\n"}' f1
1111,2222,3333,4444
$
$

tyler_durden
# 4  
Old 08-10-2009
Hi.

For some versions of paste, e.g.paste (GNU coreutils) 6.10:
Code:
paste -d, -s infile

results:
Code:
1111,2222,3333,4444

I did *not* try it with thousands of lines ... cheers, drl

Edit 1:

This *did* work on 10,000 lines ... cheers, drl

Last edited by drl; 08-10-2009 at 12:22 PM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #426
Difficulty: Medium
JavaScript uses prototypes where many other object-oriented languages use classes for inheritance.
True or False?

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 Horizontal items into vertical plz

i have one scenario i want to convert horizontal rows into vertical rows. For eg Input file contains: 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 1001,34.7,43.7,34.99 1002,34,243,34 1003,34,43,34 1004,34,43,34 1005,34,43,34 Here... (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

Featured Tech Videos