Sponsored Content
Top Forums Shell Programming and Scripting Need help with extracting field Post 302427859 by Franklin52 on Tuesday 8th of June 2010 06:16:31 AM
Old 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

extracting a field from directory path ??????

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

Extracting Field values for XML file

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

Extracting a field value from a line

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

Extracting field from array

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

awk, comma as field separator and text inside double quotes as a field.

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

Extracting duplicates from a desired field

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

awk - extracting a field

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

Extracting field values from .csv

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

How do I format a Date field of a .CSV file with multiple commas in a string field?

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

Display combination of 4 field uniqe record and along with concatenate 5th and 6th field.

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)
All times are GMT -4. The time now is 08:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy