sort and split file by 2 cols (1 col after the other) Post: 302337893

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

join cols from multi files into one file

Hi Fields in Files 1,2,3,4 are pipe"|" separated. Say I want to grep col1 from File1 col3 from File2 col4 from File3 and print to File4 in the following order: col3|col1|col4 what is the best way of doing this? Thanks

2. Shell Programming and Scripting

Sort & Split records in a file

Hi, I am new to scripting. I need a script to sort and the records in a file and then split them into different files. For example, the file is: H1...................... H2...................... D2.................... D2.................... H1...........................

3. Shell Programming and Scripting

How to find number of Cols in a file ?

Hi I have a requirement wherein the file is comma separated. Each records seems to have different number of columns, how I can detect like a row index wise, how many columns are present ? Thanks in advance.

4. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to...

5. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The...

6. Shell Programming and Scripting

how to Insert values in multiple lines(records) within a pipe delimited text file in specific cols

this is Korn shell unix. The scenario is I have a pipe delimited text file which needs to be customized. say for example,I have a pipe delimited text file with 15 columns(| delimited) and 200 rows. currently the 11th and 12th column has null values for all the records(there are other null columns...

7. Shell Programming and Scripting

Printing from col x to end of line, except last col

Hello, I have some tab delimited data and I need to move the last col. I could hard code it, awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile but it would be nice to know the syntax to print a range cols. I know in cut you can do, cut -f 1,4-8,11- to print fields 1,...

8. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided...

9. Shell Programming and Scripting

Sort and Split file with header and custom name

Hi, I am using SUN SOLARIS (SunOS sun4v sparc SUNW, T5240). I have a huge data file with header and trailer. This file gets used into an ETL process. ETL skips the header record (which is the first record of the file) and loads the rest of the record. The file can be delimited (comma,...

10. UNIX for Beginners Questions & Answers

Sort files to the split second

I need a similar sort, I need to sort the directory by time, but time needs to be to the second or smaller. Using ls -lt but that is only to the minute.

LEARN ABOUT REDHAT

indexmaker

INDEXMAKER(1)							       mrtg							     INDEXMAKER(1)

NAME

       indexmaker - Creates index files for mrtg web sites (mrtg-2.9.17)

SYNOPSIS

       indexmaker [options] regexp mrtg.cfg [other.cfg ...]

OPTIONS

	--output=filename   set output filename (default: stdout)

	--filter title=~regexp	select targets by matching regexp against titles
	--filter pagetop=~regexp  select targets by matching regexp against pagetop
	--filter name=~regexp  select targets by matchin regexp against name

	--title=text	    set title of generated index file
	--bodyopt=text	    set body tag options
	--pagetop=text	    insert this text between <BODY> and <H1>...</H1>

	--columns=number    show graphs in a table with x columns (default: 2)

	--sort=title	    sort graphs by title
	--sort=name	    sort graphs by their name
	--sort=descr	    sort graphs by their description
	--sort=original     leave as is (default)

	--enumerate	    add a sequence number to the title of each graph

	--width=number	    set width of graphs (default: not set)
	--height=number

	--show=day	    pick which graph to show in the index (default)
	--show=week
	--show=month
	--show=year
	--show=none

	--section=h1	    h1 tag from pagetop as section heading (default)
	--section=title     title as section headings for graphs
	--section=name	    graph name as section heading
	--section=descr     graph description as section heading
	--section=portname  port name entry in pagetop as section heading

	--rrdviewer=path    path to rrdviewer (default: /cgi-bin/14all.cgi)
	--prefix=path	    path from the location of the index.html to the graphs

DESCRIPTION

       Indexmaker can create web pages which display the status of an array of mrtg interface status pages.

       --output filename
	   set output filename (default: stdout)

       --filter (title|pagetop|name)(=~|!~)regexp
	   Several filters may get set.  Each filter can match agains the contents of a specific section of the mrtg config file. Name refers to
	   the bit in square brackets (option[name]: bla).

	   Depending on the match operator chosen (=~ or !~) the match will be positive or negative.

	   Note that some shells consider ! a special character.  It may be necessary to type !~ instead.

       --title text
	   Set title of generated index file (default: regexp)

       --bodyopt text
	   The value of this argument gets appended to the <BODY> tag. This allows to set document colors.  By default this option is set to

	    bgcolor="#ffffff" text="#000000" link="#000000" vlink="#000000" alink="#000000"

       --columns number
	   Display graphs in a table with number columns (default: 2)

       --sort title|name|descr|original
	   Sort the graphs in the page either by title, by name, by interface description, or leave them as is.

       --enumerate
	   Add a sequence number to the title of each graph

       --width number
	   Set width of graphs

       --height number
	   Set the height of the graphs

       --show day|week|month|year|none
	   Select which graph to show in the index page. You can supress images completely with --show=none.

       --section h1|title|name|description|portname
	   Select what to use as the title for each graph in the page.	h1 is the H1 section from pagetop, title is the graph title, name is the
	   bit in square brackets (option[name]: bla), and descr or description is the text from the Description field of the PageTop (the Cisco
	   description text if it's available, otherwise just the interface description). portname is the "Port Name:" from pagetop.

       --rrdviewer path
	   If you have set the LogFormat: rrdtool property in the mrtg.cfg file, the index will take this into account. The only thing you must
	   tell it is the path to your grapher cgi. (default: /cgi-bin/14all.cgi)

       --prefix path
	   By  default we assume    that  the file generated by indexmaker is stored in WorkDir.  If you want to  store it somewhere   else, spec-
	   ify how to reach WorkDir  from  the place where the Index is stored. Note that you have to use '/' as path separator as this will be
	   used in urls. Speaking of which, you can even enter a whole url.

AUTHOR

       Tobias Oetiker <tobi@oetiker.ch>

LICENSE

       GNU General Public License

COPYRIGHT

       2000-2001 Tobias Oetiker <tobi@oetiker.ch>

3rd Berkeley Distribution					      2.9.17							     INDEXMAKER(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

join cols from multi files into one file

Discussion started by: vbshuru

2. Shell Programming and Scripting

Sort & Split records in a file

Discussion started by: Sunitha_edi82

3. Shell Programming and Scripting

How to find number of Cols in a file ?

Discussion started by: videsh77

4. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Discussion started by: sogi