---------- Post updated at 14:49 ---------- Previous update was at 11:00 ----------
Hi Mani Muthu,
That wasn't shell scripting but an awk script. An equivalent shell script would be look something like this if done in ksh:
awk is powerful and compact language. I used O'Reilly's sed & awk to learn awk (and some practice).
These 2 Users Gave Thanks to Scrutinizer For This Post:
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)
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)
Hi,
I have a file /tmp/1.txt. (Space b/w the fields are not equal)
#cat 1.txt
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:
35G-22G-13G-64%-/mount1... (15 Replies)
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)
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)
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)
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)
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
LEARN ABOUT NETBSD
column
COLUMN(1) BSD General Commands Manual COLUMN(1)NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
column exits 0 on success, >0 if an error occurred.
ENVIRONMENT
COLUMNS The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
(echo "PERM LINKS OWNER GROUP SIZE MONTH DAY HH:MM/YEAR NAME";
ls -l | sed 1d) | column -t
SEE ALSO colrm(1), ls(1), paste(1), sort(1)HISTORY
The column command appeared in 4.3BSD-Reno.
BSD March 9, 2008 BSD