Hi folks. None of the conventional methods are working for my dilemma:
I have a file in my root directory that has a name comprised of strange characters. When I do an ls, it just hangs at that file until I do a Cntrl-C.
rm ./filename
&
rm \filename
do not work. I am entering the... (4 Replies)
Dear All:
I Have a bunch of files which I'd like to process with a shell script. The problem is that the files have strange characters in their headers, like
�g�8@L-000-MSG2__-ABCD________-FIRA_____-000001___-200806181330-__
��e�
Data from BLABLABLA, Instrument: BLABLA, Date:... (4 Replies)
Hello all,
I'm new to UNIX and new to this forum, so forgive my lack of knowledge. I'm new with editing in vi so I FTP scripts to a Windows machine and edit the script in notepad (when I need to do something quickly). Sometimes when I FTP the script back to the UNIX box, strange characters... (4 Replies)
hi guys,
I am generating a file from datastage (an etl tool).
Now the file is having some junk characters like ( Á,L´±,ñ and so on)..
I want to use the grep function to figure out all the junk characters and their location.
Can somebody help me out in finding it out.. if possible i... (1 Reply)
I've written a script:
find -depth | awk ‘
{
if ( substr($1,length($0)-2,3) == “/1.” )
{ print $1 }
{ system(“awk -f test1.awk “ $1 ) }
}
‘
The idea is that it trundles through a large directory structure looking for files which are named '1.' and then... (3 Replies)
I have two files
file1.txt
angie
mary
susan
file2.txt
angie blond
mary brunnet
susan red
christine blackI want to get this output
angie blond
mary brunnet
susan redI write
grep --file=file1.txt file2.txtand i get no results
i also wrote
cat file1.txt|while read line... (19 Replies)
Is there any command or shell script to grep any special character from a file ? I have a huge file containing millions of user names; the requirement is to find names containing special characters.
#!/bin/bash
for i in `cat username.txt`
do
#COMMAND to grep special character
done
... (3 Replies)
Hello,
I have an x86 server with an ILOM connection that produces strange characters when I perform a start /SP/console, see below:
Oracle(R) Integrated Lights Out Manager
Version 3.0.16.10.a r68533
Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved.
-> start... (9 Replies)
Hi guys,
After compiling a .f90 code and executing it, i get strange characters in the output file like :
^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@
Are these windows characters? how can i get rid of this?
Much appreciated.
Paul (1 Reply)
Discussion started by: Paul Moghadam
1 Replies
LEARN ABOUT PHP
sqlite_escape_string
SQLITE_ESCAPE_STRING(3)SQLITE_ESCAPE_STRING(3)sqlite_escape_string - Escapes a string for use as a query parameterSYNOPSIS
string sqlite_escape_string (string $item)
DESCRIPTION sqlite_escape_string(3) will correctly quote the string specified by $item for use in an SQLite SQL statement. This includes doubling up
single-quote characters ( ') and checking for binary-unsafe characters in the query string.
Although the encoding makes it safe to insert the data, it will render simple text comparisons and LIKE clauses in your queries unusable
for the columns that contain the binary data. In practice, this shouldn't be a problem, as your schema should be such that you don't use
such things on binary columns (in fact, it might be better to store binary data using other means, such as in files).
PARAMETERS
o $item
- The string being quoted. If the $item contains a NUL character, or if it begins with a character whose ordinal value is 0x01,
PHP will apply a binary encoding scheme so that you can safely store and retrieve binary data.
RETURN VALUES
Returns an escaped string for use in an SQLite SQL statement.
NOTES
Note
Do not use this function to encode the return values from UDF's created using sqlite_create_function(3) or sqlite_create_aggre-
gate(3) - use sqlite_udf_encode_binary(3) instead.
Warning
addslashes(3) should NOT be used to quote your strings for SQLite queries; it will lead to strange results when retrieving your
data.
SEE ALSO sqlite_udf_encode_binary(3).
PHP Documentation Group SQLITE_ESCAPE_STRING(3)