Hello Davinder
I am assuming that you read in the Excel file as a 2D array of text strings
(since you have column headers). If the column headers are in the first row of
the array, then you can use the Array function "Index Array" (with 2 input
dimensions to firstly slice off the first row of the array wiring a 0 (zero) to
the first dimension, and disabling the second dimension. Then, wire this row (a
1D array) to the Array function "Search 1D Array", together with the string you
want to search for (this may be a constant, a control, or a string selected from
a string array by a ring-control). Note: it will be a case-sensitive search.
The returned index (if not -1) will correspond to the column number that you
want. To slice out the column you want from the origi
nal array, wire this index
to a second "Index Array", this time disabling the first dimension and wiring the
index to the second dimension. The output of this function should be want you
want.
Paul
Davinder Lotay wrote:
> I would like to read in an EXCEL speadsheet and seach through the first row
> containing headings for the columns and select the column that is of interest.
> The column of interest would be selected from the front panel.
>
> I can read in the EXCEL file and see the contents, but stripping and selecting
> the column is what I am having difficulties.
>
> ANY HELP IS APPRECIATED
--
Research Assistant
School of Physiotherapy, Curtin University of Technology
Selby Street, Shenton Park, Western Australia, Australia. 6008
email: P.C.Davey@curtin.edu.au
Tel. +61 8 9266 4657 Fax. +61 8 9266 3699
"Everyone who calls on the name of the Lord will be saved." Romans 10:12
"For all have sinned and fall short of the glory of God, and are justified freely
by his grace thr
ough the redemption that came by Christ Jesus." Romans 3:23-4
