Sponsored Content
Top Forums Shell Programming and Scripting Sort based on positions in flat file Post 302876607 by RudiC on Monday 25th of November 2013 03:11:11 PM
Old 11-25-2013
Please use code tags as required by forum rules!

You seem to have edited your initial post#1 after the comments of Don Cragun. Still, due to missing code tags, your input sample does NOT obey the specification (field positions) that you have given. Plus, the desired output does NOT conform to your specs, either - it is sorted for last name, not first name as desired. Try this (based on guesses and input modified by me to be reasonable) and come back with results/comments:
Code:
sort -k1.8,1.15 -k1.1,1.6 -k1.21,1.29n file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting a flat file based on multiple colums(using character position)

Hi, I have an urgent task here. I am required to sort a flat file based on multiple columns which are based on the character position in that line. I am restricted to use the character position instead of the space and sort +1 +2 etc to do the sorting. I understand that there is a previous... (8 Replies)
Discussion started by: cucubird
8 Replies

2. Shell Programming and Scripting

Merge lines in Flat file based on first 5 characters

Hi I have the fixed width flat file having the following data 12345aaaaaaaaaabbbbbbbbbb 12365sssssssssscccccccccc 12365sssss 12367ddddddddddvvvvvvvvvv 12367 vvvvv Here the first column is length 5 second is length 10 third is length 10 if the second or third column exceeds... (3 Replies)
Discussion started by: Brado
3 Replies

3. Shell Programming and Scripting

Shell script to email based on flat file output

Hi All, I am a newbee in unix but still have written a shell script which should trigger a mail based on certain conditions but the problem is that my file is not being read. Below is the code please advise. I do not know where is it failing. Note $ and the no followed with it is the no of... (1 Reply)
Discussion started by: apoorva
1 Replies

4. Shell Programming and Scripting

Filling positions based on consensus character

I have files with hundreds of sequences with missing characters represented by a dash ("-"), something like this I need to go sequence by sequence and if a dash is found, it should be replaced with the most common character in that particular position. Thus, in my example the dash in the second... (6 Replies)
Discussion started by: Xterra
6 Replies

5. Shell Programming and Scripting

seds to extract fields based on positions

Hi My file has a series of rows up to 160 characters in length. There are 7 columns for each row. In each row, column 1 starts at position 4 column 2 starts at position 12 column 3 starts at position 43 column 4 starts at position 82 column 5 starts at... (7 Replies)
Discussion started by: malts18
7 Replies

6. Shell Programming and Scripting

Sort flat file by 3rd column in perl

Hello Guys I want to sort a flat file by the third column (numeric ) and store it in some other name I/P 9924873|20111114|00000000000013013|130|13|10/15/2010 12:36:22|W860944|N|00 9924873|20111114|00000000000013009|130|09|10/15/2010 12:36:22|W860944|N|00... (12 Replies)
Discussion started by: Pratik4891
12 Replies

7. Shell Programming and Scripting

Getting data from a flat file based on condition

Hi, I have a flaty file from which i am fetching few columns in tablular form as below code. Now i want to fetch the column 6 and 7 in below code only if it either of them is non zero.However below startement awk -F, '$6==0 && $7==0{exit 1}' ${IFILE} is not working..Not sure where is the... (36 Replies)
Discussion started by: Vivekit82
36 Replies

8. Shell Programming and Scripting

Join based on positions

I have two text files as shown below cat file1.txt Id leng sal mon 25671 34343 56565 5565 44888 56565 45554 6868 23343 23423 26226 6224 77765 88688 87464 6848 66776 23343 63463 4534 cat file2.txt Id number 25671 34343 76767 34234 23343 23423 66776 23343 (4 Replies)
Discussion started by: halfafringe
4 Replies

9. UNIX for Dummies Questions & Answers

Filling positions based on frequency

I have files with hundreds of sequences with frequency values reported as "Freq X" and missing characters represented by a dash ("-"), something like this >39sample Freq 4 TAGATGTGCCCGTGGGTTTCCCGTCAACACCGGATAGTAGCAGCACTA >22sample Freq 15 T-GATGTCGTGGGTTTCCCGTCAACACCGGCAAATAGTAGCAGCACTA... (12 Replies)
Discussion started by: Xterra
12 Replies

10. Shell Programming and Scripting

Filter lines based on values at specific positions

hi. I have a Fixed Length text file as input where the character positions 4-5(two character positions starting from 4th position) indicates the LOB indicator. The file structure is something like below: 10126Apple DrinkOmaha 10231Milkshake New Jersey 103 Billabong Illinois ... (6 Replies)
Discussion started by: kumarjt
6 Replies
ctags(1)						      General Commands Manual							  ctags(1)

Name
       ctags - create a tags file

Syntax
       ctags [options] name...

Description
       The command makes a tags file for from the specified C, Pascal and Fortran sources.

       A tags file gives the locations of specified objects (in this case functions and typedefs) in a group of files.	Each line of the tags file
       contains the object name, the file in which it is defined, and an address specification for the object definition.  Functions are  searched
       with a pattern, typedefs with a line number.  Specifiers are given in separate fields on the line, separated by blanks or tabs.

       Using the tags file, can quickly find these objects definitions.

       If  the	-x  flag  is  given,  writes  to standard output a list containing each object name, its line number, the file name in which it is
       defined, and the text of the line.  This list is a simple index which can be printed out as an off-line readable function index.

Options
       -a		   Appends information to an existing tags file.

       -B		   Uses backward search patterns (?...?).

       -F		   Uses forward search patterns (/.../) (default).

       -t		   Creates typedef tags.

       -u		   Updates the specified tags file.  All references to tags are deleted, and the new values  are  appended  to	the  file.
			   Note  that  this  option is implemented in a way which is rather slow.  It is usually faster to simply rebuild the tags
			   file.)

			   The tag main is treated specially in C programs.  The tag formed is created by prepending M to the name  of	the  file,
			   with  a  trailing  .c  removed,  if	any, and leading pathname components also removed.  This makes use of practical in
			   directories with more than one program.

       -v		   Generates an index listing function name, file name, and pages number.  Since the output will be  sorted  into  lexico-
			   graphic order, it may be desired to run the output through sort -f.	For example,
			   ctags -v files | sort -f > index
			   Files  whose  name  ends  in .c or .h are assumed to be C source files and are searched for C routine and macro defini-
			   tions.  Others are first examined to see if they contain any Pascal or Fortran routine definitions; if  not,  they  are
			   processed again looking for C definitions.

       -w		   Suppresses warning diagnostics and generates a listing file.  This list contains each object name, its line number, the
			   file name in which it is defined, and the text of the line, and is identical to the list produced when no  options  are
			   given.

       -x		   Writes  to  standard  output a list containing each object name, its line number, the file name in whcih it is defined,
			   and the text of the line.

Restrictions
       Recognition of functions, subroutines and procedures for FORTRAN and Pascal do not deal with block structure.  Therefore  you  cannot  have
       two Pascal procedures in different blocks with the same name.

       Does not know about #ifdefs.

       Does  not know about Pascal types.  Relies on the input being well formed to detect typedefs.  Use of -tx shows only the last line of type-
       defs.

Files
       tags	 output tags file

See Also
       ex(1), vi(1)

																	  ctags(1)
All times are GMT -4. The time now is 10:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy