search for similiar string in the 2D array and display the result with different column

[LimKW]

Hi,

Whoever can help, I have a 2D array from txt file which have many rows and 5 column and I want to do a search and display the other column results.

Eg.

Column 0                      1                           2                                  3                           4

12345                      qwer                       asdf                            12qwe                      tjhrtyert

23568                      werr                        wef                             fgertge                     fsefff

If I manage to search 12345 and I want to display 12qwe, what should I do in labview? Please help!  

[Dennis_Knutson]

Use the Index Array to get column 0, use the Search 1D Array to find the index element, use the index element to get the value in column 3.

[LimKW]

Hi Dennis,

Thanks for your solution. I managed to display what I want. Do you know how to I write back to txt file just by replace the particular column (String).

Example: Column 0 and row 4: abc and Column 4 and row 4:location1 and I want to change to location4 and write it back to the text file. How am I going to do? I attached my VI (Inventory tracking)for your reference.

[Baji · Accepted solution]

---

Example: Column 0 and row 4: abc and Column 4 and row 4:location1 and I want to change to location4 and write it back to the text file. How am I going to do? I attached my VI (Inventory tracking)for your reference.

---

I am not clear with the above sentences.also attach the file that read from the vi.Use array>>Replace array subset function to replace the elements in the array.

Message Edited by Baji on 05-27-2009 03:36 PM

[LimKW]

Hi Baji, the solution you provided is able to replace the array but not on the text file. I have attached the VI and txt file. Example: If i search under asset no. 0023330 and the location is ME-lab and I want to change the location to 123 and replace it on the txt file. What function should I use?

[RavensFan]

You should store the array you are updating in a shift register.  Write the array out to the file when the for loop is done.  As you have it now in both for loops, you are always going back to work on the original array, so only the changes that happen in the last iteration of the for loops actually stick.

[LimKW]

Hi Raven,

Can u show me an example, I don't quite understand what u mean by updating in a shift register.

[Baji]

Example

[LimKW]

Baji, thanks for arranging the block diagram, do u know how I can add a push button to activate the updated to the txt file?

[Baji]

Put the same logic before u used, Put a case structure and wire a boolean control and select the file to update or not. I am not arranged ur block diagram its the cool feauture of LabVIEW 8.6 it makes life easy.Now the replaced strings are updated in the file?(I am not tested)