Below is output-
Output1
output2 (This contain only those ids which have license usage >25)
After filtering of the users name, I like to send email to these ids. Email address is strored in another file e.g. file name email-list.txt as below.
Please guide me on how to grab email id from other file.
Thanks again.
Last edited by Scrutinizer; 06-28-2013 at 01:19 AM..
Reason: code tags, took out email tags
I'm trying to remove lines of data that contain duplicate data in a specific column.
For example.
apple 12345
apple 54321
apple 14234
orange 55656
orange 88989
orange 99898
I only want to see
apple 12345
orange 55656
How would i go about doing this? (5 Replies)
I am a newbie to shell scripting ..
I have a .csv file. It has 1000 some rows and about 7 columns...
but before I insert this data to a table I have to parse it and clean it ..basing on the value of the first column..which a string of phone number type...
example below..
column 1 ... (2 Replies)
Hello everybody,
I'm trying to count the number of consecutive lines in a text file which have two distinctive column field values. These lines may appear in several line blocks within the file, but I only want a single block to be counted.
This was my first approach to tackle the problem (I'm... (6 Replies)
Hi experts, I have a tab-delimited file with one column containing values separated by a comma. I wish to duplicate the entire line for every value in that comma-delimited field.
For example:
$cat file
4444 4444 4444 4444
9990 2222,7777 6666 2222 ... (3 Replies)
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Hi all,
I am new to using awk and am quickly discovering what a powerful pattern-recognition tool it is. However, I have what seems like a fairly basic task that I just can't figure out how to perform in one line. I want awk to find and print all the lines in which one of multiple patterns (e.g.... (8 Replies)
Hi would like to ask you guys any advise regarding my problem
I have this kind of data
file.txt
111111111,20
111111111,50
222222222,70
333333333,40
444444444,10
444444444,20
I need to get this
file1.txt
111111111,70
222222222,70
333333333,40
444444444,30
using this code I can... (6 Replies)
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (12 Replies)
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
LEARN ABOUT PHP
cubrid_result
CUBRID_RESULT(3) 1 CUBRID_RESULT(3)cubrid_result - Return the value of a specific field in a specific rowSYNOPSIS
string cubrid_result (resource $result, int $row, [mixed $field])
DESCRIPTION
This function returns the value of a specific field in a specific row from a result set.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3)
o $row
-The row number from the result that is being retrieved. Row numbers start at 0.
o $field
- The name or offset of the $field being retrieved. It can be the field's offset, the field's name, or the field's table dot field
name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column
name. If undefined, the first field is retrieved.
RETURN VALUES
Value of a specific field, on success (NULL if value if null).
FALSE on failure.
EXAMPLES
Example #1
cubrid_result(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$req = cubrid_execute($conn, "SELECT * FROM code");
$result = cubrid_result($req, 0);
var_dump($result);
$result = cubrid_result($req, 0, 1);
var_dump($result);
$result = cubrid_result($req, 5, "f_name");
var_dump($result);
cubrid_close_request($req);
cubrid_disconnect($conn);
?>
The above example will output:
string(1) "X"
string(5) "Mixed"
string(4) "Gold"
PHP Documentation Group CUBRID_RESULT(3)