05-02-2013
Do you know the max length of the each columns can be? If data is taken from database please check the column properties depending upon that we can arrange it..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Any idea in awk or sed?
$cat file
a b c
2 4 5 6
output:
a
b
c
2
4
5
6 (3 Replies)
Discussion started by: kenshinhimura
3 Replies
2. Shell Programming and Scripting
Which is the best command(s) to arrange data of a file?
This is my example input file:
Tom ------
apples: 5
oranges: 7
pears: 10
apples: 2
oranges: 8
Jack ------
apples: 3
pears: 10
Lucy ------
oranges: 1
pears: 8
peaches: 9
Tom ------
peaches: 1
Jack ------ (1 Reply)
Discussion started by: csecnarf
1 Replies
3. UNIX for Dummies Questions & Answers
I have a following data:
100 200
300 400
I want the data to be arranged:
100 200 300 400
What is the best way to do this?
Thanks! (5 Replies)
Discussion started by: bobo
5 Replies
4. Shell Programming and Scripting
Everybody,
can you tell me how express about this; we have text data file as :
parameter1 Parameter2
AA 55
BB 77
. .
. .
. .
We want to draw table for this data as attached then send as body of Email (4 Replies)
Discussion started by: xjklop2009
4 Replies
5. Shell Programming and Scripting
hi,
i used paste file1.txt file2.txt > file3.txt to merge 2 columns from file1 and 4 columns from file2.
file1
scaffold_217 scaffold_217
file2
CHRSM N scaffold_217.pf scaffold_217.fsa
the result is as follows:-
scaffold_217 scaffold_217
CHRSM ... (6 Replies)
Discussion started by: redse171
6 Replies
6. Shell Programming and Scripting
Input
217:fngadi4osa:fngadi4osa:M 217:415744:N/A
227:fngadi4osa:fngadi4osa: M 227:51200:N/A
228:fngadi4osa:fngadi4osa: M 228:102400:N/A
65:sapgt04:sapgt04: M 65:104448:N/A
228:fngadi4osa:fngadi4oma: M 228:102400:N/A
Output
217:fngadi4osa:fngadi4osa:M 217:415744:N/A... (3 Replies)
Discussion started by: greycells
3 Replies
7. Shell Programming and Scripting
I have vary complex issue in unix...i want copy same data in same column...
My Input...
Object SpchAccate hAes hCCS SDop Sroontb NoRabEt SRbuc
ran=C515D (Mod=15) 0 100 98.1 1.9 0.6 ... (7 Replies)
Discussion started by: asavaliya
7 Replies
8. Shell Programming and Scripting
Hi Team,
I have one file in that almost 100+ words in lines
Eg:-
Unix
windows
solaris
Linux
...
...
But I want arrange all lines in table format and can able read on screen
Eg: -
Unix windows solaris Lunix......
Hp unix Mac-os ......
Like as Table...... (11 Replies)
Discussion started by: Bhaskar Alagala
11 Replies
9. Programming
Hello everyone,
I have some problem about this code :
#!/usr/bin/env python
import sys
try :
filename = sys.argv
except :
print 'Specify filename'
sys.exit()
fd = open(filename)
lines = fd.xreadlines()
compare = {}
for line in lines :
split_line =... (1 Reply)
Discussion started by: awil
1 Replies
10. Shell Programming and Scripting
Hello All,
I have following data into my file named record.
Name City phone number email
Jhon Newyork 123456987 jhon@gmail.com
Maria Texas 569865612 Maria_Sweet@rediffmail.com
Chan Durben NA Chan123@gmail.com
The output should be in straight columns.. There should not be any... (1 Reply)
Discussion started by: Nakul_sh
1 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 object
SYNOPSIS
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)