Hi all,
I have a file with the following data.
E01011U, ,E11, , , ,0
E03012U, ,E14, , , ,0
E02013U, ,E25, , , ,0
I want to change it to
('E01-01-1-U','E11' );
('E03-01-2-U','E14' );
('E02-01-3-U','E25' );
Please let me know about it .Thanks in advance. (10 Replies)
Ravi .
Pawan 19.23
sanjeeva .
I want to replace '.' into 'NULL' not the dot between 19.23 .. only single dots to NULL
how to do replacement after opening file in Vi (5 Replies)
Hi:
I want to write a Kshell script which will replace last / by |.
eg: /home/apps/test/document should be replaced as /home/apps/test|document.
The length of the string is not constant.
Thanks,
Ash (6 Replies)
hi
i have input file in this format
E102|0|1-23-1994|0|12-5-1994|E003|A|10450|charan,devupalli|5000
how to convert this into outfile
E102,0,1-23-1994,0,12-5-1994,E003,A,10450,charan,devupalli,5000
i wann the output in excel sheet.........that is why i am converting into csv..
but i have... (6 Replies)
Hi,
djfksdjk)))) kmmm jfdfjk))))
I want to replace the first ')' after kmmm with #.
The output would be djfksdjk)))) exists jfdfjk#)))
Can anyone help on this? (3 Replies)
Hello,
I really would appreciate some help with a bash script for some string manipulation on an SQL dump:
I'd like to be able to rename "sites/WHATEVER/files" to "sites/SOMETHINGELSE/files" within the sql dump.
This is quite easy with sed:
sed -e... (1 Reply)
Here is my file content
age=12
age=34
age=54
age=23
Hello world. This is the age result I am getting.
To day date is 23-02-2010.
From the above content I have to replace all the values after 'age=*' to age=24.
How to do it. (1 Reply)
I need to replace dashes (i.e. -) if present from positions 351-357 with zero (i.e. 0), I also need to replace dash (i.e “-“) if present between position 024-043 with zero (i.e. 0) & I replace " " (i.e. 2 space characters) if present at position 381-382 with "04". Total length of record is 413.... (11 Replies)
I need to replace the (*) in the fist of a list with numbers using sed for example >
this file contain a list
* linux
* computers
* labs
* questions
to >>>>
this file contain a list
1. linux
2. computers
3. labs
4. questions (7 Replies)
I have a csv which has lot of columns . I was looking for an awk script which would extract a column twice. for the first occurance the header and data needs to be intact but for the second occurance i want to replace the header name since it a duplicate and extract year value which is in ddmmyy... (10 Replies)
Discussion started by: Kunalcurious
10 Replies
LEARN ABOUT PHP
db2_num_fields
DB2_NUM_FIELDS(3) 1 DB2_NUM_FIELDS(3)db2_num_fields - Returns the number of fields contained in a result setSYNOPSIS
int db2_num_fields (resource $stmt)
DESCRIPTION
Returns the number of fields contained in a result set. This is most useful for handling the result sets returned by dynamically generated
queries, or for result sets returned by stored procedures, where your application cannot otherwise know how to retrieve and use the
results.
PARAMETERS
o $stmt
- A valid statement resource containing a result set.
RETURN VALUES
Returns an integer value representing the number of fields in the result set associated with the specified statement resource. Returns
FALSE if the statement resource is not a valid input value.
EXAMPLES
Example #1
Retrieving the number of fields in a result set
The following example demonstrates how to retrieve the number of fields returned in a result set.
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$stmt = db2_prepare($conn, $sql);
db2_execute($stmt, $sql);
$columns = db2_num_fields($stmt);
echo "There are {$columns} columns in the result set.";
?>
The above example will output:
There are 4 columns in the result set.
SEE ALSO db2_execute(3), db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3),
db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_NUM_FIELDS(3)