If you change the read to read into an array, you can access each member of the array by index.
e.g.
Code:
unset line
while IFS=_ read -A line; do
NF=$((${#line[@]}-1))
echo ${line[(($NF))]} # last field
echo ${line[(($NF-1))]} # second last field
done < file
You could combine those two echo lines inside the while-loop with:
Code:
echo ${line[((${#line[@]}-1))]} # last field
echo ${line[((${#line[@]}-2))]} # second last field
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:
Code:
while read line; do
IFS=_ set -- $line
...
done < file
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
oci_field_type
OCI_FIELD_TYPE(3)OCI_FIELD_TYPE(3)oci_field_type - Returns a field's data type nameSYNOPSIS
mixed oci_field_type (resource $statement, mixed $field)
DESCRIPTION
Returns a field's data type name.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the field data type as a string, or FALSE on errors.
EXAMPLES
Example #1
oci_field_type(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
echo "<table border="1">
";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Type</th>";
echo "<th>Length</th>";
echo "</tr>
";
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
$column_name = oci_field_name($stid, $i);
$column_type = oci_field_type($stid, $i);
$column_size = oci_field_size($stid, $i);
echo "<tr>";
echo "<td>$column_name</td>";
echo "<td>$column_type</td>";
echo "<td>$column_size</td>";
echo "</tr>
";
}
echo "</table>
";
// Outputs:
// Name Type Length
// NUMBER_COL NUMBER 22
// VARCHAR2_COL VARCHAR2 1
// CLOB_COL CLOB 4000
// DATE_COL DATE 7
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumntype(3) instead. This name still can be used, it was left as alias of
oci_field_type(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO oci_num_fields(3), oci_field_name(3), oci_field_size(3).
PHP Documentation Group OCI_FIELD_TYPE(3)