I want to take a file that is generated in 132 columns from a unix based report generator and transfer it to a windows environment and preserve the column length. Any ideas how I can do this so that whatever windows based text editor that reads the document will know it should be in 132 columns?... (16 Replies)
Hello Gurus,
I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?
The input file example,
... (6 Replies)
Currently I am stuck on my program for my if statement, as I do not no how to get a specific collumn of text to check against my variable.
df -k /home/* > fd.txt
cat df.txt | tr -s " " | awk '{print $3, $4, $1}' > dfcap.txt
echo -n "Enter the size (in kilobytes) you wish to check against... (18 Replies)
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Hi Friends,
I am Stuck up with a problem on transposing Rows to Coloumns.. Though there are many threads on this my problem is little difficult..
I have a tab separated file like Below,
computer selling_loc currency_type manufacturer_name salesweek-wk1 sales-wk2 ...wk-3 ..wk4 till... (7 Replies)
Hello,
I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between.
input file:
1 0 0 1... (10 Replies)
Dear All,
I have basic structure of the C++ code . It suppose to read particular columns from some txt file. The txt file look like following (snippet). I have to ask the details for instance 'id' information for rows satisfying text with red color. The issue is that the txt file has not just the... (2 Replies)
P { margin-bottom: 0.25cm; line-height: 120%; }CODE.cjk { font-family: "WenQuanYi Micro Hei",monospace; }CODE.ctl { font-family: "Lohit Hindi",monospace; }A:link { } I'm trying to build an awk statement to print from a file (file1):
A 1,2,3 *
A 4,5,6 **
B 1
... (4 Replies)
I have two files in below formats:
cat file1
abc|abcd|10|1020
10|xyz|1010|1020
abc|abcd|10|1020
10|xyz|1010|1020
cat file2
abc|abcd|10|1020
11|xyz|1010|1020
abc|abcd|12|1020
10|xyz|1011|1020
abc|abcd|11|1020
10|xyz|1010|1020
abc|abcd|10|1020
10|xyz|1010|1020
I am generating a... (3 Replies)
Hi.
I need an input file of a single word pr. line converted in into a list of random pairs.
i need input like this
word1
word2
word3
word4
to be outputted like this:
word3 word1
word2 word4
My attempt is a tedious while loop like this:
nfiles=$(cat inputfile | wc -l) ... (4 Replies)
Discussion started by: BotHead
4 Replies
LEARN ABOUT PHP
cubrid_fetch_row
CUBRID_FETCH_ROW(3) 1 CUBRID_FETCH_ROW(3)cubrid_fetch_row - Return a numerical array with the values of the current rowSYNOPSIS
array cubrid_fetch_row (resource $result, [int $type])
DESCRIPTION
This function returns a numerical array with the values of the current row from the result set, starting from 0, and moves the internal
data pointer ahead.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3)
o $type
-Type can only be CUBRID_LOB, this parameter will be used only when you need to operate the lob object.
RETURN VALUES
A numerical array, when process is successful.
FALSE, when there are no more rows; NULL, when process is unsuccessful.
EXAMPLES
Example #1
cubrid_fetch_row(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$req = cubrid_execute($conn, "SELECT name,area,seats,address FROM stadium WHERE nation_code='GRE' AND seats > 10000");
printf("%-40s %-10s %-6s %-20s
", "name", "area", "seats", "address");
while ($row = cubrid_fetch_row($req)) {
printf("%-40s %-10s %-6s %-20s
", $row[0], $row[1], $row[2], $row[3]);
}
// if you want to operate LOB object, you can use cubrid_fetch_row($req, CUBRID_LOB)
cubrid_close_request($req);
cubrid_disconnect($conn);
?>
The above example will output:
name area seats address
Panathinaiko Stadium 86300.00 50000 Athens, Greece
Olympic Stadium 54700.00 13000 Athens, Greece
Olympic Indoor Hall 34100.00 18800 Athens, Greece
Olympic Hall 52400.00 21000 Athens, Greece
Olympic Aquatic Centre 42500.00 11500 Athens, Greece
Markopoulo Olympic Equestrian Centre 64000.00 15000 Markopoulo, Athens, Greece
Faliro Coastal Zone Olympic Complex 34650.00 12171 Faliro, Athens, Greece
Athens Olympic Stadium 120400.00 71030 Maroussi, Athens, Greece
Ano Liossia 34000.00 12000 Ano Liosia, Athens, Greece
SEE ALSO cubrid_execute(3), cubrid_fetch(3), cubrid_fetch_array(3), cubrid_fetch_assoc(3), cubrid_fetch_object(3).
PHP Documentation Group CUBRID_FETCH_ROW(3)