Sort text file starting at column X Post: 302516291

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort a particular column in a file

Dear All, Good day. Here i am facing some problem like below. file contains 12345 0001 090112 14385 0001 090112 13255 0001 090112 11345 0001 090112 .... I want to sort ascending according to the first column. What will be the shell script.

2. Shell Programming and Scripting

Sort file based on column

Hi, My input file is $cat samp 1 siva 1 raja 2 siva 1 siva 2 raja 4 venkat i want sort this name wise...alos need to remove duplicate lines. i am using cat samp|awk '{print $2,$1}'|sort -u it showing raja 1

3. UNIX for Dummies Questions & Answers

How to insert alternative columns and sort text from first column to second?

Hi Everybody, I am just new to UNIX as well as to this forum. I have a text file with 10,000 coloumns and each coloumn contains values separated by space. I want to separate them into new coloumns..the file is something like this as ad af 1 A as ad af 1 D ... ... 1 and A are in one...

4. Shell Programming and Scripting

Can't sort file by size column

Hello, I've done ls -ls >fileout1 When I do the sort command for +4 it sorts it bu group. When I do +5 it sorts it by date. But it's skipping the file size column. Example: rwxr-xr-x 1 Grueben sup 65 16 Sep 13:58 cdee How can I sort it by file size? It doesn't...

5. Shell Programming and Scripting

sort each column of text file alone

Hello , i have a text file like this 1 a1 ,AB ,AC ;AD ,EE 2 a2 ,WE ;TR ,YT ,WW 3 a3 ;AS ,UY ;RF ,YT i want to sort this text file based on each row , and excluding 2nd column from the sorting and not taking the comma or ; into consideration in the sorting, so it will become like this...

6. Shell Programming and Scripting

Reformatting single column text file starting new line when finding particular string

Hi, I have a single colum file and I need to reformat the file so that it creates a new line every time it come to an IP address and the following lines are corresponding rows until it comes to the next IP address. I want to turn this 172.xx.xx.xx gwpusprdrp02_pv seinwnprd03...

7. Shell Programming and Scripting

Sort a file content using one column

Hello All, I have a file which have content as below. 03/09/2014 10:35 AM 618 Admin\rick pqr_ klm2_pog12_20140309_c.xlsx 03/10/2014 10:35 AM 618 user\test01 mplz_ fgh2_lal12_20140310_c.xlsx 03/17/2014 10:35 AM 618 Admin\vick abc_ xyz2_bc12_20140317_c.xlsx 03/18/2014 ...

8. Shell Programming and Scripting

Text to column starting/ending with special character in each row

Hello, Here is my text data excerpted from the webpage: input My target is to get: What i tried is: sed 's/.*$connector$/1/' input > output but all characters coming before the word "connector" are deleted which is not good for me. My question:

9. UNIX for Beginners Questions & Answers

How to sort a column in excel/csv file?

I have to sort the 4th column of an excel/csv file. I tried the following command sort -u --field-separator=, --numeric-sort -k 2 -n dinesh.csv > test.csv But, it's not working. Moreover, I have to do the same for more than 30 excel/csv file. So please help me to do the same.

10. UNIX for Beginners Questions & Answers

How to align/sort the column pairs of an csv file, based on keyword word specified in another file?

I have a csv file as shown below, xop_thy 80 avr_njk 50 str_nyu 60 avr_irt 70 str_nhj 60 avr_ngt 50 str_tgt 80 xop_nmg 50 xop_nth 40 cyv_gty 40 cop_thl 40 vir_tyk 80 vir_plo 20 vir_thk 40 ijk_yuc 70 cop_thy 70 ijk_yuc 80 irt_hgt 80 I need to align/sort the csv file based...

LEARN ABOUT DEBIAN

dcsort

DCSORT(1)					      DICOM PS3 - Make sorted list of images						 DCSORT(1)

NAME

       dcsort - ACR/NEMA DICOM PS3 ... DICOM PS3 - Make sorted list of images

SYNOPSIS

       dcsort  "  inputfile1  [ inputfile2 ... ]" [ -v|verbose ] [ -vv|veryverbose ] [ -vvv|veryveryverbose ] [ -index ] [ -show ] [ -interval ] [
		 -tolerance mm ] [ -check ] [ -checkFoR ] [ -descending ] [ -sortby|k  attributename ]

DESCRIPTION

       dcsort reads the named dicom input files and sorts them by the specified sort key.

       The sort key should be a single valued numeric attribute, with the exception of ImageOrientationPatient and ImagePositionPatient which  are
       handled as special cases.

       There is no output by default unless the index or verbose options are specified.

OPTIONS

       The output and errors go to standard error.

       The basic input switches are described in dcintro(1). Options specific to this program are:

       -index
	      Creates a first column of output that is the index in the sort order, starting from 0, and a second column that is the filename.

       -show
	      Show the value of the sort key after the file name with the -index option

       -interval
	      Show the interval between values of the sort key, or an error if not equal

       -tolerance mm
	      The tolerance value in mm to use when comparing intervals between slices; defaults to +/- 0.01 mm if unspecified

       -check
	      Check that all the images are from the same series.

       -checkFoR
	      Check that all the images have the same Frame of Reference (UID).

       -descending
	      Sort in descending, rather than the default ascending, order.

       -sortby|k  attributename
	      Specify attributename as the sort key.

ENVIRONMENT


EXAMPLES


       % dcsort -index -sortby SliceLocation ./1/[0-9]*
       0    ./1/1
       1    ./1/2

FILES


SEE ALSO

       dcintro(1)

AUTHOR

       Copyright (C) 1993-2010. David A. Clunie DBA PixelMed Publishing. All rights reserved.

BUGS

DICOM PS3							 22 December 2006							 DCSORT(1)