I have a variable whose value is
I="user1:x:1100:1200:ID for user1:/home/user1:/bin/ssh-dummy-shell"
I want to replace the last part '/bin/ssh-dummy-shell' with '/bin/true'
I tried using sed but it garbled
sed 's/\/bin\/ssh-dummy-shell/\/bin\/true' $I
Thanks for the help (5 Replies)
Is there an easy way of doing this
cat file1
jkasjhjgfg LTRIM(RTRIM(aa_bb_cde))
aragsfdg LTRIM(RTRIM(aa_bb_cde)) aregfafdgfg
sdgsfdagdfg gadfg
eafgsadgsa
asdgsfdgag LTRIM(RTRIM(aa_bb_cde)) rfghsdfhd
I want to replace each occurence of LTRIM(RTRIM($x)) with
LENGTH(LTRIM(RTRIM($x)))=0... (4 Replies)
Hi :)
I have some problems with "FOR"...
I have a text file in this format:
name1
www.link1/random_number
name2
www.link2/random_number
name3
www.link3/random_number
...
(Names and info changes)
Now, I need: (4 Replies)
Hi this is my first time posting ever. I'm relatively new in using AWK/SED, I've been trying many a solution. I'm trying to replace the 59th column in a file where if I encounter '' then I would like to replace it with the word NULL.
example
0 , '' , '' , 0 , 195.538462
change it to
0... (5 Replies)
Hi Everyone,
I am new to this forum and new to sed/awk programming too !!
I need to find particular string in file1(text file) and replace it with a value from another text file(file2) the file2 has only one line and the value to be replaced with is in the second column.
file 1:
(assert (=... (21 Replies)
Hi all,
Hereby wish to have your advise for below:
Main concept is
I intend to get current directory of my script file.
This script file will be copied to /etc/init.d.
A string in this copy will be replaced with current directory value.
Below is original script file:
... (6 Replies)
Hi,
I have a ksh script where I am trying to mask the password in the log files.
$loc - is my directory
$PGUIDE_DB_USER_PSW - is a variable that holds the password I am looking for
find $loc/logs -type f -exec sed -i "s/$PGUIDE_DB_USER_PSW/*****/"g {} \;
I get an error:
... (2 Replies)
All,
I have thousands of lines in a file with following format
DATA=_ONE_XXX_YYY_CCC_HHHG_
DATA1=_GGG_JJJJ_HHH_UUU_JJJJ_HHHH_LLL_
DATA3=_MMM_GG_NN_QQQQ_FFF_III_
I want to replace _ with . by ignoring the first (=_) and last (_)
So that out put should looks like... (4 Replies)
Greetings. I have a three column file, and there are some numbers in the second column that are <1. However I need all numbers to be positive, thus need to replace all those numbers with just one. I feel like there must be a simple way to use awk to find these numbers and sed to replace but can't... (5 Replies)
Hi All
I have one file with multiple lines in it, each line has static text and some variable enclosed in <<filename>> as well. e.g. as below
123, <<file1.txt>> this is my name, I stay at <<city.txt>> Thanks for visiting
348384y, this is my name <<fileabc.txt>>, I stay at near the mall of... (8 Replies)
Discussion started by: reldb
8 Replies
LEARN ABOUT PHP
sqlite_fetch_array
SQLITE_FETCH_ARRAY(3)SQLITE_FETCH_ARRAY(3)sqlite_fetch_array - Fetches the next row from a result set as an arraySYNOPSIS
array sqlite_fetch_array (resource $result, [int $result_type = SQLITE_BOTH], [bool $decode_binary = true])
DESCRIPTION
Object oriented style (method):
array SQLiteResult::fetch ([int $result_type = SQLITE_BOTH], [bool $decode_binary = true])
array SQLiteUnbuffered::fetch ([int $result_type = SQLITE_BOTH], [bool $decode_binary = true])
Fetches the next row from the given $result handle. If there are no more rows, returns FALSE, otherwise returns an associative array rep-
resenting the row data.
PARAMETERS
o $result
- The SQLite result resource. This parameter is not required when using the object-oriented method.
o $result_type
-The optional $result_type parameter accepts a constant and determines how the returned array will be indexed. Using SQLITE_ASSOC
will return only associative indices (named fields) while SQLITE_NUM will return only numerical indices (ordinal field numbers).
SQLITE_BOTH will return both associative and numerical indices. SQLITE_BOTH is the default for this function.
o $decode_binary
-When the $decode_binary parameter is set to TRUE (the default), PHP will decode the binary encoding it applied to the data if it
was encoded using the sqlite_escape_string(3). You should normally leave this value at its default, unless you are interoperating
with databases created by other sqlite capable applications.
RETURN VALUES
Returns an array of the next row from a result set; FALSE if the next position is beyond the final row.
The column names returned by SQLITE_ASSOC and SQLITE_BOTH will be case-folded according to the value of the sqlite.assoc_case configuration
option.
EXAMPLES
Example #1
Procedural example
<?php
$dbhandle = sqlite_open('sqlitedb');
$query = sqlite_query($dbhandle, 'SELECT name, email FROM users LIMIT 25');
while ($entry = sqlite_fetch_array($query, SQLITE_ASSOC)) {
echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email'];
}
?>
Example #2
Object-oriented example
<?php
$dbhandle = new SQLiteDatabase('sqlitedb');
$query = $dbhandle->query('SELECT name, email FROM users LIMIT 25'); // buffered result set
$query = $dbhandle->unbufferedQuery('SELECT name, email FROM users LIMIT 25'); // unbuffered result set
while ($entry = $query->fetch(SQLITE_ASSOC)) {
echo 'Name: ' . $entry['name'] . ' E-mail: ' . $entry['email'];
}
?>
SEE ALSO sqlite_array_query(3), sqlite_fetch_string(3).
PHP Documentation Group SQLITE_FETCH_ARRAY(3)