07-07-2013
Thank you so much. But does that also create a new file and write all the "good" data into it without overwriting?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hey friends,
Here I am with another query. I have a TXT file.
Foe an example
EX ID : B-Mezine
....
...
...
Some lines of text (Not fixed in length n no of lines)..
...
...
..
END EX ID
Some blank lines in between two records(Not fixed in numbers)
EX ID : B-Mezine
....
...... (20 Replies)
Discussion started by: anushree.a
20 Replies
2. Shell Programming and Scripting
Hii friends,
I am a newbie to unix/shell scripting and got stuck in implementing a functionality.Dear experts,kindly spare some time to bring me out of dark pit :confused:..
My requirement is somewhat wierd,let me explain what i have and what i need to do...
1) there are several excel... (1 Reply)
Discussion started by: 5ahen
1 Replies
3. UNIX for Dummies Questions & Answers
hiii, Help me out..i have a huge set of data stored in a file.This file has has 2 columns which is latitude & longitude of a region. Now i have a program which asks for the number of points & based on this number it asks the user to enter that latitude & longitude values which are in the same... (7 Replies)
Discussion started by: reva
7 Replies
4. Programming
Hello, i'm new to the forum and so am i to C programming.
Recently i've gotten a task to create a program that will read an existing .bin file and copy the data to a non existing (so i have to create it) .txt file (some type of conversion)
Now, i now how to put the arguments, opening and... (5 Replies)
Discussion started by: Lyric
5 Replies
5. Programming
I have a series of observations of which one column is sometimes missing (zero):
date temp delta
1977 284.54 29.84
1978 149.82 0
1979 320.71 28.45
1980 176.76 0
1981 854.65 0
1984 817.65 0
1985 990.58 27.98
1986 410.21 0
1987 405.93 0
1988 482.9 0
What I would like to achieve is a... (8 Replies)
Discussion started by: figaro
8 Replies
6. Shell Programming and Scripting
I have the following that I'd like to do:
1. I have split a file into separate files that I placed into the /tmp directory. These files are named F1 F2 F3 F4.
2. In addition, I have several directories which are alphabetized as dira dirb dirc dird.
3. I'd like to be able to copy F1 F2 F3 F4... (2 Replies)
Discussion started by: newbie2010
2 Replies
7. Solaris
Hello people,
I have a question regarding transferring data from one file server to another.
The server is a Solaris 9 box
The old file server is connected via Ethernet cable, and the new file server we are switching is a Fiber channel.
can I use the
dd if=server:/app1 of=server2:/app1
... (2 Replies)
Discussion started by: br1an
2 Replies
8. UNIX for Dummies Questions & Answers
Hi
I think this should be relatively simple but I can't figure it out. I have several files with the same name in different folders within a directory (the output of a program that I ran). Something like this:
./myAnalysis/item1/round1/myoutput.txt
./myAnalysis/item1/round2/myoutput.txt... (2 Replies)
Discussion started by: jullee
2 Replies
9. Programming
I need to fix an SQL statement in MySQL that should calculate a field using values from two of the columns and I prefer to do this using set-based programming, ie not procedural. What needs to happen is that in a separate column called "delta" the value of "level" is copied depending on whether... (3 Replies)
Discussion started by: figaro
3 Replies
10. UNIX for Beginners Questions & Answers
Hello,
I have a log file that has several sections "BEGIN JOB, End of job" like in the following example:
19/06/12 - 16:00:57 (27787398-449294): BEGIN JOB j1(27787398-449294) JOB1
19/06/12 - 16:00:57 (27787398-449294): DIGIT: 0
number of present logs : 1
19/06/12 - 16:00:57... (4 Replies)
Discussion started by: mvalonso
4 Replies
LEARN ABOUT PHP
sqlite_popen
SQLITE_POPEN(3) SQLITE_POPEN(3)
sqlite_popen - Opens a persistent handle to an SQLite database and create the database if it does not exist
SYNOPSIS
resource sqlite_popen (string $filename, [int $mode = 0666], [string &$error_message])
DESCRIPTION
This function behaves identically to sqlite_open(3) except that is uses the persistent resource mechanism of PHP. For information about
the meaning of the parameters, read the sqlite_open(3) manual page.
sqlite_popen(3) will first check to see if a persistent handle has already been opened for the given $filename. If it finds one, it returns
that handle to your script, otherwise it opens a fresh handle to the database.
The benefit of this approach is that you don't incur the performance cost of re-reading the database and index schema on each page hit
served by persistent web server SAPI's (any SAPI except for regular CGI or CLI).
Note
If you use persistent handles and have the database updated by a background process (perhaps via a crontab), and that process re-
creates the database by overwriting it (either by unlinking and rebuilding, or moving the updated version to replace the current
version), you may experience undefined behaviour when a persistent handle on the old version of the database is recycled.
To avoid this situation, have your background processes open the same database file and perform their updates in a transaction.
PARAMETERS
o $filename
- The filename of the SQLite database. If the file does not exist, SQLite will attempt to create it. PHP must have write permis-
sions to the file if data is inserted, the database schema is modified or to create the database if it does not exist.
o $mode
- The mode of the file. Intended to be used to open the database in read-only mode. Presently, this parameter is ignored by the
sqlite library. The default value for mode is the octal value 0666 and this is the recommended value.
o $error_message
- Passed by reference and is set to hold a descriptive error message explaining why the database could not be opened if there was
an error.
RETURN VALUES
Returns a resource (database handle) on success, FALSE on error.
SEE ALSO
sqlite_open(3), sqlite_close(3), sqlite_factory(3).
PHP Documentation Group SQLITE_POPEN(3)