I am trying to merge two large file horizontally using paste command. Every thing is working fine except for time. Its taking lot of time.
Is there any effiecient way of doing the same thing or is there anyway by which I can improve its perfomance programatically?
Thanks,
Yeheya (1 Reply)
I have 2 files, 1.txt and 2.txt which have the following format:
1.txt
:451:1
:451:0
:451:1
and so on..
2.txt
:108:13897187
:108:90890789
:108:76476386
and so on..
I want to combine the files horizontally, I tried paste 1.txt 2.txt as well as cat but both of them are giving me... (3 Replies)
Hi all,
I have two files -- one with 1024 lines and another with 2048 lines. I want to merge them to create another file in such way that it takes 2 lines from file with 1024 lines and 4 from 2048 lines.
I wrote a sample script and curious to see if there is a better way; i am sure there is,... (4 Replies)
Hi Every body,
I have file which has enttries, with each 5 entries as a set of entries, I would like to read the file (line by line) and print five entries of a set vertically, the next entry should come in the next line.
Example:
cat sample_file
I am a
Unix Adminsitrator
new to shell... (6 Replies)
Hi experts
i have a simple script that fetches the count from different servers and inserts ahead of server name like below
servera,1
serverb,25
serverc,35
what i want to do is now when i run this script next day i want that output to be next to the earlier one like below and if possible... (5 Replies)
Hello,
How to sort each row in a document with numerical values and with more than one row. Example
Input data (file1.txt):
4 6 8 1 7
2 12 9 6 10
6 1 14 5 7
and I want the the output to look like this(file2.txt):
1 4 6 7 8
2 6 9 10 12
1 5 6 7 14
I've tried
sort -n file1.txt >... (12 Replies)
I have a 2 column file.
Column 1 is a road ID number.
Column 2 is the date that the road surface condition was inspected.
Some roads have been inspected only once, while some roads have been inspected multiple times.
I would like to re-arrange the following example list:
1001 2001_01_01... (5 Replies)
Hi ALL
I have this data
ail,UTT,id1_0,COMBO,21,24,21,19
al,UTHAST,id1_0,COMBO,342,390,361,361
dmo,UTST,id1_0,COMBO,21,15,22,23
vne,UAST,id1_0,COMBO,345,372,390,393
I wan the sum of column 5,6,7 & 8 both horizontal and vertical.
There is one more prob the column keeps on increasing... (9 Replies)
Hello,
Please help create the following report.
I have a matrix
- S1 S2 S3 S4
M1 AA AA TT -
M2 AG AG AA GG
M3 GG TT - -
a first lookup table
M3 chr7 4.456
M1 chr7 28.9
M2 chr8 129.678
a second lookup table
S1 GGHBBGG/DEDD(@DCCD) (8 Replies)
Hi, I have a file like
aa bb dmns|860 dmns|756 ee ff
aa bb dmns|310 dmns|260 ee ff
aa bb dmns|110 dmns|77 ee ff
aa bb dmns|756 dmns|860 ee ff
aa bb dmns|110 dmns|77 ee ff
aa bb dmns|233 dmns|79 ee ff
aa bb dmns|79 dmns|233 ee ff
I want to sort the values in column3 and column4... (2 Replies)
Discussion started by: sammy777888
2 Replies
LEARN ABOUT PHP
pg_num_rows
PG_NUM_ROWS(3)PG_NUM_ROWS(3)pg_num_rows - Returns the number of rows in a resultSYNOPSIS
int pg_num_rows (resource $result)
DESCRIPTION pg_num_rows(3) will return the number of rows in a PostgreSQL result resource.
Note
This function used to be called pg_numrows(3).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
RETURN VALUES
The number of rows in the result. On error, -1 is returned.
EXAMPLES
Example #1
pg_num_rows(3) example
<?php
$result = pg_query($conn, "SELECT 1");
$rows = pg_num_rows($result);
echo $rows . " row(s) returned.
";
?>
The above example will output:
1 row(s) returned.
SEE ALSO pg_num_fields(3), pg_affected_rows(3).
PHP Documentation Group PG_NUM_ROWS(3)
04-03-2013
sorry!! This should do!