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
# 8  
Old 04-07-2012
Quote:
Originally Posted by thomasraj87
Hi huaihaizi3,

Same error.

# sed -r 's/ +/-/g' /tmp/2.txt
sed: illegal option -- r
#
-r is gnu sed only!
try
Code:
awk '{gsub(" ","-")}1' infile

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

try it with tr instead:

Code:
tr -s ' ' '-' < /tmp/1.txt

This User Gave Thanks to keb0x80 For This Post:
thomasraj87
# 10  
Old 04-07-2012
keb0x80,

Code:
tr -s ' ' '-' < /tmp/1.txt is working thanks.

huaihaizi3,

Code:
sed 's# \{1,\}#-#g' /tmp/1.txt  is working thanks.

Getting error for this awk.

Code:
# awk '{gsub(" ","-")}1' /tmp/1.txt

Code:
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: bailing out near line 1

#

keb0x80 & huaihaizi3... heartly thanks a lot to both of u..Smilie

Moderator's Comments:
Mod Comment Please use code tags. Video tutorial on how to use them
Last edited by Scrutinizer; 04-07-2012 at 10:15 AM..
# 11  
Old 04-07-2012
Quote:
Originally Posted by keb0x80
Hi thomasraj87, [..]
Code:
sed -E 's/ +/-/g' /tmp/1.txt

Note: sed -E is BSD sed only..
# 12  
Old 04-07-2012
Quote:
Originally Posted by thomasraj87
Getting error for this awk.

# awk '{gsub(" ","-")}1' /tmp/1.txt
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: bailing out near line 1
It's really hard to give a complete POSIX portable solution as CentOS 6.2 is my primary platform...SmilieSmilieSmilie

---------- Post updated at 08:17 AM ---------- Previous update was at 08:14 AM ----------

Quote:
Originally Posted by Scrutinizer
Note: sed -E is BSD sed only..
sed -E is also gnu sed available!
# 13  
Old 04-07-2012
Quote:
Originally Posted by thomasraj87
keb0x80,
[..]

Getting error for this awk.

Code:
# awk '{gsub(" ","-")}1' /tmp/1.txt

Code:
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: bailing out near line 1

#
On Solaris, use /usr/xpg4/bin/awk instead of awk (and /usr/xpg4/bin/sed instead of sed, and /usr/xpg4/bin/sh instead of sh ... etc...)

--------------

Quote:
Originally Posted by huaihaizi3
It's really hard to give a complete POSIX portable solution as CentOS 6.2 is my primary platform...SmilieSmilieSmilie
Try the --posix options in GNU utilities (also for bash, or call it as /bin/sh, it is not 100%, but is better then nothing. Alternatively use dash instead of bash for testing)..

Quote:
Originally Posted by huaihaizi3
[..]
sed -E is also gnu sed available!
Do you mean the equivalent -r option ? I don't know of a -E option in GNU sed..
Last edited by Scrutinizer; 04-07-2012 at 10:35 AM..
# 14  
Old 04-07-2012
Another one:
Code:
awk '$1=$1' OFS=- infile
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