12-07-2009
I am not sure I understand. You do not need the while read loop anymore, just the tr statement. If you do that, what gets truncated?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am stuck with a problem here.
Suppose i have a variable which is assigned some string containing special charatcers. for eg:
$a="abcdef^bbwk#kdbcd@";
I have to remove the special characters using Perl. The text is assigned to the variable implicitly.
How to do it? (1 Reply)
Discussion started by: agarwal
1 Replies
2. Shell Programming and Scripting
I need to add "new lines" of text with special characters, to specific lines in the file. There are 3 modifications needed. Been testing 2 here without success.
#!/usr/bin/perl
use FileHandle;
$file=FileHandle->new;
$FILENAME="/opt/etc/usr/file.txt";
$file->open ("<$FILENAME") or die... (13 Replies)
Discussion started by: A4ron4perl
13 Replies
3. Solaris
I finally figured out how to remove a file or directory with special characters in the name. It's kind of rudimentary so I thought I would share it with everyone:
find .inum -exec rm -rf {} \; (7 Replies)
Discussion started by: jastanle84
7 Replies
4. Shell Programming and Scripting
Hello all
I am getting data like
col1 | col2 | col3
asdafa | asdfasfa | asf*&^sgê
345./ |sdfasd23425^%^&^ | sdfsa23
êsfsfd | sf(* | sdfsasf
My requirement is like
I have to to read the file and remove all special characters and hex characters ranging form 00-1f from 1st column, remove %"'... (1 Reply)
Discussion started by: vasuarjula
1 Replies
5. Shell Programming and Scripting
(5 Replies)
Discussion started by: number10
5 Replies
6. UNIX for Advanced & Expert Users
My application generate file but it have special characters in these file.
I would like to clear special characters by vi editor and not use cat /dev/null > to_file
I try to remove characters manually, but I'm can not!
root@MyHost /tmp> ls -l puzzle.txt
-rw-r--r-- 1 root system ... (5 Replies)
Discussion started by: arm_naja
5 Replies
7. Shell Programming and Scripting
Hi,
I have a "|" delimited file that is exported from a database.
There is one column in the file which has description/comments entered by some application user. It has "Control-M" character and "New Line" character in between the text.
Hence, when i export the data, this record with the new... (4 Replies)
Discussion started by: tarun.trehan
4 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I need to create a test text file with the special characters \342\200\223 in it and to be able to use sed maybe to delete them
I tried doing it using vi by pressing CTRL-V and then typing 342 but it does not work. After pressing CTRL-V and typing 342 it seems to just insert the numbers... (1 Reply)
Discussion started by: newbie_01
1 Replies
9. UNIX for Beginners Questions & Answers
Hi Guys,
My requirement is to remove any invisible and special characters from the file like control M(carriage return) and alt numerics and it should not replace @#!$%
abc|xyz|acd¥£ó
adc|123| 12áí
Please help on this.
Thanks
Rakesh (1 Reply)
Discussion started by: rakeshp
1 Replies
10. UNIX for Advanced & Expert Users
Hi Guys,
My requirement is to remove any invisible and special characters from the file like control M(carriage return) and alt numerics and it should not replace @#!$%
abc|xyz|acd¥£ó
adc|123| 12áí
Please help on this.
Thanks
Rakesh (1 Reply)
Discussion started by: rakeshp
1 Replies
LEARN ABOUT PHP
oci_fetch_assoc
OCI_FETCH_ASSOC(3) OCI_FETCH_ASSOC(3)
oci_fetch_assoc - Returns the next row from a query as an associative array
SYNOPSIS
array oci_fetch_assoc (resource $statement)
DESCRIPTION
Returns an associative array containing the next result-set row of a query. Each array entry corresponds to a column of the row. This
function is typically called in a loop until it returns FALSE, indicating no more rows exist.
Calling oci_fetch_assoc(3) is identical to calling oci_fetch_array(3) with OCI_ASSOC + OCI_RETURN_NULLS.
PARAMETERS
o $statement
-A valid OCI8 statement identifier created by oci_parse(3) and executed by oci_execute(3), or a REF CURSOR statement identifier.
RETURN VALUES
Returns an associative array. If there are no more rows in the $statement then FALSE is returned.
EXAMPLES
Example #1
oci_fetch_assoc(3) Example
<?php
$conn = oci_connect('hr', 'welcome', 'localhost/XE');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$stid = oci_parse($conn, 'SELECT department_id, department_name FROM departments');
oci_execute($stid);
while (($row = oci_fetch_assoc($stid)) != false) {
echo $row['DEPARTMENT_ID'] . " " . $row['DEPARTMENT_NAME'] . "<br>
";
}
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
See oci_fetch_array(3) for more examples of fetching rows.
SEE ALSO
oci_fetch(3), oci_fetch_all(3), oci_fetch_array(3), oci_fetch_object(3), oci_fetch_row(3).
PHP Documentation Group OCI_FETCH_ASSOC(3)