Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

re arrange the columns

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting re arrange the columns
# 1  
Old 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.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell scripting - need to arrange the columns from multiple file into a single file

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

2. Shell Programming and Scripting

how to arrange datas in columns in shell script.

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

3. Shell Programming and Scripting

sorting when i need to re-arrange

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

4. Shell Programming and Scripting

arrange files into columns

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

5. Shell Programming and Scripting

Arrange output based on rows into columns

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

6. Shell Programming and Scripting

Re-arrange column

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

7. UNIX for Dummies Questions & Answers

Arrange data

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

8. Shell Programming and Scripting

gawk - reading two files & re arrange the columns

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

9. Shell Programming and Scripting

re arrange data

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

10. Shell Programming and Scripting

Arrange date in a field

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
Login or Register to Ask a Question

LEARN ABOUT NETBSD

cut

CUT(1)							    BSD General Commands Manual 						    CUT(1)

NAME

     cut -- select portions of each line of a file

SYNOPSIS

     cut -b list [-n] [file ...]
     cut -c list [file ...]
     cut -f list [-d delim] [-s] [file ...]

DESCRIPTION

     The cut utility selects portions of each line (as specified by list) from each file and writes them to the standard output.  If the file
     argument is a single dash ('-') or no file arguments were specified, lines are read from the standard input.  The items specified by list can
     be in terms of column position or in terms of fields delimited by a special character.  Column numbering starts from 1.

     list is a comma or whitespace separated set of increasing numbers and/or number ranges.  Number ranges consist of a number, a dash (-), and a
     second number and select the fields or columns from the first number to the second, inclusive.  Numbers or number ranges may be preceded by a
     dash, which selects all fields or columns from 1 to the first number.  Numbers or number ranges may be followed by a dash, which selects all
     fields or columns from the last number to the end of the line.  Numbers and number ranges may be repeated, overlapping, and in any order.	It
     is not an error to select fields or columns not present in the input line.

     The options are as follows:

     -b list	 The list specifies byte positions.

     -c list	 The list specifies character positions.

     -d string	 Use the first character of string as the field delimiter character.  The default is the <TAB> character.

     -f list	 The list specifies fields, separated by the field delimiter character.  The selected fields are output, separated by the field
		 delimiter character.

     -n 	 Do not split multi-byte characters.

     -s 	 Suppresses lines with no field delimiter characters.  Unless specified, lines with no delimiters are passed through unmodified.

EXIT STATUS

     cut exits 0 on success, 1 if an error occurred.

SEE ALSO

     paste(1)

STANDARDS

     The cut utility conforms to IEEE Std 1003.2-1992 (``POSIX.2'').

BSD
								 December 21, 2008							       BSD