02-05-2010
Creating Report file with 'vlookup' kind of structure in shell
Hi,
I have some files in the following structure.
File_a.txt
Field_1 Pass
Field_2 Pass
Field_3 Pass
File_b.txt
Field_1 Pass
Field_2 Fail
Field_3 Pass
File_c.txt
Field_1 Fail
Field_2 Pass
Field_3 Pass
I wanted to parse this and get a final report in this format. Here the ‘Field_1..” column does not change in the three files but I do need to search the fields and print out the corresponding Pass/Fail in this report format. How do I do this in shell?
Final_rep.txt
a b c
Field_1 Pass Pass Fail
Field_2 Pass Fail Pass
Field_3 Pass Pass Pass
regards,
Vikas
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am new user of shell scripting has come up with a problem. that I have a directory structure like :
Home
|
|--------A
| |----trunk
| |-------A_0_1/
| |
| |-------A_0_2/
|
|--------B
| ... (6 Replies)
Discussion started by: bhaskar_m
6 Replies
2. Shell Programming and Scripting
Dear All
I had two input file mention as below. Now i want to get op form mention file as below. Kindly how i get do it. Is there any thing in unix like vlookup?.
FILE 1:
BSC1
RXOTRX-48-8 COM MBL
RXOTRX-48-9 COM MBL
FILE2:
RXOTX-48-8 BHOR04C
RXOTX-48-9 BHOR04C
op:... (2 Replies)
Discussion started by: jaydeep_sadaria
2 Replies
3. Shell Programming and Scripting
Hello,
i am having a source directory which consist of multiple sub directories and my destination folder is a empty directory.
if try to copy a file source->test->1.txt from source to destination test2 using the commaind.
cp source/test/1.txt desti/
It will copy the 1.txt under desti... (1 Reply)
Discussion started by: tsaravanan
1 Replies
4. UNIX for Dummies Questions & Answers
Hi Gurus,
I need your help in transforming the CSV file into some what a report format.
My source file looks like below
Date,ProdID,TimeID,LevelID
2010-08-31,200,M,1
2010-08-31,201,Q,2
2010-08-31,202,Y,1
2010-08-31,203,M,5
Output required is
... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies
5. Shell Programming and Scripting
Hi Experts,
I have table in mysql like below:
'user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id`
varchar(100) NOT NULL,
`member_name` varchar(100) NOT NULL,
`city` varchar(100) NOT NULL,
`member_id` varchar(100) NOT
NULL,
`password` varchar(100) NOT... (1 Reply)
Discussion started by: naw_deepak
1 Replies
6. Shell Programming and Scripting
Can we create the master file that show the whole tree structure of the directory till a particular folder?
Database that contains four sub repository Sybase,sql,oracle,mysql and sql and oracle contains two subrepostories Siebel and plsql and each repositories contains three folders... (1 Reply)
Discussion started by: rohit22hamirpur
1 Replies
7. Programming
Hi,
For one of the project which i am working on i need to write a cpp code such that it will create the structure dynamically instead of reading it from header file.
For example we have a program which is reading a binary file according to the structure mentioned in header file.
But we... (0 Replies)
Discussion started by: AmbikaValagonda
0 Replies
8. Shell Programming and Scripting
I am developing shell script on Linux OS and I have two files.Data in each file is like :
File1 :
A B C
E F G
X Y Z
File 2:
A C 12
E G 22
X Z 41
I need if first and third column entries ( $1 & $3) of File1 in same row matches with first & second column... (3 Replies)
Discussion started by: suneet17
3 Replies
9. Shell Programming and Scripting
The log file is huge and lot of information, i would like to parse and make a report .
below is the log file looks like:
REPORT DATE: Mon Aug 10 04:16:17 CDT 2017
SYSTEN VER: v1.3.0.9
TERMINAL TYPE: prod
SYSTEM: nb11cu51
UPTIME: 04:16AM up 182 days 57 mins min
MODEL, TYPE, and SN:... (8 Replies)
Discussion started by: amir07
8 Replies
10. Shell Programming and Scripting
Input file1
frame1,dummy,server1, 00C1C N/A RDF1+TDEV RW 51789
frame1,dummy,server1, 00C1D N/A RDF1+TDEV RW 51789
frame1,dummy,server1, 00C1E N/A RDF1+TDEV RW 51789
frame1,dummy,server1, 00C1F N/A RDF1+TDEV RW 51789
frame1,dummy,server1, 00C20 N/A RDF1+TDEV RW 51789
frame1,dummy,server1,... (10 Replies)
Discussion started by: ranjancom2000
10 Replies
LEARN ABOUT DEBIAN
mdbfontset
mdbFontset(5) The m17n Library mdbFontset(5)
NAME
mdbFontset - Fontset
DESCRIPTION
The m17n library loads a fontset definition from the m17n database by the tags <fontset, FONTSET-NAME>. The plist format of the data is as
follows:
FONTSET ::= PER-SCRIPT * PER-CHARSET * FALLBACK *
PER-SCRIPT ::= '(' SCRIPT PER-LANGUAGE + ')'
PER-LANGUAGE ::= '(' LANGUAGE FONT-SPEC-ELEMENT + ')'
PER-CHARSET ::= '(' CHARSET FONT-SPEC-ELEMENT + ')'
FALLBACK ::= FONT-SPEC-ELEMENT
FONT-SPEC-ELEMENT ::= '(' FONT-SPEC [ FLT-NAME ] ')'
FONT-SPEC ::=
'(' [ FOUNDRY FAMILY
[ WEIGHT [ STYLE [ STRETCH [ ADSTYLE ]]]]]
REGISTRY
[ OTF-SPEC ] [ LANG-SPEC ] ')'
SCRIPT is a symbol of script name (e.g. latin, han) or nil. LANGUAGE is a two-letter symbol of language name code defined by ISO 639 (e.g.
ja, zh) or nil.
FONT-SPEC is to specify properties of a font. FOUNDRY to REGISTRY are symbols corresponding to Mfoundry to Mregistry property of a font.
See m17nFont for the meaning of each property.
OTF-SPEC is a symbol specifyng the required OTF features. The symbol name has the following syntax.
OTF-SPEC-NAME ::= ':otf=' SCRIPT LANGSYS ? GSUB-FEATURES ? GPOS-FEATURES ?
SCRIPT ::= SYMBOL
LANGSYS ::= '/' SYMBOL
GSUB-FEATURES ::= '=' FEATURE-LIST ?
GPOS-FEATURES ::= '+' FEATURE-LIST ?
FEATURE-LIST ::= '~' ? FEATURE ( ',' '~' ? FEATURE ',' )
Here, FEATURE is a four-letter Open Type feature.
LANG-SPEC is a symbol specifying the required language support. The symbol name has the following syntax.
LANG-SPEC-NAME ::= ':lang=' LANG
Here, LANG is a two or three-letter ISO-639 language code.
FLT-NAME is a name of Font Layout Table (Font Layout Table).
EXAMPLE
This is an example of PER_SCRIPT.
(han
(ja
((jisx0208.1983-0)))
(zh
((gb2312.1980-0)))
(nil
((big5-0))))
It instructs the font selector to use a font of registry 'jisx0208.1983-0' for a 'han' character (i.e. a character whose Mscript property
is 'han') if the character has Mlanguage text property 'ja' in an M-text and the character is in the repertories of such fonts. Otherwise,
try a font of registry 'gb2312.1980-0' or 'big5-0'. If that 'han' character does not have Mlanguage text property, try all three fonts.
See the function mdraw_text() for the detail of how a font is selected.
COPYRIGHT
Copyright (C) 2001 Information-technology Promotion Agency (IPA)
Copyright (C) 2001-2011 National Institute of Advanced Industrial Science and Technology (AIST)
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License
<http://www.gnu.org/licenses/fdl.html>.
Version 1.6.2 12 Jan 2011 mdbFontset(5)