Hi
I have a file with contents like
china
india
france
japan
italy
germany
.
.
.
.
etc....
I want the output as
china|india|france|japan|italy|germany|.|.|. (3 Replies)
Hi,
I have a pipe delimited file with 1 million records. I need to validate each line by counting the number of delimiters, if any line fails to have the specified number of delimiters, taat line has to be sent to a reject file.
Kindly suggest.
if code provided, it is highly appreciated, and... (22 Replies)
I have a text file with lot of rows like..
Action & Adventure|2012: Supernova NR|2009-11-01 00:01:00|2010-05-01 23:59:00|Active|3
Action & Adventure|50 Dead Men Walking|2010-01-05 00:01:00|2010-06-30 23:59:00|Active|3
Action & Adventure|Afterwards|2009-11-26 00:01:00|2010-03-26... (3 Replies)
Hi All,
I have three separate text files which has only one line and i want to combine these lines in one text file which will have three lines.
cat file1.txt
abc
cat file2.txt
1265 6589 1367
cat file3.txt
0.98 0.36 0.5
So, I want to see these three lines in the... (9 Replies)
I have two files:
file-gene_families.txt that contains 30,000 rows of 30 columns. Column 1 is the ID column and contains the
Col1 Col2 Col3 ...
One gene-encoded CBPs ABC 111 ...
One gene-encoded CBPs ABC 222 ...
One gene-encoded CBPs ABC 212 ...
Two gene encoded CBPs EFC... (7 Replies)
i have a file contains continues records; i want to separate each section that has the same 1st field by putting ''###''.
1 salam_32 tr po
1 sed_po wqu
1 Pdot. food 32
2 eeeelll
2 wwwqww qwqw e
3 d
3 r
3 0
3 322
1 salam_32 tr po
1 sed_po wqu
1 Pdot. food 32
###
2 eeeelll
2... (1 Reply)
Hi All
I have a very tricky problem, not able to solve it. Hence asking this question.
I have a code portion like this -
int
parse_msg(in_buf,line1,line2,sccs_line)
char in_buf;
char line1;
char line2;
char sccs_line;
{
....
(void)fprintf(trace_fp,"parse_msg1 in_buf = %s \n",... (0 Replies)
Hi I am new to shell programming in unix
Please if I can provide help.
I have a file structure of a header record and "N" detail records.
The header record will be the total number of detail records
I need to split the file in 2:
One for the header
Another for all detail records
Could... (1 Reply)
hi,
I'm trying to print out the contents of a folder into a .txt file.
The code I'm trying amongst variations is:
ls -1 > filenames.txt
but it prints them all on the same line ie.
image102.bmpimage103.bmpimage104.bmpimage105.bmpimage106.bmp
how can I change this?
Please... (2 Replies)
Discussion started by: newbie100
2 Replies
LEARN ABOUT PHP
oci_field_name
OCI_FIELD_NAME(3)OCI_FIELD_NAME(3)oci_field_name - Returns the name of a field from the statementSYNOPSIS
string oci_field_name (resource $statement, mixed $field)
DESCRIPTION
Returns the name of the $field.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the name as a string, or FALSE on errors.
EXAMPLES
Example #1
oci_field_name(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
echo "<table border="1">
";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Type</th>";
echo "<th>Length</th>";
echo "</tr>
";
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
$column_name = oci_field_name($stid, $i);
$column_type = oci_field_type($stid, $i);
echo "<tr>";
echo "<td>$column_name</td>";
echo "<td>$column_type</td>";
echo "</tr>
";
}
echo "</table>
";
// Outputs:
// Name Type
// NUMBER_COL NUMBER
// VARCHAR2_COL VARCHAR2
// CLOB_COL CLOB
// DATE_COL DATE
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumnname(3) instead. This name still can be used, it was left as alias of
oci_field_name(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO oci_num_fields(3), oci_field_type(3), oci_field_size(3).
PHP Documentation Group OCI_FIELD_NAME(3)