08-29-2006
The failuer record contains "!" in first column .
The row which doesnt contain ! , in that row 6 and 7 column is the version and Host name.
Product name are YRS , SiCat OPC PSd and nanocad
O/p i need this way
Version | Host | YRS | SiCat | OPC | PSD |nanocad
10 | Krachel | 2 | 4 | 5 | 0 | 1
10_64 | limo | 3 | 2 | 1 | 1 | 0
The first file data contains 2 columns
daily/DB/attach/attach_redundancy.exp SiCat
daily/DB/help/help.exp YRS
daily/DB/hole_fail_rate/hfr-circular.exp YRS
I have compare fails from first file with second file first column and print the total no of fails as per the product .
I can hardcored the Product name in shell script because product name are SiCat ,YRS ,OPC and PSD .
Please do help me
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have this sample data:
test01 --- abc-01 name1
abc-02 name2
abc-03 name3
test02 --- abc-20 name4
abc-21 name5
test03 --- abc-22 name6
abc-23 name7
i want to generate a file... (13 Replies)
Discussion started by: inquirer
13 Replies
2. Shell Programming and Scripting
hello, is there a way to seperate commands that are on the same line?
ie: echo "yes count(*)>0:" $passvar > dsp cat dsp cat dsp > log
i'm trying to put these 3 commands on the same line, but when i do they all get concatenated into 1 lieteral
if i put the cat commands on... (3 Replies)
Discussion started by: bobk544
3 Replies
3. Shell Programming and Scripting
i want to write a script in Bash Shell that accept a list of files.an example of file is
4334:234
322.345:32
234:3452 e.t.c
each file only contain lines like num1:num2
i want to count the lines of this file and find the summary of X=4334+322.345+234 and Y=234+32+3452 (1 Reply)
Discussion started by: nektarios4u
1 Replies
4. Shell Programming and Scripting
Dear all,
i dont know how to split one variable value in 2 variable. please send me any example.
variable1= "abcde developer"
now i want to seperate the values and seperator is space. (6 Replies)
Discussion started by: intikhabalam
6 Replies
5. Shell Programming and Scripting
Hi guys,
i have a problem which im hoping you will be able to help me with.
I have follwing output :-
-------------------------------------------------------------------------------
NSTEP = 407000 TIME(PS) = 43059.000 TEMP(K) = 288.46 PRESS = 0.0
Etot = -2077.4322 ... (2 Replies)
Discussion started by: Mish_99
2 Replies
6. Shell Programming and Scripting
Hi
I have a data file in UNIX as follows. I need to send this file in Mail as excel format. but the problem i face is i get the data all in single cells per row. what can i do to get the data in seperate cells.
File -> attachment.xls
data data data data
data1 data1 ... (1 Reply)
Discussion started by: vj8436
1 Replies
7. UNIX for Dummies Questions & Answers
Hi, I'm a newbie to unix. I have a txt file with my data, a list of events. Each event comes with a unix time. I want to seperate a months worth of events into those that occur during the day, and those at night. I have no clue how to go about this, please can someone push me in the right... (6 Replies)
Discussion started by: pmasterkim
6 Replies
8. UNIX for Dummies Questions & Answers
i have something like this
abc 123 3234 1234 * qqoiki * abc 4533 34 1234 * lloiki *
i want to make it two lines i,e.,abc 123 3234 1234 * qqoiki *
abc 4533 34 1234 * lloiki * how to do that ? (13 Replies)
Discussion started by: anurupa777
13 Replies
9. UNIX for Dummies Questions & Answers
Hi all
I need your help to separate colomns based on "-" delimiter for a very big file 30 millions rows
I have a colmun looking like this :
clomun 1
1-100000989-A_ATC
1-10000179-AAAAA
1-100002154-TGTTA
1-100002155-GTTAG
1-100002443
1-100002490
1-100002619
I need to separte in three... (5 Replies)
Discussion started by: biopsy
5 Replies
10. UNIX for Beginners Questions & Answers
For shell script. If I had two separate files, file.txt and file1.txt and each has just a list of names from the who command. How would I create an if loop to compare each name? (1 Reply)
Discussion started by: Eric7giants
1 Replies
LEARN ABOUT PHP
pdostatement.fetchcolumn
PDOSTATEMENT.FETCHCOLUMN(3) 1 PDOSTATEMENT.FETCHCOLUMN(3)
PDOStatement::fetchColumn - Returns a single column from the next row of a result set
SYNOPSIS
public mixed PDOStatement::fetchColumn ([int $column_number])
DESCRIPTION
Returns a single column from the next row of a result set or FALSE if there are no more rows.
Note
PDOStatement.fetchColumn(3) should not be used to retrieve boolean columns, as it is impossible to distinguish a value of FALSE from
there being no more rows to retrieve. Use PDOStatement.fetch(3) instead.
PARAMETERS
o $column_number
- 0-indexed number of the column you wish to retrieve from the row. If no value is supplied, PDOStatement.fetchColumn(3) fetches
the first column.
RETURN VALUES
PDOStatement.fetchColumn(3) returns a single column in the next row of a result set.
Warning
There is no way to return another column from the same row if you use PDOStatement.fetchColumn(3) to retrieve data.
EXAMPLES
Example #1
Return first column of the next row
<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();
print("Fetch the first column from the first row in the result set:
");
$result = $sth->fetchColumn();
print("name = $result
");
print("Fetch the second column from the second row in the result set:
");
$result = $sth->fetchColumn(1);
print("colour = $result
");
?>
The above example will output:
Fetch the first column from the first row in the result set:
name = lemon
Fetch the second column from the second row in the result set:
colour = red
SEE ALSO
PDO.query(3), PDOStatement.fetch(3), PDOStatement.fetchAll(3), PDO.prepare(3), PDOStatement.setFetchMode(3).
PHP Documentation Group PDOSTATEMENT.FETCHCOLUMN(3)