06-08-2010
You can redirect the output to a file with a .csv extension and open it with Excel.
Regards
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I'll be getting a directory path as the input to the script.
E.g. 1 abc/fsg/sdfhgsa/fasgfsd/adfghad/XXX/fhsad
e.g. 2 sadfg/sadgjhgds/sd/dtuc/cghcx/dtyue/dfghsdd/XXX/qytq
This input will be stored in a variable.
My query is how to extract the field in a variable VAR which occurs... (15 Replies)
Discussion started by: skyineyes
15 Replies
2. Programming
i have an input file of XML type with data like
<nx-charging:additional-parameter name="NX_INTERNATIONALIZED_CLID" value="919427960829"/><nx-charging:finalStatus>RESPONSE , Not/Applicable , OK</nx-charging:finalStatus></nx-charging:process>
i want to extract data such that i get the output... (3 Replies)
Discussion started by: junaid.nehvi
3 Replies
3. Shell Programming and Scripting
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.11.255)(PORT = 1540)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CSMFIRE03)))
I would like to extract the CSMFIRE03.
I have no clue which command to use. Could... (5 Replies)
Discussion started by: Naresh Akkal
5 Replies
4. Shell Programming and Scripting
I have a problem with the following lines of code:
SaveIFS=$IFS
IFS="/"
declare -a Array=($1)#take unix path, split by '/'
website=${Array} #stores website name
The confusing part is that it works on one machine, but not on the other.
If the code is... (2 Replies)
Discussion started by: montana24
2 Replies
5. Shell Programming and Scripting
Hi, all
I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes.
sample input:
for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies
6. Shell Programming and Scripting
Hello,
I have a file of group names and GID's (/etc/group) and I want to find the duplicate group names and put them in a file. So there are 2 fields, i.e.:
audit 10
avahi 70
avahi-autoipd 103
bellrpi 605
bin 1
bin 2
bord 512
busobj 161
bwadm 230
cali81 202
card 323
cardiff 901
cbm... (2 Replies)
Discussion started by: mgb
2 Replies
7. Shell Programming and Scripting
Hi all,
I have automated a process of doing a sanity check for the DDL created by other DBA's. But i am stuck at a point.
while reading a file in the awk, PI of the table is defined as
)PRIMARY INDEX test_abc(ACCT_ID)
PARTITION BY RANGE_N(AUTHZN_MTCH_IND BETWEEN DATE '2011-10-01' AND... (1 Reply)
Discussion started by: ysvsr1
1 Replies
8. Shell Programming and Scripting
How can I select the bold fields from the following?
"CLLI","SWREL","RPTDATE","RPTIME","TZ","RPTTYPE","RPTPD","IVALDATE","IVALSTART","IVALEND","NUMENTIDS"
"tklc9010801","EAGLE5 45.0.0-64.70.1","2013-08-07","02:01:50","MST ","COMPONENT MEASUREMENTS ON... (4 Replies)
Discussion started by: leghorn
4 Replies
9. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
10. Shell Programming and Scripting
Table
ACN|NAME|CITY|CTY|NO1|NO2
115|AKKK|ASH|IND|10|15
115|AKKK|ASH|IND|20|20
115|AKKK|ASH|IND|30|35
115|AKKK|ASH|IND|30|35
112|ABC|FL|USA|15|15
112|ABC|FL|USA|25|20
112|ABC|FL|USA|25|45
i have written shell script using cut command
and awk programming getting error correct it and add... (5 Replies)
Discussion started by: udhal
5 Replies
mccs(1) Debian User's Manual mccs(1)
NAME
mccs - package dependency solver
SYNOPSIS
mccs [options]
DESCRIPTION
mccs (which stands for Multi Criteria CUDF Solver) is a solver for package dependency problems expressed in the CUDF format. By default,
mccs reads a problem specification from standard input, and writes the solution to standard output.
OPTIONS FOR CONTROLLING INPUT
/OUTPUT
-i file
Read input from file file instead of standard input.
-o file
Write the solution to file instead of standard output.
-fo full solution output
-v n set verbosity level to n.
-h print this help
OPTIONS FOR SELECTING THE SOLVER ENGINE
By default, mccs uses the cbc solving engine.
-lpsolve
use lpsolve solver
-lp lpsolver
specify a solving engine that takes the cplex input format. lpsolver is the path of a script that takes as input the file name con-
taining the cplex input, and that produces the solution on standard output (an example for scip is given in
/usr/share/doc/mccs/engines/sciplp).
-pblib pbsolver
use pseudo-Boolean solver pbsolver as solving engine.
-nosolve
do not solve the problem (for debugging)
OPTIONS FOR CONTROLLING CONSTRAINT GENERATION
-noreduce
do not reduce the initial problem
-only-agregate-constraints
generate only agregate constraints
-only-desagregate-constraints
generate only deagregate constraints (default)
-all-constraints
generate all kind of constraints (ensure redundancy)
OPTIONS FOR CONTROLLING OPTIMIZATION
See the file /usr/share/doc/mccs/README.optimization-criteria for a full grammar of optimization criteria.
EXAMPLES
An example input file can be found at /usr/share/doc/mccs/examples/legacy.cudf.
mccs -i legacy.cudf
calls mccs on examples/legacy.cudf and prints the solution on stdout. With such a call mccs will resort to the default underlying solver
cbc and use a default criterion to solve the problem.
mccs -i legacy.cudf -o sol -lexagregate[-removed,-changed]
-lpsolve
Here, mccs puts the solution into the file "sol" and solves the problem using the lpsolve solver with the paranoid criterion, which con-
sists of first minimizing the number of removed packaged, and then the number of packages that change installation status or installed ver-
sion.
mccs -i legacy.cudf -o sol
-lexsemiagregate[-removed,-notuptodate,
-nunsat[recommends:,true],-new]
The criterion used here is the trendy criterion, which consists of first minimizing the number of package removals, then to minimize the
number of installed packages that are installed in a version older the most recent available version, then to minimize the number of recom-
mendations of installed packages that are not satisfied, and finally the number of newly installed packages.
AUTHOR
mccs has been written by Claude Michel <cpjm@polytech.unice.fr>. The development of mccs has been partly supported by the European research
project Mancoosi.
9 May 2011 mccs(1)