03-18-2009
@OP, this kind of problem should be solved at the source. I am sure your data comes from some database. Some when you do queries and extract those data out, just insert some characters to signify null value in the columns. This way, you won't need to spend time trying to fix it later.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a datafile having structure like
col1,col2,col3
col1,col2,col3,col4,col5
col1,col2,col3,col4,col5
.....
Can we take only first row of values from datafile and put into respective variable.
How col1 can be captured in a variable called v_col1 from unix script.
like first row(only)... (1 Reply)
Discussion started by: u263066
1 Replies
2. Shell Programming and Scripting
Guys -- I am noob and I am really strugging on this one. I cant even write the pseudo code for it. I have a file that spits values in individual rows as such:
file:
user date type size
joe 2005-25-09 log 1
joe 2005-25-09 snd 10
joe 2005-25-09 rcd 12
joe 2005-24-09 log 2
joe... (1 Reply)
Discussion started by: made2last
1 Replies
3. Shell Programming and Scripting
Hi Guys,
I have a file as follows:
a 1
b 786
c 90709
d 99
a 9875
b 989
c 887
d 111
I want:
a 1 9875
b 786 989 (3 Replies)
Discussion started by: npatwardhan
3 Replies
4. Shell Programming and Scripting
Hello,
I have an input file like the following:
11_3_4
2_1_35
3_15__
_16989
Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies
5. Shell Programming and Scripting
Hello,
I want to add a new row to a file to insert data without deleting the previous data there.
Example:
file
a
b
c
d
Output
a
b
newtext
c (6 Replies)
Discussion started by: joseamck
6 Replies
6. UNIX for Advanced & Expert Users
Hi,
I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated.
Thanks. (4 Replies)
Discussion started by: sktkpl
4 Replies
7. Emergency UNIX and Linux Support
Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :(
Dear community,
I have a table with two rows like:
Row1 Row2
======= =======
7,3 text 1
1,3 text 2
1,2,3 blabla
What i need to do is add/copy... (2 Replies)
Discussion started by: Lord Spectre
2 Replies
8. Shell Programming and Scripting
Hi ALL,
We have requirement in a file, i have multiple rows.
Example below:
Input file rows
01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212
01,1,102319,0,1,80,20,U,1,241,00000059420000006021
I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies
9. Shell Programming and Scripting
I have the following script that will average the last two fields of each row, but im not sure how to include the 3rd field of the following row.
An example of the analysis that I need to perform from the input - (66.61+58.01+54.16)/3
awk '{sum=cnt=0; for (i=13;i<=NF;i++) { sum+=$i; cnt++... (1 Reply)
Discussion started by: ncwxpanther
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 parameter
SYNOPSIS
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)