06-15-2010
awk '{print $1,$2,$3" -",$6" -",$7,$8,$4,$5}' file.txt column is splitted based based on the space. File.txt is the tab delimited file
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi - can any one let me know how to re-arrange the columns of a comma seperated file. The problem here is that the colums some times have new lines and when the columns has new lines or extra comma's then it is enclosed in double quotes("). Can any one tell me how to re-arrange the columns now.
... (0 Replies)
Discussion started by: ahmedwaseem2000
0 Replies
2. Shell Programming and Scripting
Any idea in awk or sed?
$cat file
a b c
2 4 5 6
output:
a
b
c
2
4
5
6 (3 Replies)
Discussion started by: kenshinhimura
3 Replies
3. Shell Programming and Scripting
Which is the best command(s) to arrange data of a file?
This is my example input file:
Tom ------
apples: 5
oranges: 7
pears: 10
apples: 2
oranges: 8
Jack ------
apples: 3
pears: 10
Lucy ------
oranges: 1
pears: 8
peaches: 9
Tom ------
peaches: 1
Jack ------ (1 Reply)
Discussion started by: csecnarf
1 Replies
4. UNIX for Dummies Questions & Answers
I have a following data:
100 200
300 400
I want the data to be arranged:
100 200 300 400
What is the best way to do this?
Thanks! (5 Replies)
Discussion started by: bobo
5 Replies
5. UNIX for Dummies Questions & Answers
hi friends, m new to unix environment..
i want to know that
"how could we arrange the various files in our unix system according to time at which they are accessed, and are there are ways that we can arrange them in ascending or descending manner..."
please help me out with full details...... (4 Replies)
Discussion started by: adityamitra
4 Replies
6. Shell Programming and Scripting
HI,
I need to arrange values of a colum in row.
e.g.
input file :
Alpha<>123
AAAA<>6754
Beta<>456
BBBB<>63784
CCC<>783
Gama<>789
Alpha<>555
AAAA<>6754
BBBB<>63784
Beta<>666
CCC<>783
Gama<>888 (9 Replies)
Discussion started by: The_Archer
9 Replies
7. Shell Programming and Scripting
I have a directory with files of the form
<name>_rpt_DDMMYY_HH24:00.html
I need to list them by YYMMDD and I need to get the full name back. (1 Reply)
Discussion started by: guessingo
1 Replies
8. Shell Programming and Scripting
I have vary complex issue in unix...i want copy same data in same column...
My Input...
Object SpchAccate hAes hCCS SDop Sroontb NoRabEt SRbuc
ran=C515D (Mod=15) 0 100 98.1 1.9 0.6 ... (7 Replies)
Discussion started by: asavaliya
7 Replies
9. Shell Programming and Scripting
Hi Team,
I have one file in that almost 100+ words in lines
Eg:-
Unix
windows
solaris
Linux
...
...
But I want arrange all lines in table format and can able read on screen
Eg: -
Unix windows solaris Lunix......
Hp unix Mac-os ......
Like as Table...... (11 Replies)
Discussion started by: Bhaskar Alagala
11 Replies
10. Shell Programming and Scripting
Hello All,
I have following data into my file named record.
Name City phone number email
Jhon Newyork 123456987 jhon@gmail.com
Maria Texas 569865612 Maria_Sweet@rediffmail.com
Chan Durben NA Chan123@gmail.com
The output should be in straight columns.. There should not be any... (1 Reply)
Discussion started by: Nakul_sh
1 Replies
LEARN ABOUT MOJAVE
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.
ENVIRONMENT
The COLUMNS, LANG, LC_ALL and LC_CTYPE environment variables affect the execution of column as described in environ(7).
EXIT STATUS
The column utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "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.
BUGS
Input lines are limited to LINE_MAX (2048) bytes in length.
BSD
July 29, 2004 BSD