Hi I have search everywhere for this but I haven't got any result. so here is my question?
I am trying to ask user to enter a name and then searching that name from a file and from a specific column. If user enter something, it should only displaying that name from that specific column and If the user enters quit, then program should quit. I am really having trouble with this. Any help will be appreciate.
Code:
echo "Name:"
while read name
do
if [ $name=0 ]
then
echo $name < filename
cut -c 5-19 filename
#echo "name is $name."
elif [ $name = "Quit" ]
then
exit
fi
done
Last edited by Scott; 01-31-2010 at 09:13 PM..
Reason: Please use code tags
Hi, boss
i have a problem:
i want display one column from a file.
so i think i can used the awk -F"," '{print $number}' XXXX.
but the file contain lots of the column,,,so i can confirm the line number which i need .
so can some body help me to solve this issus.......
PS: how can i... (5 Replies)
Dear All
I had input file as mention below. Now from that file i want to search string "FAULT CODES CLASS" and want to display contain again its. ( ie. 1B4 --4 is in next line. ).
Kindly let me know the possible ways.
<rxmfp:mo=RXOTX-46-5 ; ... (3 Replies)
Dear all
I had input file as mention below. From that i want op as given below. Kindly let me knw possible ways.
Regards
Jaydeep
CONNECTED bscaaa
<rxmfp:mo=RXOTX-46-5 ;
RADIO X-CEIVER ADMINISTRATION
MANAGED OBJECT FAULT INFORMATION
MO BTSSWVER
RXOTX-46-5 ERA-G04-R11-V01
... (5 Replies)
Dear All
I had below mention requirement. Kindly sugguest me possible ways.
Thanks
Regards
Jaydeep
IN PUT FILE:
CELL BROADCAST SHORT MESSAGE SERVICE
MESSAGE DATA
ID CODE GS UPDATE MODE LANG MCO MCL NUMPAGES
50 1000 0 13 MML 1 1
TEXT PAGE
*999*1# SONGS4U@30/M- 1 (3 Replies)
Hi
I need to dispaly only the first column from f1le1 . But i am unable to do with the cut option . Please help me .
The File1 contains the below deatils :
2407765|xyz|774085264795|ABC|2522925531|60.0|01/09/10|CODE1
2408327|xyz|578981547385|ABC|2257881870|60.0|01/09/10| CODE2... (5 Replies)
I like "ls -ltr".
I would like to search for a file in a large directory recursively and and display all the candidates in reverse order.
/usr/bin/find . -name \*.txt
This works.
How do I display the date and sort the file names by the date in reverse order for the entire directory... (1 Reply)
Hi all,
I have 2 files, the first one containing a list of ids and the second one is a master file. I want to search each id from the first file from the 5th col in the second file. The 5th column in master file has values separated by ';', if not a single value is present.
Each id must occur... (2 Replies)
I have a log file which contains information like below (more than 200 ERROR sets).
Here I want to find first .c file and function after "ERROR: AddressSanitizer" line.
If you see here after "ERROR:" line first
file - asfrecohandling.c
function - ASFPotRecoHandling_Create_RecPaxSrvcComp
... (6 Replies)
I have 3 files. Each of those files have the same number of records, however certain records have different values. I would like to grep the field in ALL 3 files and display the output with only the differences in column wise and if possible line number
File1
Name = Joe
Age = 33... (3 Replies)
Hello Team,
My source data (INput) is like below
EPIC1 router EPIC2 Targetdefinition
Exp1 Expres rtr1 Router
SQL SrcQual Exp1 Expres
rtr1 Router EPIC1 Targetdefinition
My output like
SQL SrcQual Exp1 Expres
Exp1 Expres rtr1 Router
rtr1 Router EPIC1 Targetdefinition... (5 Replies)
Discussion started by: sekhar.lsb
5 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)