Sponsored Content
Top Forums Shell Programming and Scripting Script awk vertical to horizontal with some condition Post 302847367 by Chubler_XL on Monday 26th of August 2013 11:56:42 PM
Old 08-27-2013
Your input file must not match what you posted here, as I get a character-for-character match with your required output:

Code:
BIMAB;ACF-0168;QTS-0465;QUA;2013-08-17 14:16:09.34;**;ALAR;ORX -004;NDORIDUNGGA;(21943);7745;ABOVE DEFINED;02 00 01 00 00 00 01 00 00 01 03 100d
BIMAB;ACF-0163;EQU;2013-04-25 17:45:31.15;**;ALAR;CM -0779;(20389);7704;FAIL
BIMAB;ACF-0150;ENV;2013-05-17 15:37:09.72;*;ALAR;(52250);7602;ACF NOTIF;C is broken;05 02 0B 9E 00 00
BIMAB;ACF-0143;QTS-0457;PRO;2013-08-27 03:28:17.14;**;ALAR;ORX -023;NJATIWANG2IL;(14921);7607;ORX OPERATION;detected too high;00 00 00 83 21 21
FMUBD2;ACF-0097;QTS-0221;EQU;2013-08-18 12:47:39.60;**;ALAR;ORX -020;EVPEJENG2QTS;(24594);7607;ORX OPERATION;difference exceeding;1A 09 00 B5 0A 02
FMUBD2;ACF-1251;QTS-1252;QUA;2013-08-24 13:12:46.15;**;ALAR;ORX -006;EVTEGALSUCI;(44220);7744;EXCESSIVE;00 00 00 64 64 64 64 00 02 50d

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Horizontal to vertical

Hi, Silly question, if I have an excel file that looks something like this: ................. Subject 1 Subject 2 Subject 3 Subject 4 Fever..............13...........9.............23..........14 Headache.........2............12...........18..........23... (3 Replies)
Discussion started by: Xterra
3 Replies

2. UNIX for Dummies Questions & Answers

vertical to horizontal

dear all, i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2. example text : Data DATE XXXXX MAX 47 53 49 51 48 48 7 46 51 8 25 (6 Replies)
Discussion started by: andrisetia
6 Replies

3. Shell Programming and Scripting

Vertical And Horizontal Pivoting

Hi All, My Input data is: A=1 B=2 My desired Output should be: A|B 1|2 Thanks in advance... (3 Replies)
Discussion started by: kmsekhar
3 Replies

4. Shell Programming and Scripting

Need perl or shell script to sort vertical lines to horizontal line in csv format

Need perl or shell script to sort vertical lines to horizontal line in csv format My file like below ------------------------- ================================================================================ PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ... (4 Replies)
Discussion started by: sreedhargouda.h
4 Replies

5. Shell Programming and Scripting

awk - horizontal and vertical text extraction

Hi, I need some help in getting extracting the specific horizontal and vertical texts in a single line. I am trying to extract few of the parameters from a config file. Your help is appreciated. Desired Output ---------------- Pool members members ... (4 Replies)
Discussion started by: pratheeshp
4 Replies

6. Shell Programming and Scripting

Script for parsing vertical log into horizontal

Hi, I have log like this : And i want the output like below : I have try using awk but doesn't work awk ' /ffff /{ts=$1} f && /SectorAntenna\=1/{sa1=$3} f && /SectorAntenna\=2/{sa2=$3} f && /SectorAntenna\=3/{sa3=$3} { s= ts "|" sa1 "|" sa2 "|" sa3 print s f=0 }' (7 Replies)
Discussion started by: justbow
7 Replies

7. Shell Programming and Scripting

awk Help: Horizontal to Vertical print with pattern match

Hi AWK Experts, Following is the data : BRH113 DD AA HH CA DD DD AA HH BRH091 A4 A6 AH H7 67 HH J8 9J BRH0991 AA D8 C23 V5 H7 BR2 BRH991 AA HH GG5 BT0 JJ0 I want the output to be alligned with the pattern matching "BRH" inthe line. The output should be look like: A]... (4 Replies)
Discussion started by: rveri
4 Replies

8. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

9. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies

10. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

I need to change data from vertical to horizontal but with condition input USA|80 AUS|40 BRA|33 VEGAS|40 KENTUCKY|50 NEWYORK|21 DARWIN|33 ADELAIDE|21 SAOPAOLO|44 RIO|89 GAPIZA|44 BENFLEX|32 AXIS|44 ACRE|56 HEIGHT|22 (5 Replies)
Discussion started by: radius
5 Replies
g_dielectric(1) 				 GROMACS suite, VERSION 4.5.4-dev-20110404-bc5695c				   g_dielectric(1)

NAME
g_dielectric - calculates frequency dependent dielectric constants VERSION 4.5.4-dev-20110404-bc5695c SYNOPSIS
g_dielectric -f dipcorr.xvg -d deriv.xvg -o epsw.xvg -c cole.xvg -[no]h -[no]version -nice int -b time -e time -dt time -[no]w -xvg enum -[no]fft -[no]x1 -eint real -bfit real -efit real -tail real -A real -tau1 real -tau2 real -eps0 real -epsRF real -fix int -ffn enum -nsmooth int DESCRIPTION
g_dielectric calculates frequency dependent dielectric constants from the autocorrelation function of the total dipole moment in your sim- ulation. This ACF can be generated by g_dipoles. For an estimate of the error you can run g_statistics on the ACF, and use the output thus generated for this program. The functional forms of the available functions are: One parameter: y = Exp[-a1 x], Two parameters: y = a2 Exp[-a1 x], Three parameters: y = a2 Exp[-a1 x] + (1 - a2) Exp[-a3 x]. Start values for the fit procedure can be given on the command line. It is also possible to fix parameters at their start value, use -fix with the number of the parameter you want to fix. Three output files are generated, the first contains the ACF, an exponential fit to it with 1, 2 or 3 parameters, and the numerical deriva- tive of the combination data/fit. The second file contains the real and imaginary parts of the frequency-dependent dielectric constant, the last gives a plot known as the Cole-Cole plot, in which the imaginary component is plotted as a function of the real component. For a pure exponential relaxation (Debye relaxation) the latter plot should be one half of a circle. FILES
-f dipcorr.xvg Input xvgr/xmgr file -d deriv.xvg Output xvgr/xmgr file -o epsw.xvg Output xvgr/xmgr file -c cole.xvg Output xvgr/xmgr file OTHER OPTIONS
-[no]hno Print help info and quit -[no]versionno Print version info and quit -nice int 19 Set the nicelevel -b time 0 First frame (ps) to read from trajectory -e time 0 Last frame (ps) to read from trajectory -dt time 0 Only use frame when t MOD dt = first time (ps) -[no]wno View output .xvg, .xpm, .eps and .pdb files -xvg enum xmgrace xvg plot formatting: xmgrace, xmgr or none -[no]fftno use fast fourier transform for correlation function -[no]x1yes use first column as x-axis rather than first data set -eint real 5 Time to end the integration of the data and start to use the fit -bfit real 5 Begin time of fit -efit real 500 End time of fit -tail real 500 Length of function including data and tail from fit -A real 0.5 Start value for fit parameter A -tau1 real 10 Start value for fit parameter tau1 -tau2 real 1 Start value for fit parameter tau2 -eps0 real 80 epsilon0 of your liquid -epsRF real 78.5 epsilon of the reaction field used in your simulation. A value of 0 means infinity. -fix int 0 Fix parameters at their start values, A (2), tau1 (1), or tau2 (4) -ffn enum none Fit function: none, exp, aexp, exp_exp, vac, exp5, exp7, exp9 or erffit -nsmooth int 3 Number of points for smoothing SEE ALSO
gromacs(7) More information about GROMACS is available at <http://www.gromacs.org/>. Mon 4 Apr 2011 g_dielectric(1)
All times are GMT -4. The time now is 06:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy