Sort data from column to row Post: 302597579

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Move data from Column to Row

Hi all, I have a file with several columns of data, eg: A B C D 1 2 5 1 2 2 2 2 8 4 4 4 4 2 3 4 10 9 4 4 9 7 1 2 I need to get the values from, say, column B and place them into a string separated by a semicolon, eg: 2;2;4;2;9;7 Does...

2. Shell Programming and Scripting

Convert row data to column data

Hi Guys, I have a file as follows: a 1 b 786 c 90709 d 99 a 9875 b 989 c 887 d 111 I want: a 1 9875 b 786 989

3. Shell Programming and Scripting

row to column and position data in to fixed column width

Dear friends, Below is my program and current output. I wish to have 3 or 4 column output in order to accomodate in single page. i do have subsequent command to process after user enter the number. Program COUNT=1 for MYDIR in `ls /` do VOBS=${MYDIR} echo "${COUNT}. ${MYDIR}" ...

4. Shell Programming and Scripting

Moving data from a specified column/row to another column/row

Hello, I have an input file like the following: 11_3_4 2_1_35 3_15__ _16989 Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot...

5. Shell Programming and Scripting

Sort a the file & refine data column & row format

cat file1.txt field1 "user1": field2:"data-cde" field3:"data-pqr" field4:"data-mno" field1 "user1": field2:"data-dcb" field3:"data-mxz" field4:"data-zul" field1 "user2": field2:"data-cqz" field3:"data-xoq" field4:"data-pos" Now i need to have the date like below. i have just...

6. UNIX for Advanced & Expert Users

Convert column data to row data using shell script

Hi, I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated. Thanks.

7. Shell Programming and Scripting

awk transpose column to row and sort

I am trying to awk the output from below output for each port: i need separate line with comma source file Output required

8. Shell Programming and Scripting

Convert Data from Column to Row

Hi FileA.txt E_TIM 16, ETE 15, EOND 26, EEC 81, E_1 un, E_2 un, E_3 un, E_4 284, E_TIM 17, ETE 15, EOND 29, EEC 82, E_1 un, E_2 un, E_3 un, E_4 249,

9. Shell Programming and Scripting

Replace First Column and First Row Data

HI Guys, I just want to replace data for First Column and Row Cell(1,1) Input :- Hello A B C X 1 2 3 Y 4 5 6 Z 7 8 9 Output:- Byee A B C X 1 2 3 Y 4 5 6 Z 7 8 9 From Hello to Byee .....And The Each file have Different String.

10. Shell Programming and Scripting

Column to Row Data.

HI Guys, I have below Input :- X L1 5 Y L1 10 Z L1 15 X L2 20 Y L2 12 Z L2 15 X L3 100 Y L3 Z L3 300 Output:- ID L1 L2 L3 X 5 10 15 Y 20 12 15 Z 100 Null 300

LEARN ABOUT DEBIAN

fatsort

fatsort(1)						      General Commands Manual							fatsort(1)

NAME

       FATSort - FAT filesystem sorting utility

SYNOPSIS

       fatsort [options] device

DESCRIPTION

       FATsort sorts directory structures of FAT filesystems.  Many MP3 hardware players don't sort files automatically but play them in the order
       they were transmitted to the device. FATSort can help here.

OPTIONS

       -c     This option causes FATSort to ignore the case of filenames (e.g. 'example.mp3' is equal to 'EXAMPLE.MP3').

       -f     Force sorting even if the device is mounted or if FATSort cannot determine if the device is mounted.

       -h     Shows some help information.

       -i     Prints some file system information of the specified device.

       -l     FATSort will not sort directory structures, but just print the current order.

       -o type
	      This options specifies how FATSort will sort files and directories.  type can be 'd' for directories  before  files  (which  is  the
	      default), 'f' for files before directories, or 'a' for no differentiation between files and directories.

       -n     Uses natural order to sort directory structures instead of  alphanumeric order.  For example, an alphanumeric order would be
		     file123.mp3
		     file21.mp3
		     file3.mp3
	      and the corresponding natural order would be
		     file3.mp3
		     file21.mp3
		     file123.mp3.

       -q     FATSort will work quietly without printing additional information messages.

       -r     Sorts the directories in reverse order (Z-A).

       -R     Sorts the directories in random order.

       -v     Shows version information only.

       The following options can be specified multiple times:

       -d directory
	      Sort directory only

       -D directory
	      Sort directory and all subdirectories

       -x directory
	      Don't sort directory

       -X directory
	      Don't sort directory and all subdirectories

       -I prefix
	      Ignore  filename	prefix	prefix	during sorting. For example, passing option -I "the " tells FATSort to sort 'The Beatles.mp3' like
	      'Beatles.mp3'.

EXAMPLES

       Sort FAT filesystem on an USB stick:
	      fatsort /dev/sda1

       Sort FAT filesystem in a file:
	      fatsort /home/user/fat16_fs.img

       Sort directory /dir1 and all subdirectories except /dir1/dirA:
	      fatsort /dev/sda1 -D /dir1 -x /dir1/dirA

       Ignore prefixes 'a ' and 'the ' during sorting:
	      fatsort /dev/sda1 -I "a " -I "the "

AUTHOR

       Boris Leidner <fatsort(at)formenos.de>

SEE ALSO

       mount(8) fsck(8)

NOTES

       FAT12 is not supported yet.

REPORT BUGS

       Please report bugs to fatsort(at)formenos.de. Thanks.

FATSort 0.9.15							       2011								fatsort(1)