Secondly your input is not clear, you should post at least 5 lines of your input file and their required output to get the exact logic of what you want, as per your given 2 lines what I understand is that, if line no. is odd then take frist 3 columns, leave next 3 columns and print a single column then print one incremented column (4th col ) and print next column after leaving 3 columns, if line no. is even then reverse the order, take first 3 cols and last column, then take the 4th column and 2nd last, then 5th and 3rd last and so on.
Here is the code as per above logic:
Which will yeild your desired output:
Regards,
Tayyab
Dear UNIX experts:
Hi, I have a text file which the contents are arranged vertically down, line by line.
How do use a loop (I think) to make it arrange in vertical arrangement with a tab delimitated and write to a new file?
Eg: of source file
Hello World
Good-day
Thanks
Welcome
The... (8 Replies)
I have these following data:
Home Tom
Member List
100 Yes
200 No
Home Tom
Member List
1 No
2 Yes
Home Tome
Member List
3 No
400 Yes
I want my data to be consistants like this: (4 Replies)
I have a data file with hundreds of lines: I want to place a YES right below the line that say mydata....can someone please help! on the left is my the original data on the right the data format need to be:
left > Right
mydata > mydata
yes > yesno > no
mydata > mydata... (12 Replies)
Can anyone help me on this. I have a file that looks like this:
color red green blue
color pink yellow
number one two
gender male
gender female
The output would look like this:
color red green blue pink yellow
number one two
gender male female
I have over 5000 rows and i dont want... (5 Replies)
Hi,
I have the following 'sorting' problem.
Given the input file:
a:b:c:12:x:k
s:m:d:8:z:m
a:b:c:1:x:k
p:q:r:23:y:m
a:b:c:3:x:k
p:q:r:1:y:m
the output I expect is:
a:b:c:1:x:k
p:q:r:1:y:m
s:m:d:8:z:m
What happened here is I grouped together lines having the same values for... (7 Replies)
Dear Frineds,
I have a flat file as follows
ABCD
ABDCWQE
POIERAS
ADSGASGFG
GHJKFHD
XBDFGHFGDH
POIU
IJPFG
AFGJFPGOU
A;DGUPGU
SFSDFDSDFHDSF
SDFGHSFDH
I want this column to be converted into row like follows
ABCD, ABDCWQE, POIERAS, ADSGASGFG, GHJKFHD, XBDFGHFGDH (6 Replies)
Hi
I have a huge problem to solve ASAP. Can someone please help!!!
My format is arranged in this format: It has three columns.
LOGIN ALIAS REC_ID
A BB1 0
A ... (1 Reply)
Hi all
I have following part of a big file
TTDS00002 Synonyms M1 receptor
TTDS00002 Disease Alzheimer's disease
TTDS00002 Disease Bronchospasm (histamine induced)
TTDS00002 Disease Cognitive deficits
TTDS00002 Disease Schizophrenia
TTDS00002 Function The muscarinic acetylcholine... (2 Replies)
Discussion started by: kareena
2 Replies
LEARN ABOUT PHP
ovrimos_result_all
OVRIMOS_RESULT_ALL(3)OVRIMOS_RESULT_ALL(3)ovrimos_result_all - Prints the whole result set as an HTML tableSYNOPSIS
int ovrimos_result_all (int $result_id, [string $format])
DESCRIPTION
Prints the whole result set as an HTML table.
PARAMETERS
o $result_id
- A result identifier, returned by ovrimos_execute(3) or ovrimos_exec(3).
o $format
- Optional HTML attributes for the generated table element.
RETURN VALUES
Returns the number of rows in the generated table.
EXAMPLES
This will execute an SQL statement and print the result in an HTML table.
Example #1
Prepare a statement, execute, and view the result
<?php
$conn = ovrimos_connect("db_host", "8001", "admin", "password");
if ($conn != 0) {
echo "Connection ok!";
$res = ovrimos_prepare($conn, "select table_id, table_name
from sys.tables where table_id = 7");
if ($res != 0) {
echo "Prepare ok!";
if (ovrimos_execute($res, array(3))) {
echo "Execute ok!
";
ovrimos_result_all($res);
} else {
echo "Execute not ok!";
}
ovrimos_free_result($res);
} else {
echo "Prepare not ok!
";
}
ovrimos_close($conn);
}
?>
Example #2
ovrimos_result_all(3) with meta-information
<?php
$conn = ovrimos_connect("db_host", "8001", "admin", "password");
if ($conn != 0) {
echo "Connection ok!";
$res = ovrimos_exec($conn, "select table_id, table_name
from sys.tables where table_id = 1");
if ($res != 0) {
echo "Statement ok! cursor=" . ovrimos_cursor($res) . "
";
$colnb = ovrimos_num_fields($res);
echo "Output columns=" . $colnb . "
";
for ($i=1; $i <= $colnb; $i++) {
$name = ovrimos_field_name($res, $i);
$type = ovrimos_field_type($res, $i);
$len = ovrimos_field_len($res, $i);
echo "Column " . $i . " name=" . $name . " type=" . $type . " len=" . $len . "
";
}
ovrimos_result_all($res);
ovrimos_free_result($res);
}
ovrimos_close($conn);
}
?>
PHP Documentation Group OVRIMOS_RESULT_ALL(3)