Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

To split the columns

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting To split the columns
# 1  
Old 04-07-2012
To split the columns
Hi,
I have a file /tmp/1.txt. (Space b/w the fields are not equal)

#cat 1.txt
Code:
35G 22G 13G 64% /mount1
15G 7.1G 7.5G 49% /mount2
2G   9.9G 4.7G 68% /mount3
15G 9.1G   5G 63% /mount4

i want to wite a script to display these values as below.

O/P:

Code:
35G-22G-13G-64%-/mount1
15G-7.1G-.5G-49%-/mount2
2G-9.9G-4.7G-68%-/mount3
15G-9.1G-5G-63%-/mount4

I am not able to get the expected o/p. because Space b/w the fields are not equal. Anyone pls help me..

Moderator's Comments:
Mod Comment Please use code tags. Video tutorial on how to use them
Last edited by Scrutinizer; 04-07-2012 at 09:59 AM..
# 2  
Old 04-07-2012
Code:
echo "35G 22G 13G 64% /mount1
15G 7.1G 7.5G 49% /mount2
2G 9.9G 4.7G 68% /mount3
15G 9.1G 5G 63% /mount4
" | sed 's/ \+/-/g'
35G-22G-13G-64%-/mount1
15G-7.1G-7.5G-49%-/mount2
2G-9.9G-4.7G-68%-/mount3
15G-9.1G-5G-63%-/mount4

# 3  
Old 04-07-2012
Hi thomasraj87,

You could use the following sed command:

Code:
sed -E 's/ +/-/g' /tmp/1.txt

Moderator's Comments:
Mod Comment Welcome to the UNIX and Linux Forums. Please use code tags. Video tutorial on how to use them
Last edited by Scrutinizer; 04-07-2012 at 10:12 AM..
# 4  
Old 04-07-2012
Hi keb0x80,
It shows the error.

Code:
# sed -E 's/ +/-/g' /tmp/1.txt
sed: illegal option -- E
#

---------- Post updated at 05:59 PM ---------- Previous update was at 05:57 PM ----------

Hi Skrynesaver,

I am getting the o/p like this. (Columns splitted with single space & all the datas are in same line)

Code:
# echo `cat /tmp/2.txt`| sed 's/ \+/-/g'
35G 22G 13G 64% /mount1 15G 7.1G 7.5G 49% /mount2 2G 9.9G 4.7G 68% /mount3 15G 9.1G 5G 63% /mount4
#

Last edited by Scrutinizer; 04-07-2012 at 11:07 AM..
# 5  
Old 04-07-2012
thomasraj87,

Try the '-r' option instead of '-E'
# 6  
Old 04-07-2012
Code:
sed 's# \{1,\}#-#g' infile

This User Gave Thanks to complex.invoke For This Post:
thomasraj87
# 7  
Old 04-07-2012
Hi huaihaizi3,

Same error.

# sed -r 's/ +/-/g' /tmp/2.txt
sed: illegal option -- r
#
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Using awk to split a column into two columns

Hi, I am trying to split the following output into two columns, where each column has Source: Destination: OUTPUT TO FILTER $ tshark -r Capture_without_mtr.pcap -V | awk '/ (Source|Destination): /' | more Source: x.x.x.x Destination: x.x.x.x Source:... (2 Replies)
Discussion started by: sand1234
2 Replies

2. Shell Programming and Scripting

Split columns into rows

Any one can help me in converting columns into rows. example I have input file 10000| 10002| 10003| 10004| 10005| I want output in below format PARTY|PART_DT 10000|12080000000 10002|13075200000 10003|13939200000 10004|1347200000 10004|133600000 10004|1152000000 (13 Replies)
Discussion started by: syd
13 Replies

3. Shell Programming and Scripting

Split multi columns line to 2 columns

I have data like this 1 a,b,c 2 a,c 3 b,d 4 e,f would like convert like this 1 a 1 b 1 c 2 a 2 c 3 b 3 d 4 e 4 f Please help me out (4 Replies)
Discussion started by: jhonnyrip
4 Replies

4. Shell Programming and Scripting

Split 5 columns into 3 columns

I have a big data set as follows 8.519 8.601 8.833 9.183 9.602 1.003 1.041 1.070 1.085 1.084 1.06 1.034 9.879 9.307 8.66 I simply want this to arrange like this 8.519 8.601 8.833 9.183 9.602 1.003 1.041 1.070 1.085 1.084 1.06 1.034 9.879 9.307 8.66 ... (2 Replies)
Discussion started by: cnn
2 Replies

5. Shell Programming and Scripting

How to split all columns into multiple columns?

Hi, all. How can I split all columns into multiple columns separated by tab? Input: qq ee TT 12 m1 aa gg GG 34 2u zz dd hh 56 4h ww cc JJ 78 5y ss ff kk 90 j8 xx pp mm 13 p0 Output: q q e e T T 1 2 m 1 a a g g G G 3 4 2 u z z d d h h 5 6 4 h w w c c J J 7 8 5 y (8 Replies)
Discussion started by: huiyee1
8 Replies

6. Programming

Split the columns in Perl scripting

hi all, i have a file like thsi a 1 3;4 b 2 4;7 c 4 5;6 d 4 5;8 now i want 1st, 2nd and in 3rd column i want only 1st column the output should be like below a 1 3 b 2 4 c 4 5 d 4 5 I need it in perl; please dont write in Shell scripting (1 Reply)
Discussion started by: siva kumar
1 Replies

7. Shell Programming and Scripting

Split columns

Greetings, I have an input file with two columns. The first column has different codes. Each time I have a new code I need to split the columns into new ones. The input file looks like this CR124 1320 CR124 1138 CR124 682 CR124 629 CR124 592 CR124 580 CR124 537 CR161 3967 CR161 3656... (6 Replies)
Discussion started by: vanesa1230
6 Replies

8. UNIX for Dummies Questions & Answers

Split columns

Greetings, I have an input file with two columns. The first column has different codes. Each time I have a new code I need to split the columns into new ones. The input file looks like this CR124 1320 CR124 1138 CR124 682 CR124 629 CR124 592 CR124 580 CR124 537 CR161 3967... (2 Replies)
Discussion started by: vanesa1230
2 Replies

9. Shell Programming and Scripting

split one column into multiple columns

hey, i have the following data: 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 (7 Replies)
Discussion started by: zaneded
7 Replies

10. Web Development

split the fields in a column into 3 columns

Have a column "address" which is combination of city, region and postal code like. Format is : city<comma><space>region<space>postal code abc, xyz 123456 All these three city, region and postal code are not mandatory. There can be any one of the above. In that case a nell... (2 Replies)
Discussion started by: rakshit
2 Replies
Login or Register to Ask a Question