Hello.
I face this (2 side) problem.
Some lines with this structure.
...........
12345678 4
12345989 13
12346356 205
12346644 74
12346819 22
.........
The first field (timestamp) is growing (or at least equal).
1)Sum the second fields if the first_field/500 are... (8 Replies)
Hi friends,
This is sed & awk type question.
I have a text file which has numbers spread all over the file. I want to sum the series of numbers whenever i find it and produce an output file with the sum. For example
###start of input text file ####
abc
def
ghi
1
2
3
4
kjld
random... (3 Replies)
Hi friends,
This is sed & awk type question. It is slightly different from my previous question.
I have a text file which has numbers spread all over the file. I want to sum the series of numbers (but no more than 10 numbers in series) whenever i find it and produce an output file with the... (4 Replies)
Hi,
I am using the following code to find the sum of the values of column 286 in a file. It will have the Decimal values with the scale of 2. Delimiter is '|^'
cut -d'|^' -f286 filename|cut -c3-| awk '{ x += $1 } END { printf("%.2f\n", x) }'
There are around 50k records in this file... (2 Replies)
Hello,
I am new to Linux environment , I working on Linux script which should send auto email based on the specific condition from log file. Below is the sample log file
Name m/c usage
abc xxx 10
abc xxx 20
abc xxx 5
xyz ... (6 Replies)
I need to sum values in text file in case duplicate row are present with same name and different value below is example of data in file i have and format i need.
Data in text file
20170308
PM,U,2
PM,U,113
PM,I,123
DA,U,135
DA,I,113
DA,I,1
20170309
PM,U,2
PM,U,1
PM,I,123
PM,I,1... (3 Replies)
In the awk below I am trying to add a penalty to a score to each matching $1 in file2 based on the sum of $3+$4 (variable TL) from file1. Then the $4 value in file1 is divided by TL and multiplied by 100 (this valvue is variable S). Finally, $2 in file2 - S gives the updated $2 result in file2.... (2 Replies)
I have two files, file1.table is the count table, and the other is the range condition file2.range.
file1.table
chr start end count
N1 0 48 1
N1 48 181 2
N1 181 193 0
N1 193 326 2
N1 326 457 0
N1 457 471 1
N1 471 590 2
N1 590 604 1
N1 604 752 1
N1 752 875 1
file2.range... (12 Replies)
Discussion started by: yifangt
12 Replies
LEARN ABOUT PHP
db2_escape_string
DB2_ESCAPE_STRING(3) 1 DB2_ESCAPE_STRING(3)db2_escape_string - Used to escape certain charactersSYNOPSIS
string db2_escape_string (string $string_literal)
DESCRIPTION
Prepends backslashes to special characters in the string argument.
PARAMETERS
o $string_literal
- The string that contains special characters that need to be modified. Characters that are prepended with a backslash are x00,
,
, , ', " and x1a.
RETURN VALUES
Returns $string_literal with the special characters noted above prepended with backslashes.
EXAMPLES
Example #1
A db2_escape_string(3) example
Result of using the db2_escape_string(3) function
<?php
$conn = db2_connect($database, $user, $password);
if ($conn) {
$str[0] = "All characters: x00 ,
,
, , ' , " , x1a .";
$str[1] = "Backslash (). Single quote ('). Double quote (")";
$str[2] = "The NULL character must be quoted as well";
$str[3] = "Intersting characters: x1a , x00 .";
$str[4] = "Nothing to quote";
$str[5] = 200676;
$str[6] = "";
foreach( $str as $string ) {
echo "db2_escape_string: " . db2_escape_string($string). "
";
}
}
?>
The above example will output:
db2_escape_string: All characters: ,
,
, \ , ' , " , .
db2_escape_string: Backslash (\). Single quote ('). Double quote (")
db2_escape_string: The NULL character must be quoted as well
db2_escape_string: Intersting characters: , .
db2_escape_string: Nothing to quote
db2_escape_string: 200676
db2_escape_string:
SEE ALSO db2_prepare(3).
PHP Documentation Group DB2_ESCAPE_STRING(3)