Dear All,
I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...):
ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N
ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Hi
I have some data in my Excel File.However all the data is in one single column.I want to split it into two columns.
Current Data:
1,Hi Everyone,I am
7,New To Dos,And
17,VB Script,i could
110,have tried this thing
1800,in UNIX
Desired Output
CELL1|CELL 2
1 |Hi... (3 Replies)
Hi All,
in bash I have a text file which is something like
7.96634E-07 1.0000 0.00000E+00 0.0000 0.00000E+00 0.0000 1.59327E-06 0.7071
2.23058E-05 0.1890 6.61207E-05 0.1098 1.13919E-04 0.0865 1.47377E-04 0.0747
....
....
0.00000E+00 0.0000 0.00000E+00 0.0000 ... (6 Replies)
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Hi,
Anybody know how to print out the record that shown smallest number among column 3 and column 4
Case 1 Input :
37170 37196 77 51
37174 37195 73 52
37174 37194 73 53
Case 1 Output :
37170 37196 77 51
Case 2 Input :
469613 469660 73 ... (4 Replies)
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
please write a shell script
Table
--------------------------
1 2 3 a b c
3 4 5 c d e
7 8 9 f g h
Output should be like this
---------------
1 2 3
3 4 5
7 8 9
a b c
c d e
f g h (1 Reply)
I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end
Source file will have
001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C
Need Output from every 5 tab and remove the comma from end of each row
... (4 Replies)
Discussion started by: ranjancom2000
4 Replies
LEARN ABOUT CENTOS
funindex
funindex(1) SAORD Documentation funindex(1)NAME
funindex - create an index for a column of a FITS binary table
SYNOPSIS
funindex <switches> <iname> [oname]
OPTIONS
NB: these options are not compatible with Funtools processing. Please
use the defaults instead.
-c # compress output using gzip"
-a # ASCII output, ignore -c (default: FITS table)"
-f # FITS table output (default: FITS table)"
-l # long output, i.e. with key value(s) (default: long)"
-s # short output, i.e. no key value(s) (default: long)"
DESCRIPTION
The funindex script creates an index for the specified column (key) by running funtable -s (sort) and then saving the column value and the
record number for each sorted row. This index will be used automatically
by funtools filtering of that column, provided the index file's modification date is later than that of the data file.
The first required argument is the name of the FITS binary table to index. Please note that text files cannot be indexed at this time. The
second required argument is the column (key) name to index. While multiple keys can be specified in principle, the funtools index process-
ing assume a single key and will not recognize files containing multiple keys.
By default, the output index file name is [root]_[key].idx, where [root] is the root of the input file. Funtools looks for this specific
file name when deciding whether to use an index for faster filtering. Therefore, the optional third argument (output file name) should not
be used for funtools processing.
For example, to create an index on column Y for a given FITS file, use:
funindex foo.fits Y
This will generate an index named foo_y.idx, which will be used by funtools for filters involving the Y column.
SEE ALSO
See funtools(7) for a list of Funtools help pages
version 1.4.2 January 2, 2008 funindex(1)