Its working but there is realignment in the data spacing.
The existing data positions should not be disturbed and the number of characters 248 should be maintained in the result too
There will be blank spaces at the end of each line and in between data as well. the blank space indiactes there is no data for that field.
Actually there are certain field names by which the reports are generated, if that field is not available in the report there will be blank space to mention that.
I need to maintain the length 248 characters. Since this file will be sent for formatting to different format in another server. So data has to be intact.
there must be 11 blank spaces after the timestamp : 20090309102806279
after that i need to insert the 441 if 442 is present.
As I said what I gave you was just a first idea (not the final solution) about how to proceed. According to what you wrote, you would need to add conditions inside the for loop in order to add or remove space characters according to the appropriate context.
splits the current line into tokens. So you have tokens and it's up to you to decide when and where to remove or insert space characters and how many. However if you look carefully at the script I just add one '\n' at the end of each line which I suppose is needed and one ' ' between each token '$RESULT $ITERATOR', so If you need more speces well you can increase them here or as I said elsewhere inside the loop by some If Else block.
I have a datafile having structure like
col1,col2,col3
col1,col2,col3,col4,col5
col1,col2,col3,col4,col5
.....
Can we take only first row of values from datafile and put into respective variable.
How col1 can be captured in a variable called v_col1 from unix script.
like first row(only)... (1 Reply)
Guys -- I am noob and I am really strugging on this one. I cant even write the pseudo code for it. I have a file that spits values in individual rows as such:
file:
user date type size
joe 2005-25-09 log 1
joe 2005-25-09 snd 10
joe 2005-25-09 rcd 12
joe 2005-24-09 log 2
joe... (1 Reply)
Hello,
I have an input file like the following:
11_3_4
2_1_35
3_15__
_16989
Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Hello,
I want to add a new row to a file to insert data without deleting the previous data there.
Example:
file
a
b
c
d
Output
a
b
newtext
c (6 Replies)
Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :(
Dear community,
I have a table with two rows like:
Row1 Row2
======= =======
7,3 text 1
1,3 text 2
1,2,3 blabla
What i need to do is add/copy... (2 Replies)
Hi ALL,
We have requirement in a file, i have multiple rows.
Example below:
Input file rows
01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212
01,1,102319,0,1,80,20,U,1,241,00000059420000006021
I need my output file should be as mentioned below. Last field should split for... (4 Replies)
I have the following script that will average the last two fields of each row, but im not sure how to include the 3rd field of the following row.
An example of the analysis that I need to perform from the input - (66.61+58.01+54.16)/3
awk '{sum=cnt=0; for (i=13;i<=NF;i++) { sum+=$i; cnt++... (1 Reply)
Discussion started by: ncwxpanther
1 Replies
LEARN ABOUT PHP
msql_fetch_array
MSQL_FETCH_ARRAY(3)MSQL_FETCH_ARRAY(3)msql_fetch_array - Fetch row as arraySYNOPSIS
array msql_fetch_array (resource $result, [int $result_type])
DESCRIPTION msql_fetch_array(3) is an extended version of msql_fetch_row(3). In addition to storing the data in the numeric indices of the result
array, it also stores the data in associative indices, using the field names as keys.
An important thing to note is that using msql_fetch_array(3) is NOT significantly slower than using msql_fetch_row(3), while it provides a
significant added value.
PARAMETERS
o $
result -The result resource that is being evaluated. This result comes from a call to msql_query(3).
o $result_type
- A constant that can take the following values: MSQL_ASSOC, MSQL_NUM, and MSQL_BOTH with MSQL_BOTH being the default.
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
msql_fetch_array(3) example
<?php
$con = msql_connect();
if (!$con) {
die('Server connection problem: ' . msql_error());
}
if (!msql_select_db('test', $con)) {
die('Database connection problem: ' . msql_error());
}
$result = msql_query('SELECT id, name FROM people', $con);
if (!$result) {
die('Query execution problem: ' . msql_error());
}
while ($row = msql_fetch_array($result, MSQL_ASSOC)) {
echo $row['id'] . ': ' . $row['name'] . "
";
}
msql_free_result($result);
?>
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.0.4 | |
| | |
| | A bug was fixed when retrieving data from col- |
| | umns containing NULL values. Such columns were |
| | not placed into the resulting array. |
| | |
+--------+---------------------------------------------------+
SEE ALSO msql_fetch_row(3), msql_fetch_object(3), msql_data_seek(3), msql_result(3).
PHP Documentation Group MSQL_FETCH_ARRAY(3)