If you change the read to read into an array, you can access each member of the array by index.
e.g.
You could combine those two echo lines inside the while-loop with:
but it's a bit messier to look at.
edit: I guess that's read -a (lowercase -a in Bash)
edit 2: Another option, using shell positional parameters:
Last edited by Scott; 11-27-2017 at 07:16 PM..
Reason: edit
I am executing a stored proc and sending the results in a log file. I then want to grab one result from the output parameters (bolded below, 2) so that I can store it in a variable which will then be called in another script. There are more details that get printed in the beginning of the log file,... (3 Replies)
Hello all I hope someone can help me. I am trying to convert something I wrote in C to bash.
But how do I go about reading more than one item at a time in a for loop?
i have been using this format for the loops in the bash script i have been building.
e.g.
for word in `cat -s... (4 Replies)
I have a process that is running locally on the machine.
When you telnet to the process: telnet IP port, it automatically returns a string which shows the status of that process.
Something like this:
# telnet IP Port
Trying 127.0.0.1...
Connected to localhost (127.0.0.1).
Escape... (3 Replies)
ok, so a script i wrote spits out an output like the below:
2,JABABA,BV=114,CV=1,DF=-113,PCT=99.1228%
as you can see, each field is separated by a comma. now, how can I get rid of the first field and ONLY show the rest of the fields.
meaning,
i want to get rid of the "2,", and... (3 Replies)
Hi,
I am trying to implement a server monitoring dashboard using cgi scripting. I am planning to run the necessary unix scripts from the web page using cgi. This method works fine for standard unix commands but I am unable to run some external unix commands (like swadm show_processes, swadm... (9 Replies)
Hi,
my script is setting a variable with value and this variable is present in my another command that is coming from external file and this command is internally called after this variable is set. but while execution of this command, the value is not retrieved properly.
say,
my script... (5 Replies)
Hello everyone,
I am doing some sort of analysis for some data about organic solvents, and I have a problem with writing a command to do this:
Here's a sample of my file:
1 ethanol
2 methanol
3 methanol/ethanol
4 ethanol/methanol
5 ethanol/DMF
6 ethyl... (6 Replies)
I have several .csv files containing data like this:
field_1;field_2;date;comment;amount;
I want to extract the 3 last fields and load them in a database.
my input_file = "/dir/file.csv";
my output_file = "/dir/file.sql";
open my $csv_file, '<', $input_file
or die "Can't... (1 Reply)
Hey guys, I am working on a script that needs to grab variables from a log file. The script will run morning 9 to 5pm and save variables for each run every hour, these results I will be aggregating at the end of the day.
I am thinking I will be placing the date on each entry in the log every... (7 Replies)
Discussion started by: mo_VERTICASQL
7 Replies
LEARN ABOUT PHP
mssql_field_seek
MSSQL_FIELD_SEEK(3)MSSQL_FIELD_SEEK(3)mssql_field_seek - Seeks to the specified field offsetSYNOPSIS
bool mssql_field_seek (resource $result, int $field_offset)
DESCRIPTION
Seeks to the specified field offset. If the next call to mssql_fetch_field(3) won't include a field offset, this field would be returned.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $field_offset
- The field offset, starts at 0.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Using mssql_field_seek(3) on the example for mssql_fetch_field(3)
<?php
// Connect to MSSQL and select the database
mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');
// Send a select query to MSSQL
$query = mssql_query('SELECT * FROM [php].[dbo].[persons]');
// Construct table
echo '<h3>Table structure for 'persons'</h3>';
echo '<table border="1">';
// Table header
echo '<thead>';
echo '<tr>';
echo '<td>Field name</td>';
echo '<td>Data type</td>';
echo '<td>Max length</td>';
echo '</tr>';
echo '</thead>';
// Dump all fields
echo '<tbody>';
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
// Fetch the field information, notice the
// field_offset parameter is not set. See
// the mssql_field_seek call below
$field = mssql_fetch_field($query);
// Print the row
echo '<tr>';
echo '<td>' . $field->name . '</td>';
echo '<td>' . strtoupper($field->type) . '</td>';
echo '<td>' . $field->max_length . '</td>';
echo '</tr>';
// Move the internal seek pointer to the next
// row in the result set
mssql_field_seek($query, $i + 1);
}
echo '</tbody>';
echo '</table>';
// Free the query result
mssql_free_result($query);
?>
SEE ALSO mssql_fetch_field(3).
PHP Documentation Group MSSQL_FIELD_SEEK(3)