06-03-2008
am not sure
, I need a comma as well removing whatever double quotes present, thanks
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello everybody,
I have a sorted text file. some of the lines appear twice or even more. is there an unix utility that removes the extra appearences?
Thanks,
Ido. (7 Replies)
Discussion started by: ginodii
7 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
I'm trying to edit a file using ed on an iphone. I am trying to edit a conf file and have managed to get to the directory where the default.conf file is located, however, when I type ed default.conf all i get is a number and then a blank line and a question mark which is why I am... (1 Reply)
Discussion started by: drewcifer
1 Replies
3. Shell Programming and Scripting
I wrote this script to create and edit a large number of websites based on a template site and a collection of text files which have the relevant strings in them delimited by colons. I run it and the shell doesn't produce any errors, but when it gets to the for loop where it actually has to edit... (2 Replies)
Discussion started by: afroCluster
2 Replies
4. Shell Programming and Scripting
France : 40 : John
Persia : 50 : John -----Database
What i am trying to achieve is to search for a book, and replave the title with the new title
echo -n "Title:"
read Title
echo -n "Author:"
read Author
echo "new Title"
read NewTitle
awk 'BEGIN {... (11 Replies)
Discussion started by: gregarion
11 Replies
5. Programming
Is there any way to erase all the contents of a specific line of a text file and then write something on it?
e.g.
test.txt.old:
qwert
asdfg
zxcbv=0
test.txt.new
qwerty
asdfg
hello=0
is this possible with C++ ?:confused: (1 Reply)
Discussion started by: hakermania
1 Replies
6. Shell Programming and Scripting
I have a text file that has data like:
Data "12345#22"
Fred
ID 12345
Age 45
Wilma
Dino
Data "123#22"
Tarzan
ID 123
Age 33
Jane
I need to figure out a way of adding 1,000,000 to the specific lines (always same format) in the file, so it becomes:
Data "1012345#22"
Fred
ID... (16 Replies)
Discussion started by: say170
16 Replies
7. Shell Programming and Scripting
Hi,
I have text file with the header like this
tracking_id condition replicate FPKM
XLOC_000001 alpha 1 10.3199
XLOC_000001 alpha 0 10.3686
XLOC_000001 alpha 2 15.5619
...
With the first column being genes, the second being the condition, the third... (5 Replies)
Discussion started by: 4galaxy7
5 Replies
8. Shell Programming and Scripting
Dear Guru's
I'm using Putty and want to edit a file. I know we generally use vi editor to do it. As I'm not good in using vi editor, I want to convert the vi into something like text pad. Is there any option in Putty to do the same ? Thanks for your response.
Srini (6 Replies)
Discussion started by: thummi9090
6 Replies
9. UNIX for Dummies Questions & Answers
Good morning all, I have a machine running IRIX and I need to edit a text file on the terminal that is literally thousands of lines. Does anyone know the most efficient way to edit portions of files like these? Obviously simply using the vi command isn't going to work since I get a too many lines... (1 Reply)
Discussion started by: James C
1 Replies
LEARN ABOUT PHP
pg_escape_identifier
PG_ESCAPE_IDENTIFIER(3) PG_ESCAPE_IDENTIFIER(3)
pg_escape_identifier - Escape a identifier for insertion into a text field
SYNOPSIS
string pg_escape_identifier ([resource $connection], string $data)
DESCRIPTION
pg_escape_identifier(3) escapes a identifier (e.g. table, field names) for quering the database. It returns an escaped identifier string
for PostgreSQL server. pg_escape_identifier(3) adds double quotes before and after data. Users should not add double quotes. Use of this
function is recommended for identifier parameters in query. For SQL literals (i.e. parameters except bytea), pg_escape_literal(3) or
pg_escape_string(3) muse be used. For bytea type fields, pg_escape_bytea(3) must be used instead.
Note
This function has internal escape code and can also be used with PostgreSQL 8.4 or less.
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $data
- A string containing text to be escaped.
RETURN VALUES
A string containing the escaped data.
EXAMPLES
Example #1
pg_escape_identifier(3) example
<?php
// Connect to the database
$dbconn = pg_connect('dbname=foo');
// Escape the table name data
$escaped = pg_escape_identifier($table_name);
// Select rows from $table_name
pg_query("SELECT * FROM {$escaped};");
?>
SEE ALSO
pg_escape_literal(3), pg_escape_bytea(3), pg_escape_string(3).
PHP Documentation Group PG_ESCAPE_IDENTIFIER(3)