I feel like this should be simply but I've been staring at my Event Editor for ages and my mind's starting to blank out.
Basically, I have an Edit Box object which the user can type words into. When a word is input and the user presses "Enter", a fastloop begins which searches for the input word within a specific column of a DataGrid object and then returns the text contained within the adjacent column. This has been tried and tested and works perfectly fine.
My problem is that, for the sake of efficiency and to cut out a lot of monotonous work, I'd like the fastloop search to search for text within the cell, rather than look for a cell with an exact match of the input text.
For example, currently the user types in "hello" and the fastloop searches for a cell within column 2 which contains exactly the text "hello". I'd like the user to search "hello" and the loop to find the text "hello" within a cell that contains the text "hello; hi; hey".
My current, very basic, formula:
+ Upon pressing "Enter"
- Special: Start loop "search" NLines("DataGrid") times
+ On loop "search"
+ Alterable String A of Edit Box = Text$("DataGrid", LoopIndex("search"), 2)
- Rich Edit Object: Append 'Alterable String A("Edit Box") + NewLine$' to text
- Rich Edit Object: Append 'Text$("DataGrid", LoopIndex("search"), 3) + NewLine$ + NewLine$' to text
Sorry if none of this makes any sense, I'm very tired