Hi guys,
Please help me if u have some solution.
I have a file with three columns separated by ':' -
INPUT_FILE
C416722_2 : calin Dirigent : Dirigent
AC4174_6 : Jac : cal_co
TC4260_5 : [no : lin kite
BC426302_1 : [no : calin Dirigent lin
JC426540_3 : lin Pymo_bin : calin
TC428_3 : no7... (4 Replies)
Hi
I have file which contains 5 coulmns i need to add the fifth column value and put it in the desired location in the same column.
Here is the sample file..
ashop0004 SQL- 06/14/2009 06/14/2009 00:04:28 SUM
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:37 ... (22 Replies)
So I have this input
1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI
1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI
1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI
1 10583 rs58108140 G A ... (3 Replies)
Hola,
How can I add a column to a existing file??
PS: The column which should be added need to be the first column and it will be a parameter from the script.
Example:
1 name1
2 name2
3 name3
4 name3
Need to add parameter $file as a first column. $file is a file name with time... (6 Replies)
Hi, long time reader, first time poster.
I've done some searching so please if this is a repeated post excuse the duplicate, but what I have are two files roughly like so:
File 1:
A W
B X
C Y
D Z
File 2:
A 1
C 2
D 3
And what I would like to get out is... (4 Replies)
Dear all,
Lets say, I've a file a.txt containing two columns, like
a1 b1
.. ..
.. ..
and another file b.txt containg two columns, like
a1 c1
.. ..
.. ..
I need to put c1 column from b.txt file to the a.txt file. So, the output should be
a1 b1 c1
.. .. ..
.. ... (4 Replies)
I have file like this
b,c
10,20
30,40
50,60
Now I want to add a new column a with fixed values for all the rows
a,b,c
60,10,20
60,30,40
60,50,60
Please let me know how can we do this in unix. (4 Replies)
Hi Team
I have file as below
empno,ename,sal
123,smith,1000
124,adams,2000
Required output: Using AWK
empno,ename,sal,deptno
123,smith,1000
124,adams,2000
Thanks,
Murali (5 Replies)
Hi,
I have 2 files.
file1 contains by lines: hash:salt:id
file2 contains by lines: username:hash:salt
I would like to add a new coloumn (id) form file1 to file2.
The new file should contains: username:hash:salt:id
Note: file1 contains less rows than file2.
I tried
paste -d':' file1... (12 Replies)
Discussion started by: freeroute
12 Replies
LEARN ABOUT PHP
pg_field_name
PG_FIELD_NAME(3)PG_FIELD_NAME(3)pg_field_name - Returns the name of a fieldSYNOPSIS
string pg_field_name (resource $result, int $field_number)
DESCRIPTION pg_field_name(3) returns the name of the field occupying the given $field_number in the given PostgreSQL $result resource. Field numbering
starts from 0.
Note
This function used to be called pg_fieldname(3).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $field_number
- Field number, starting from 0.
RETURN VALUES
The field name, or FALSE on error.
EXAMPLES
Example #1
Getting information about fields
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
$i = pg_num_fields($res);
for ($j = 0; $j < $i; $j++) {
echo "column $j
";
$fieldname = pg_field_name($res, $j);
echo "fieldname: $fieldname
";
echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters
";
echo "storage length: " . pg_field_size($res, $j) . " bytes
";
echo "field type: " . pg_field_type($res, $j) . "
";
}
?>
The above example will output:
column 0
fieldname: author
printed length: 6 characters
storage length: -1 bytes
field type: varchar
column 1
fieldname: year
printed length: 4 characters
storage length: 2 bytes
field type: int2
column 2
fieldname: title
printed length: 24 characters
storage length: -1 bytes
field type: varchar
SEE ALSO pg_field_num(3).
PHP Documentation Group PG_FIELD_NAME(3)