02-03-2009
I follow your suggestion
name=$(pgsql -c "select name from teacher")
name=${name% (*}
echo "${name#*- }"
I got
"name"
"------------"
" Mary Lee "
"(1 row)"
Any ideas? Thanks again!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have several lines like this ones:
123456789abcde /aa/bb/123456_$data.log
123456789abcde /aa/bb/123456_not_a_data_log
987654321ab /aa/bb/xpto123456_$data.log
...
How do I get into a variable the value "/aa/bb/123456_$data.log" , searching only for the beggining and ending... (3 Replies)
Discussion started by: Scarlos
3 Replies
2. Shell Programming and Scripting
This is probably pretty simple butI'm not sure how to best go about it.
If I have
FILE="myBigLongFileName_1.xls"
FILE_PREFIX=`echo $FILE| cut -d"." -f1`
# that gives "myBigLongFileName_1"
All i want to do now is chop the "_1" from the end of $FILE_PREFIX
Any ideas anyone? (3 Replies)
Discussion started by: djkane
3 Replies
3. Shell Programming and Scripting
i have a strings
abc-def.csv
ghi-jkl.csv
i want to make it as
abc-*-def.xyz
ghi-*-jkl.xyz
How to do it?. (5 Replies)
Discussion started by: senthilk615
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a value of a filepath in a variable
DATAFILE with value as "customtop/gpsore37/gepspo/1.0/bin/ashoka.csv
".
Now i want the value of last 4 charcters in to another variable.
That is EXTENSION = .csv
How can i do this in Shell scripting
Thanks in advance
Alla Kishore (8 Replies)
Discussion started by: alla.kishore
8 Replies
5. UNIX for Dummies Questions & Answers
I need to check the occurrence of one string within another.
code
********************
if ;then do something done
********************
Thanks (7 Replies)
Discussion started by: w020637
7 Replies
6. UNIX for Dummies Questions & Answers
Hi
I use the below cmd to get the list of files that are modified than <temp> file in the <path> diretory
cmd:find <path> -name '*.zip' -type f -newer <temp> -print
i am getting all the list of files that are new or modified, with abs path, i want to copy all of these files to a... (3 Replies)
Discussion started by: Naveen_5960
3 Replies
7. Shell Programming and Scripting
I have a string '<Hi>abc</Hi>"
How to print "abc" (6 Replies)
Discussion started by: sandy1028
6 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I hav a string lets say aa.txt:bb:txt
length of the string can vary.. I have to keep the token inside a array and the delimiter is : plz send me the code (2 Replies)
Discussion started by: Deekay.p
2 Replies
9. Shell Programming and Scripting
Hi All,
I have a ouput string likes 'u8wos' or 'u10acsd' or somthing else 'u{number}{any characters}'and I want to get the number behind the letter 'u' by bash shell.
Thanks
Damon (11 Replies)
Discussion started by: Damon_Qu
11 Replies
10. UNIX for Dummies Questions & Answers
Hi,
My requirement is to get the substring and then remove special character.
Ex
I have data like T_SYSTEM_XXXXX_YYYY_ZZZ
I want to get XXXXXYYYYZZZ
the part after T_SYSTEM is varying it might be XXX_YY or just XX
can you tell me which all commands i have to use.
i understand i... (5 Replies)
Discussion started by: Mohammed_Tabish
5 Replies
LEARN ABOUT PHP
mssql_result
MSSQL_RESULT(3) MSSQL_RESULT(3)
mssql_result - Get result data
SYNOPSIS
string mssql_result (resource $result, int $row, mixed $field)
DESCRIPTION
mssql_result(3) returns the contents of one cell from a MS SQL result set.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $row
- The row number.
o $field
- Can be the field's offset, the field's name or the field's table dot field's name (tablename.fieldname). If the column name has
been aliased ('select foo as bar from...'), it uses the alias instead of the column name.
Note
Specifying a numeric offset for the $field argument is much quicker than specifying a fieldname or tablename.fieldname argu-
ment.
RETURN VALUES
Returns the contents of the specified cell.
EXAMPLES
Example #1
mssql_result(3) example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
for ($i = 0; $i < mssql_num_rows($query); ++$i) {
echo mssql_result($query, $i, 'username'), PHP_EOL;
}
}
// Free the query result
mssql_free_result($query);
?>
The above example will output something similar to:
Kalle
Felipe
Emil
Ross
Example #2
Faster alternative to above example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
while ($row = mssql_fetch_array($query)) {
echo $row['username'], PHP_EOL;
}
}
// Free the query result
mssql_free_result($query);
?>
NOTES
Note
When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As
these functions return the contents of multiple cells in one function call, they're MUCH quicker than mssql_result(3).
SEE ALSO
Recommended high-performance alternatives: mssql_fetch_row(3), mssql_fetch_array(3), mssql_fetch_assoc(3), mssql_fetch_object(3).
PHP Documentation Group MSSQL_RESULT(3)