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

[Nashaat]

Hi,

I have a 2D string array and I want to extract columns from it according to the string value of on of the elements in each column to formulate a new 2D array. for example: 

in the attached excel sheet a 2D array. I want to extract the whole columns contain "CA/S-" string and "MS/S+" to formulat another 2D string array formed of the columns that contain only those 2 string values.

Thanks a lot and I would reaally apperciiate any input 🙂

Cheers,

Mostafa

[crossrulz · Accepted solution]

Something like this?  I had to convert your Excel file into a CSV.

[altenbach]

If performance is a concern, here's a solution that operates "in place". Modify as needed.

 

[Nashaat]

Thanks a lot. That's exactly what i was looking for 

[e.carano]

Dear Mr. Altenbach,

I'm a beginner in using LabVIEW with datafile.

It would be usefoul for me to have the vi code of your example so I will have a starting point for work on my application.

I need to sure identify the used function to avoid misfunction due to wrong connection for the starting point.

Thak you a lot in any case.

Best regards.

[altenbach]

Transpose array, index array, replace array subset, array subset.
For loop, case structure, shift register.
Try it!

[altenbach]

---

e.carano wrote:

I'm a beginner in using LabVIEW with datafile.

---

If you want code, you need to tell us your LabVIEW version.

If you have a recent version, you can use a conditional tunnel to simplify the code even more. (see attached 2014 version).

[e.carano]

Thank you for your suggestion, I find a way using a similar solution.

I'm using LV 2011.

Best regards.

[altenbach]

---

@e.carano wrote:

Thank you for your suggestion, I find a way using a similar solution.

I'm using LV 2011.

---

LabVIEW 2011 does not have the conditional tunnel.

[e.carano]

---

altenbach ha scritto:
Transpose array, index array, replace array subset, array subset.
For loop, case structure, shift register.
Try it!

---

Sorry, I was referring to your first suggestion.

Best regards.