01-13-2010
Split a single file into several others basing on the last column
Hi folks,
Happy new year.
I have a file 'filename' that i wd like to split basing on the contents in the last column.
The 'filename' content looks like
256772744788,9,11
256772744805,9,11
256772744792,9,11
256775543055,10,12
256782625357,9,12
256772368953,10,13
256772627735,10,13
256782853530,9,14
256782676830,9,28
256392752548,9,37
256782610403,9,38
256775590939,9,38
and i would like output files like 'file11', 'file12', 'file13', 'file 14', 'file28' etc with content
[cat file11]
256772744788,9,11
256772744805,9,11
256772744792,9,11
[cat file38]
256782610403,9,38
256775590939,9,38
I used this for loop but only created empty files.
[for (( i = 11; i <= 115; i++ )); do grep ',$i' cugnums.csv > file$i;done]
The last column has integer values from 11 to 115
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
We have a text file with more than 1500 paragraphs.
There is a blank line to separate paragraphs.
We need to create one text file (with any name but unique) per paragraph. In other words, how can i extract each paragraph and create a separate file with those contents (so 1500 text... (3 Replies)
Discussion started by: prvnrk
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,I have a single sql file containing many create table ddl's.Example:
CREATE TABLE sec_afs
(
rpt_per_typ_c char(1) NOT NULL,
rpt_per_typ_t varchar(20) NULL,
LOCK ALLPAGES
go
EXEC sp_primarykey 'sec_afs', rpt_per_typ_c
go
GRANT SELECT ON sec_afs TO developer_read_only... (5 Replies)
Discussion started by: smarter_aries
5 Replies
3. Shell Programming and Scripting
Hi all,
I have a binary file (orig.dat) and two special delimiter strings 'AAA' and 'BBB'. My binary file's content is as follow:
<Data1.1>AAA<Data1.2>BBB
<Data2.1>AAA<Data2.2>BBB
...
<DataN.1>AAA<DataN.2>BBB
DataX.Y might have any length, and contains any kind of special/printable... (1 Reply)
Discussion started by: Averell
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: tomasl
3 Replies
5. Shell Programming and Scripting
Let's assume that I have a file name called ‘A' and it has 100 lines in it and would like to split these 100 lines into 4 files as specified bellow.
INPUT: Input file name A
1
2
3
4
5
6
7
8
9
........100
Output: 4 output files (x,y,z,w)
File x should contains (Skip 4 lines)... (15 Replies)
Discussion started by: subbarao25
15 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I am new to unix. we have a requirement here to split a single file into multiples files based on the number of people available for processing. So i tried my hand at writing some code as below.
#!/bin/bash
var1=`wc -l $filename`
var2=$var1/$splitno
split -l $var2 $1
Please help me... (6 Replies)
Discussion started by: quirkguy
6 Replies
7. Shell Programming and Scripting
I have one single shown below and I need to break each ST|850 & SE to separate file using unix script. Below example should create 3 files. We can use ST & SE to filter as these field names will remain same.
Please advice with the unix code.
ST|850
BEG|PO|1234
LIN|1|23
SE|4
ST|850... (3 Replies)
Discussion started by: prasadm
3 Replies
8. UNIX for Dummies Questions & Answers
input file:
AD,00,--,---,---,---,---,---,---,--,--,---
AM,000,---,---,---,---,---,---
AR, ,---,--,---,---
AA,---,---,---,---
AT,---
AU,---,---,---
AS,---,---
AP,---,---,---
AI,---
AD,00,---,---,---, ,---,---,---,---,---,---
AM,000,---,---,---
AR,... (6 Replies)
Discussion started by: kcdg859
6 Replies
9. Shell Programming and Scripting
Hi,
I have 2 csv/txt files with single columns. I am trying to merge them using paste, but its not working..
output3.csv:
flowerbomb
everlon-jewelry
sofft
steve-madden
dolce-gabbana-watchoutput2.csv:
http://www1.abc.com/cms/slp/2/Flowerbomb
http://www1.abc.com/cms/slp/2/Everlon-Jewelry... (5 Replies)
Discussion started by: ajayakunuri
5 Replies
10. Shell Programming and Scripting
Hi All,
I have the sales_data.csv file in the directory as below.
SDDCCR; SOM ; MD6546474777 ;05-JAN-16
ABC ; KIRAN ; CB789 ;04-JAN-16
ABC ; RAMANA; KS566767477747 ;06-JAN-16
ABC ; KAMESH; A33535335 ;04-JAN-16
SDDCCR; DINESH; GD6674474747 ;08-JAN-16... (4 Replies)
Discussion started by: ROCK_PLSQL
4 Replies
geom(1) geom(1)
NAME
geom - analyzes a molecular geometry input in Cartesian coordinates.
DESCRIPTION
The program geom reads a set of Cartesian coordinates and determines from them the bond distances (Bohr and angstrom), bond angles, tor-
sional angles, out-of-plane angles (optional), moments of inertia, and rotational constants.
FILES REQUIRED
input.dat - Input file
and one of the following:
geom.dat - geometry file
file11.dat - PSI-format geometry/gradient file
FILES GENERATED
geom.out - file containing the analysis
INPUT OPTIONS
The geom program has the following options:
-h Print help information (these options).
-aces [filename]
Read the input in an ACES output format, with each line consisting of atomic symbol, atomic number, and Cartesian coordinates (in
Bohr). The optional argument is the name of the geometry input file, which defaults to geom.dat.
-qchem [filename]
Read the input in an QCHEM output format, with each line consisting of the atom number, the atomic symbol, and Cartesian coordinates
(in Angstroms). The optional argument is the name of the geometry input file, which defaults to geom.dat.
-xyz [filename]
Read the input in an XYZ output format. The first line contains the number of atoms and the second line is a comment line. Subse-
quent lines each contain the atomic symbol and Cartesian X Y and Z coordinates (in Angstroms). The optional argument is the name of
the geometry input file, which defaults to geom.dat.
-oop Print out-of-plane angles, where the angle a-b-c-d is defined as the angle formed by the vector a-d and the plane defined by atoms
b, c, and d.
DO_OOP = boolean
Same as command-line switch -oop described above.
ISOTOPES = matrix of reals/strings
Used to specify masses to be used in the calculation of the center of mass and rotational constants. One array is provided for each
isotopomer to be calculated. The arrays can mix floating point numbers with strings which designate isotopes. If this array is not
given and file11.dat is present, then the masses will be obtained by converting the atomic numbers in file11. If masses are not
given by ISOTOPES or by file11, then no mass-related quantities will be calculated.
-g [filename]
Read Cartesian coordinates from a file other than file11.dat. If a filename is not given, the default is geom.dat. The alternative
file is assumed to be in a format similar to that of PSI's geom.dat. Since such files do not contain atomic numbers, the moments of
inertia and rotational constants are not calculated if this option is used.
READ_GEOM = boolean
This option in input.dat tells geom to read the geometry from geom.dat in the PSI geom.dat format.
-a Print parameters for all pair distances.
PRINT_ALL_DIST = boolean
Same as -a flag described above.
-d distance
Only print parameters involving pairs of atoms which are less than distance bohr apart (default value is 4.0 bohr).
PRINT_DISTANCE = value
Same as -d flag described above.
-angstrom
The input coordinates are in angstroms, not bohr.
ANGSTROM = boolean
If TRUE, the input coordinates are in angstroms instead of bohr. The default is FALSE.
The following example is for calculating the geometrical information for water with several different isotopes. The geometry is
read from geom.dat rather than from file11.dat.
geom: (
read_geom = true
isotopes = (
(O H H)
(O D D)
(O18 1.007825 1.007825)
) )
5 June, 1998 geom(1)