09-23-2005
re arrange the columns
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.
Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
If I have a flat file
ID|Location|Date|Hostname|Age|Sex
1|SFO|06/02/24 12:12:34|hawkeye|35|M
2|LAX|06/02/24 13:12:35|sf49ers|30|M
3|OAK|06/02/25 11:12:36|goraiders|27|F
4|PIT|06/02/25 12:12:37|steeler|35|M
How can I create an output
1|SFO|02/24/2006 12:12:34|hawkeye|35|M... (6 Replies)
Discussion started by: sabercats
6 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
Hi,
I am trying to read 2 files and writing to the 3rd file if I find the same elements in 2 files. my first file is
1 0 kb12124819 766409 1.586e-01
1 0 kb17160939 773886 8.674e-01
1 0 kb4475691 836671 8.142e-01
1 0 ... (2 Replies)
Discussion started by: ezhil01
2 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. Shell Programming and Scripting
10.142.7.155 - - www.abc.com 404 -
I have many columns which is tab delimited file, I have to re-arrange this to a particular column and also add "-" to 3rd column and 6th column.
10.142.7.155 - - - www.abc.com - 404 - (4 Replies)
Discussion started by: sandy1028
4 Replies
6. Shell Programming and Scripting
Hi All,
I would like to ask help on how can i achieve below output.
Inputfile:
Oct11,apa1-daily,01:25:01
Oct11,apa2-daily,01:45:23
Oct12,apa1-daily,02:30:11
Oct12,apa2-daily,01:55:01
Oct13,apa1-off,01:43:34
Oct13,apa2-off,01:22:04
Desired output:
Clients ... (3 Replies)
Discussion started by: mars101
3 Replies
7. Shell Programming and Scripting
Hi may i ask how to arrange this file in into columns like example below
Problem:
#cat data.txt
1
2
3
4
5
a
b
c
d
9
8
7
6
desired output (9 Replies)
Discussion started by: jao_madn
9 Replies
8. 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
9. Shell Programming and Scripting
Hello All,
I have datas in the below format.
Mark 45
Steve 60
Johnson 79
Elizabeth 90
My requirement is to arrange the data in the order as shown in the attachment.
My OS is Solaris.
... (6 Replies)
Discussion started by: vashece
6 Replies
10. Shell Programming and Scripting
Hi friends
please help me on below,
i have 5 files like below
file1 is
x 10
y 20
z 15
file2 is
x 100
z 245
file3 is
y 78
z 23
file4 is
x 100 (3 Replies)
Discussion started by: siva kumar
3 Replies
LEARN ABOUT REDHAT
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
(printf "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
June 6, 1993 BSD