You need to put [ code] [/code ] tags around your examples so the formatting doesn't get lost.
I'd assume that the file contains just raw data and you want fixed width output. The printf command is probably what you want to use perhaps something like:
Last edited by Chubler_XL; 10-06-2010 at 07:57 PM..
Reason: Fix typo
Hi all,
may seem a very stupid question.but me stuck up in it for long....
How to find the number of columns in a ASCII file.
EX:-Demo.lst
songs 1 34 45 67
Number of columns should be 5.
Regards,
Anindya
;) (13 Replies)
This should follow with my last post but I think it's better to start a new one. Now I have a list of numbers stored in pos.txt:
2
6
7
.
.
.
n
.
.
.
And I need to extract (2n-1, 2n) columns from matrix.txt:
ind1 A B C D E F G H I J K L M N O P Q R ...
ind2 B C D E F G H... (3 Replies)
Hi,
I have a file1.txt like this:
and a file2.txt like this:
I wat only append file2.txt to file1.txt
and to have something like this:
How could i do ? (2 Replies)
Hi all,
I want the 2nd column of every file in the directory in a single file with the file name as column header.
$cat file1.txt
a b c
d e f
$cat file2.txt
f g h
g h j
$cat file3.txt
a b d
f g h (2 Replies)
hi all
could you please help me to concatenate two colomns and separate them by "-"
the two colomns to concatenate are colomuns 1 and 3 of a very bif file
clomn 1 is chr, 2 is snp and 3 is bp
the new colomn is chr_B
input file :
1 rs1111 10583
1 rs1891 10611
1 rs1807 ... (13 Replies)
How to find the number of columns in xml file.
i tried following command.
Code:
#!bin/ksh
cat $1 | grep -c "</mdm:attribute>"exit 0but i am not getting accurate result which is not matching with the manual count.
data format :
Code:
<mdm:attribute> value </mdm:attribute>
No... (1 Reply)
How to find the number of columns in xml file.
i tried following command.
#!bin/ksh
cat $1 | grep -c "</mdm:attribute>"
exit 0
but i am not getting accurate result which is not matching with the manual count.
data format :
<mdm:attribute> value </mdm:attribute> (6 Replies)
I have a CSV file that goes like this:
Name,Group,Email
Max,Group1,max@.com
Dan,Group2,dan@.com
Max,Group3,max@.com
Max,Group4,max@.com
Dan,Group5,dan@.com
Jim,Group6,jim@.comBasically my desired output should be:
Name,Group,Email
Max,Group1|Group3|Group4,max@.com... (6 Replies)
Hello,
I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between.
input file:
1 0 0 1... (10 Replies)
Hi
i am having one requirement like to concatenate two columns in to one columns, can any one help on this please sample scenario i am placing below
COL1,COL2,COL3,COL4
1,A,B,C,D
2,e,f,g,h
ouput should be 3 columns like below.
COL1,COL2,newcolumns
1,A,B,CD
2,e,f,gh
... (9 Replies)
Discussion started by: bhaskar v
9 Replies
LEARN ABOUT PHP
cubrid_fetch_field
CUBRID_FETCH_FIELD(3) 1 CUBRID_FETCH_FIELD(3)cubrid_fetch_field - Get column information from a result and return as an objectSYNOPSIS
object cubrid_fetch_field (resource $result, [int $field_offset])
DESCRIPTION
This function returns an object with certain properties of the specific column. The properties of the object are:
o $name
-column name
o $table
-name of the table that the column belongs to
o $def
-default value of the column
o $max_length
-maximum length of the column
o $not_null
-1 if the column cannot be NULL
o $primary_key
-1 if the column is a primary key
o $unique_key
-1 if the column is an unique key
o $multiple_key
-1 if the column is a non-unique key
o $numeric
-1 if the column is numeric
o $blob
-1 if the column is a BLOB
o $type
-the type of the column
o $unsigned
-1 if the column is unsigned
o $zerofill
-1 if the column is zero-filled
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3)
o $field_offset
- The numerical field offset. If the field offset is not specified, the next field (that was not yet retrieved by this function)
is retrieved. The $field_offset starts at 0.
RETURN VALUES
Object with certain properties of the specific column, when process is successful.
FALSE on failure.
EXAMPLES
Example #1
cubrid_fetch_field(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$req = cubrid_execute($conn, "SELECT event_code,athlete_code,nation_code,game_date FROM game WHERE host_year=1988 and event_code=20001;");
var_dump(cubrid_fetch_row($req));
cubrid_field_seek($req, 1);
$field = cubrid_fetch_field($req);
printf("
--- Field Properties ---
");
printf("%-30s %s
", "name:", $field->name);
printf("%-30s %s
", "table:", $field->table);
printf("%-30s "%s"
", "default value:", $field->def);
printf("%-30s %d
", "max length:", $field->max_length);
printf("%-30s %d
", "not null:", $field->not_null);
printf("%-30s %d
", "primary key:", $field->primary_key);
printf("%-30s %d
", "unique key:", $field->unique_key);
printf("%-30s %d
", "multiple key:", $field->multiple_key);
printf("%-30s %d
", "numeric:", $field->numeric);
printf("%-30s %d
", "blob:", $field->blob);
printf("%-30s %s
", "type:", $field->type);
printf("%-30s %d
", "unsigned:", $field->unsigned);
printf("%-30s %d
", "zerofill:", $field->zerofill);
cubrid_close_request($req);
cubrid_disconnect($conn);
?>
The above example will output:
array(4) {
[0]=>
string(5) "20001"
[1]=>
string(5) "16681"
[2]=>
string(3) "KOR"
[3]=>
string(9) "1988-9-30"
}
--- Field Properties ---
name: athlete_code
table: game
default value: ""
max length: 0
not null: 1
primary key: 1
unique key: 1
multiple key: 0
numeric: 1
blob: 0
type: integer
unsigned: 0
zerofill: 0
PHP Documentation Group CUBRID_FETCH_FIELD(3)