Hello,

I have managed to get data out of an Oracle database into my excel
spreadsheet and I now need to analyze a string for variable names and
display their values only.

For each unique script name in column A (I've oncluded two in my
example) I have multiple rows of text in column B. For each unique
script name I want to search corresponding text fields in column B for
the strings v_event_name2, v_remote_host and v_ftac and display their
values, which are on the same line between the single quotes
('<value'), in a different columns. Preferably all in one row behind
the unique script name under column headers that have the name of the
variables.

I have attached my example spreadsheet to this message. I hope this
makes sense. Your help will be greatly appreciated. Regards,

Menno Hubert.
The Netherlands


+-------------------------------------------------------------------+
|Filename: exceltip_Menno.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4230 |
+-------------------------------------------------------------------+

--
Menno
------------------------------------------------------------------------
Menno's Profile: http://www.excelforum.com/member.php...o&userid=27869
View this thread: http://www.excelforum.com/showthread...hreadid=502067