To split the columns Post: 302620169

Sponsored Content

Top Forums Shell Programming and Scripting To split the columns Post 302620169 by Scrutinizer on Saturday 7th of April 2012 09:18:01 AM

04-07-2012

Moderator

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... Smilie

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

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

10 More Discussions You Might Find Interesting

1. 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. 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

3. 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...

4. Shell Programming and Scripting

Split columns

5. 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

6. 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

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

8. 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

9. 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

10. 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:...

10 More Discussions You Might Find Interesting

1. Web Development

split the fields in a column into 3 columns

Discussion started by: rakshit

2. Shell Programming and Scripting

split one column into multiple columns

Discussion started by: zaneded

3. UNIX for Dummies Questions & Answers

Split columns

Discussion started by: vanesa1230

4. Shell Programming and Scripting

Split columns

Discussion started by: vanesa1230

5. Programming

Split the columns in Perl scripting

Discussion started by: siva kumar

6. Shell Programming and Scripting

How to split all columns into multiple columns?

Discussion started by: huiyee1

7. Shell Programming and Scripting

Split 5 columns into 3 columns

Discussion started by: cnn

8. Shell Programming and Scripting

Split multi columns line to 2 columns

Discussion started by: jhonnyrip

9. Shell Programming and Scripting

Split columns into rows

Discussion started by: syd

10. UNIX for Beginners Questions & Answers

Using awk to split a column into two columns

Discussion started by: sand1234