Hi, can someone help me perform two types of searches in a text file? Thanks.
I have a data file with 6 columns and several rows of data, and I want to perform some searches.
In the file, the line starts with - and the fields are separated by $
-Field1$Field2$Field3$Field4$Field5$Field6
First Search
The user enters a search term, and pressing the button searches for the word in Field1.
As a result, I want to display:
Field1 Value
Field2 Value
Field3 Value
Field4 Value
Field5 Image
Field6 Image (if present)
Second Search
The user enters a search term in the first and second boxes. When the button is pressed, the word from the first box is searched for in Field3 AND the word from the second box is searched for in Field4.
As a result, I want to display Field1 of all results:
Field1 Value
Field1 Value
Field1 Value
Example text file
-Pippo$Text Text Text Text $Circle$Red$pippo1.jpg$
-Pluto$Text1 Text1 Text1 Text1 $Circle$Green$pluto1.jpg$pluto2.jpg
-Paperino$Text2 Text2 Text2 Text2 $Square$Green$paperino1.jpg$
-Gastone$Text3 Text3 Text3 Text3 $Square$Red$gastone1.jpg$gastone2.jpg
)
