Dear forum users,
i'm trying to read a table with 40x122 data in a array. Following this, i'd plot each rows again the header of the file in gnuplot.
i was thinking for something like that
Code:
#!/bin/bash
# reads from the $ips file and assigns to $MYARRAY
#IFS =";" split the line after the ;
#set -- $array save the each row of the line in $1 $2 $3 $4 ....
myfile="Comprasion.txt"
ln=`wc -l $myfile|awk '{print $1}'`
i=1
#echo "$ln"
declare -a sgs
for ((i==1; i<=$ln; i++)); do
line=`awk "NR==$i" $myfile`
#echo "$line"
declare -a row
linarray=(`echo ${line// / }`);
#echo "${#linarray[*]}" # OK.
#echo "${#linarray[*]}" # OK.
row=(`echo ${#linarray[*]}`);
echo "*********"
#echo "$row"
r=1
for ((r==1;r<=$row;r++)); do
#echo "variable $i $r"; # OK.
sgs[${i},${r}]=(`echo ${linearray[$r]}`);
var=${sgs[${i},${r}]};
echo "$var";
done
#echo "$i";
done
if i run the script, unfortunately, i get nothing. Where do i have problem?
thanks in advance for your help
---------- Post updated at 07:26 PM ---------- Previous update was at 03:43 PM ----------
nobody has a suggestion
Last edited by servuskelb; 06-27-2012 at 04:03 PM..
Reason: code improved
Hi All,
I need some sort of library or module which read the db table at one go and keep in process memory.My problem is that I have a call processing module which handles the network call and goes for db lookup for subscriber profile in oracle db for every call.I am using Oracle Standard Edition... (0 Replies)
Hi all,
I need to create a matrix of variable rows and columns. Right now i have 3 rows and two columns and following values.
Output something like
TypeA TypeB
TestCase1 Pass Fail
TestCase2 Pass ... (2 Replies)
i have to read some data from a teradata table and use them in my shell script.. how do i do that.. we can use BTEQ .. but i don know how to pass the field values as variables to the shell.. please help me.... (8 Replies)
Hi all,
Could someone please explain to me how I should read this routing table,
# netstat -rn
Routing tables
Destination Gateway Flags Refs Interface Pmtu
127.0.0.1 127.0.0.1 UH 0 lo0 32808
10.222.47.82 10.222.47.82 UH... (3 Replies)
Hi,
I have a table in the format:
1 0 -1 1 0
2 0 1 -1 0 0 0
3 0 1 1 0 0 0 0 0 0
etc.
I am trying to input this to a program, however it is complaining about the fact that it is not in matrix format. How do I add 0's to end of the rows to make them even?
Thanks in advance! (2 Replies)
Hello All,
i have a file sort.txt with below entries.
1 12 10
16 6 4
20 8 15
i need to sort these entries and the out put should come in a single line.
1 4 6 8 10 12 15 16 20
Can you please help me sort this out? (2 Replies)
Hello,
I need some help to reformat this table-by-row to matrix?
infile:
site1 A:o,p,q,r,s,t
site1 C:y,u
site1 T:v,w
site1 -:x,z
site2 A:p,r,t,v,w,z
site2 C:u,y
site2 G:q,s
site2 -:o,x
site3 A:o,q,s,t,u,z
site3 C:y
site3 T:v,w,x
site3 -:p,routfile:
SITE o p q r s t v u w x y... (7 Replies)
HELLO
I need your help please , i need to read a file that contain a table like :
Name | Status
------------------
DB 1 | UP
DB 2 | UP
DB 3 | DOWN
DB 4 | UP
DB 5 | UP
the objective to read each line and check if DB is UP or Down and give me the name of Down database.... (10 Replies)
Discussion started by: Abdellah
10 Replies
LEARN ABOUT PHP
mysql_fetch_row
MYSQL_FETCH_ROW(3) 1 MYSQL_FETCH_ROW(3)mysql_fetch_row - Get a result row as an enumerated arraySYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_fetch_row(3)
o PDOStatement::fetch
array mysql_fetch_row (resource $result)
DESCRIPTION
Returns a numerical array that corresponds to the fetched row and moves the internal data pointer ahead.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
Returns an numerical array of strings that corresponds to the fetched row, or FALSE if there are no more rows.
mysql_fetch_row(3) fetches one row of data from the result associated with the specified result identifier. The row is returned as an
array. Each result column is stored in an array offset, starting at offset 0.
Example #1
Fetching one row with mysql_fetch_row(3)
<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$row = mysql_fetch_row($result);
echo $row[0]; // 42
echo $row[1]; // the email value
?>
Note
This function sets NULL fields to the PHP NULL value.
mysql_fetch_array(3), mysql_fetch_assoc(3), mysql_fetch_object(3), mysql_data_seek(3), mysql_fetch_lengths(3), mysql_result(3).
PHP Documentation Group MYSQL_FETCH_ROW(3)
06-27-2012
