Sponsored Content
Top Forums Shell Programming and Scripting Help tabulating file putting repeated strings as headers Post 303015946 by Ophiuchus on Tuesday 17th of April 2018 01:15:54 AM
Old 04-17-2018
Quote:
Originally Posted by Chubler_XL
I'm not aware of any tool like that. You could simply print out the contents of the arrays in the END block like this:

You can see that:
column[] is index by the column name and contains a count of the number of rows the column appears in (less 1)
columns[] is indexed by the column order and contains the column name.
column_data[] is a 2D array with index of <column name>,<row> and contains value of the data for that cell.

column[] is only used to detect the first occurrence of a column and add it to columns[]
Excellent ChublerXL. Thanks for the lesson, specially that comes from someone that knows a lot. I'll play a little bit with this example of arrays.

Thanks to all.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

putting a timestamp in a file

I was sure there was a way to put a timestamp ina logfile but I can't seem to figure out how. What I would like to do is after the last messages in the rptmgr.err log is put a timestamp so I know the next time I look whats new. I am using AIX 5.1 any help will great Thanks (2 Replies)
Discussion started by: rocker40
2 Replies

2. Shell Programming and Scripting

Remove text between headers while leaving headers intact

Hi, I'm trying to strip all lines between two headers in a file: ### BEGIN ### Text to remove, contains all kinds of characters ... Antispyware-Downloadserver.com (Germany)=http://www.antispyware-downloadserver.c om/updates/ Antispyware-Downloadserver.com #2... (3 Replies)
Discussion started by: Trones
3 Replies

3. Shell Programming and Scripting

Deleting repeated strings in column 2

Hi to all, I have a file where the subject could contain "Summarized Availability Report" or only "Summarized Report" If the subject is "Summarized Availability Report" I want to apply it Scrip1 and if the subject is "Summarized Report" I want to apply it Scrip2. 1-) I would like you... (5 Replies)
Discussion started by: cgkmal
5 Replies

4. Shell Programming and Scripting

Merging of files with different headers to make combined headers file

Hi , I have a typical situation. I have 4 files and with different headers (number of headers is varible ). I need to make such a merged file which will have headers combined from all files (comman coluns should appear once only). For example - File 1 H1|H2|H3|H4 11|12|13|14 21|22|23|23... (1 Reply)
Discussion started by: marut_ashu
1 Replies

5. Shell Programming and Scripting

delete repeated strings (tags) in a line and concatenate corresponding words

Hello friends! Each line of my input file has this format: word<TAB>tag1<blankspace>lemma<TAB>tag2<blankspace>lemma ... <TAB>tag3<blankspace>lemma Of this file I need to eliminate all the repeated tags (of the same word) in a line, as in the example here below, but conserving both (all) the... (2 Replies)
Discussion started by: mjomba
2 Replies

6. Shell Programming and Scripting

Delete lines in file containing duplicate strings, keeping longer strings

The question is not as simple as the title... I have a file, it looks like this <string name="string1">RZ-LED</string> <string name="string2">2.0</string> <string name="string2">Version 2.0</string> <string name="string3">BP</string> I would like to check for duplicate entries of... (11 Replies)
Discussion started by: raidzero
11 Replies

7. Shell Programming and Scripting

Find repeated word and take sum of the second field to it ,for all the repeated words in awk

Hi below is the input file, i need to find repeated words and sum up the values of it which is second field from the repeated work.Im trying but getting no where close to it.Kindly give me a hint on how to go about it Input fruits,apple,20,fruits,mango,20,veg,carrot,12,veg,raddish,30... (11 Replies)
Discussion started by: 100bees
11 Replies

8. UNIX for Dummies Questions & Answers

Joining ends of strings in certain order with repeated ID's

I posted this a few days ago and got some help (Putting together substrings if pattern is matched - Page 2 | Unix Linux Forums | Shell Programming and Scripting) But I am now stuck on an issue that is similar but not the same really. I want to join parts of one line with parts of another line... (8 Replies)
Discussion started by: verse123
8 Replies

9. UNIX for Beginners Questions & Answers

Use strings from nth field from one file to match strings in entire line in another file, awk

I cannot seem to get what should be a simple awk one-liner to work correctly and cannot figure out why. I would like to use patterns from a specific field in one file as regex to search for matching strings in the entire line ($0) of another file. I would like to output the lines of File2 which... (1 Reply)
Discussion started by: jvoot
1 Replies

10. Shell Programming and Scripting

Putting strings into positioning array in loop

i need to add 2 string variables into a positioning array , repeatedly - in loop. First string in $2, second to $3 then up to the desired count incrementing the "position". Using set -- alone does not increment the count so I end up with 2 variables in the array. How do I increment the... (7 Replies)
Discussion started by: annacreek
7 Replies
RASTEP(1)						      General Commands Manual							 RASTEP(1)

NAME
rastep - (Raster3D Thermal Ellipsoid Program) SYNOPSIS
rastep [-h] [-iso] [-Bcolor Bmin Bmax] [-prob Plevel] [-fancy[0-3]] [-radius R] < infile.pdb > ellipsoids.r3d rastep -tabulate [tabfile] [-by_atomtype] [-com [comtabfile]] < infile.pdb > statistics.text Rastep reads a PDB coordinate file. This file must contain ANISOU records describing atoms refined anisotropically. Rastep can either create an input file for the Raster3D render program or perform a statistical analysis of the atomic anisotropy for various classes of input atoms. By default the program creates an ellipsoid+stick scene description in which each atom is represented by an ellipsoid enclosing an isosurface of the probability density function. These are commonly known as thermal ellipsoids. The program can be run in an alternate mode, controlled by the -tabulate option, in which the primary output to stdout is a list of the Ei- genvalues of the Uij matrix, followed by the corresponding atomic anisotropy and isotropic Ueq, for each atom in the input file with both an ATOM record and a matching ANISOU record. This mode is used by the validation tools Parvati and Skittls. EXAMPLES
To describe thermal ellipsoids at the 50% probability level, with default CPK colors, and send it for immediate rendering into a PNG file rastep < infile.pdb | render -png picture.png To describe the same ellipsoids colored by Biso, omiting header records so that the resulting input file can be merged with other scene components rastep -h -Bcolor 10. 30. < infile.pdb > ellipsoids.r3d cat header.r3d ellipsoids.r3d otherstuff.r3d | render > picture.png OPTIONS
-auto Auto-selection of viewing angle, chosen to minimize the spread of the atoms along the view direction. -Bcolor Bmin Bmax Assign colors based on B values rather than mathcing ATOM records against input or default COLOUR records. Atoms with B <= Bmin will be colored dark blue; atoms with B >= Bmax will be colored light red; atoms with Bmin < B < Bmax will be assigned colors shading smoothly through the spectrum from blue to red. -fancy[0-6] The -fancy option selects increasingly complex representations of the rendered ellipsoids. -fancy0 [default] = solid surface -fancy1 = principal axes of ellipsoid, with transparent bounding surface -fancy2 = colored equatorial planes of the ellipsoid -fancy3 = colored equatorial planes with transparent bounding surface -fancy4 = transparent bounding surface containing longest principle axis -fancy5 = for ORTEP lovers, a solid ellipsoid with one octant missing -fancy6 = for ORTEP lovers who want the missing octant in a separate color -h Suppress header records in output. By default rastep will produce an output file which starts with header records containing a default set of scaling and processing options. The -h flag will suppress these header records. This option is useful for producing files which describe only part of a scene, and which are to be later combined with descriptor files produced by other programs. -iso Force isotropic probability surfaces (spheres). By default rastep will look for ANISOU records in the PDB file and use these to generate ellipsoids. If no ANISOU record is present for a given atom, the B value given in the ATOM/HETATM record will be used to generate a sphere instead. Selecting the -iso option will force the program to use the B value in the ATOM record even if an ANISOU record is also present. -mini Auto-orientation (as in -auto) and small size plot (176x208). -nohydrogens Do not plot hydrogens, even if present in PDB file. -prob Plevel By default, isosurfaces are drawn to enclose the 50% probability level in the density function described by the Uij values in the ANISOU record. The -prob option allows you to select a different probability level instead. If 0 < Plevel < 1 this value is interpreted as a fraction; if Plevel > 1 this value is interpreted as a percent. -radius R By default, rastep draws bonds with radius 0.10A between neighboring atoms using the same algorithm as rods. This option allows you to change the radius of the bonds. If the radius is set to 0 no bonds are drawn. -tabulate [tabfile] The -tabulate option requests that the program accumulate and print statistics on the distribution of anisotropy among atoms in the input file rather than producing an input file for render. The principle axes and anisotropy of each atom are written to stdout. An overall sta- tistical summary is written to tabfile if specified, otherwise to stdout. -by_atomtype The -by_atomtype option is a modifier to -tabulate. It causes a further subdivision of atoms by atom type in the preparation of statistical summaries. Atom types are taken from columns 77:78 of the PDB ATOM records. -com [comtabfile] Tabulate distribution of anisotropy in shells by distance from center-of-mass. Output to comtabfile if specified, otherwise to stdout. NOTES
There is little, if any, consistency in format among the various programs which write out anisotropic displacement parameters. This program interprets the Uij values in the order specified for ANISOU records in PDB format. That is, columns 29-70 of the PDB record are inter- preted as integers representing 10000 * Uij, in the order U11 U22 U33 U12 U13 U23. Note in particular that the order of the cross-terms is not the same as that used by ORTEP or shelx, neither of which use PDB format anyway. However, the program shelxpro will produce correctly formatted PDB records from a shelx coordinate file. SOURCE
web URL: http://www.bmsc.washington.edu/raster3d/raster3d.html contact: Ethan A Merritt University of Washington, Seattle WA 98195 merritt@u.washington.edu SEE ALSO
raster3d(l), render(l) AUTHORS
Ethan A Merritt. Raster3D 14 Dec 2010 RASTEP(1)
All times are GMT -4. The time now is 11:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy