extracting columns from 2D string array according to first element of each column

[RavensFan]

---

@sam67 wrote:

---

---

Thanks for idea but it's little bit difficult for me because i am new in labview. It is possible that you will give me any example if you have similar like this not 100% similar but like this i will try to implement and try to write on this in my current code. Thanks 

---

This isn't really a LabVIEW problem.  It is a general programming problem.  You might be new to LabVIEW, but are you new to programming in general?  Do you know programming logic?  Would you be able to do your task in any other programming language?  Do you know how to write pseudocode or flowcharts to document the thought process and the logic behind it?

If you can, then you are more than half way there and just need to learn what functions and structures are present in LabVIEW.  If you can't do those steps, then you're going to be stuck.

[sam67]

Hello everyone, I am trying to get those rows from the table which is corresponding to the selective indexes. For example, i have one xls file in which different columns of data. currently my code search the selective two columns and their indexes also, know i want to search those selective rows corresponding elements which is in different rows. Lets A B C D E F G are columns name in which 1000 of rows of numbers like A B c D E F G 1 3 4 5 6 3 3 3 4 5 6 3 2 7 ............. 4 7 3 2 5 3 2

So Currently my code search two specific columns (lets suppose B and F selective values which is in some range), now i want to search column A value which is present in those selective ranges.

B F A 3 4 5 3 5 3 7 7 3 5 4 6 ... like this

This is my current code VI

[GerdW]

Hi sam,

For example, i have one xls file

Your VI will not read XLS files properly - it can read just CSV files…

currently my code search the selective two columns and their indexes also, know i want to search those selective rows corresponding elements which is in different rows.

What are "selective rows"?

What have you tried so far to fulfill your requirement?

After all the discussions in this long thread you still aren't able to create a filtering algorithm on your own?

Your post would greatly improve by using some better formatting (like not writing all text into a single line…). It also would help to supply example data AND the expected output! (Didn't we suggest that before?)

[sam67]

---

@GerdW wrote

What are "selective rows"?

What have you tried so far to fulfill your requirement?

After all the discussions in this long thread you still aren't able to create a filtering algorithm on your own?

Your post would greatly improve by using some better formatting (like not writing all text into a single line…). It also would help to supply example data AND the expected output! (Didn't we suggest that before?)

---

Hi GerdW, I readed your suggestion, and i did that code maybe still i am wrong, but i tried my best to learn this. Well know i just want to search those values which is corresponding to the selective columns. Selective columns (LacI and TetR ) in search strings.

[GerdW]

Hi Sam,

Well know i just want to search those values which is corresponding to the selective columns. Selective columns (LacI and TetR ) in search strings.

"Now", not "know". "selected", not "selective"…

Still no example data.

Still no expected output from the example data.

Still no VI where you try to achieve your requirements…

We will not do your homework!

How do those "values correspond to selected columns"?

[sam67]

---

@GerdW  작성:

Hi Sam,

Well know i just want to search those values which is corresponding to the selective columns. Selective columns (LacI and TetR ) in search strings.

"Now", not "know". "selected", not "selective"…

Still no example data.

Still no expected output from the example data.

Still no VI where you try to achieve your requirements…

We will not do your homework!

How do those "values correspond to selected columns"?

---

i want just this

[GerdW]

Hi sam,

you already learned how to read/filter whole columns from a 2D array.

And you learned how to filter parts of those columns by their value.

I don't understand what your current problem is - you already learned those basic steps!

[sam67]

---

@GerdW  작성:

I don't understand what your current problem is - you already learned those basic steps!

---

i tried but i didnt get those value which is corresponding to these selective values. i just need corresponding values of D and J columns. 

[GerdW]

Hi sam,

i just need corresponding values of D and J columns.

First filter for columns D and J.

Then filter for all values in J >= 15.1…

What have you tried? Where are you stuck?

[sam67]

---

@GerdW  작성:

Hi sam,

i just need corresponding values of D and J columns.

First filter for columns D and J.

Then filter for all values in J >= 15.1…

What have you tried? Where are you stuck?

---

for example in column D and J has value 15.63 15.34 15.67 ........, and in corresponding the column C has value 25 24 25 53 22 32 43 25. like this i need these values.