I am wanting to search an array of strings for a word or phrase, when it has found a valid string in the array I would then like it to put this into another string array.. So I can then export it all into excel...
dim strOriginalStringArray (5) as string
strOriginalStringArray (1) = "Hello"
strOriginalStringArray (2) = "How are you?"
strOriginalStringArray (3) = "Yes i am ok thank you and you??"
strOriginalStringArray (4) = "I am ok thanks"
strOriginalStringArray (5) = "So what are you up to?"
so then if i search for the word "you" in a textbox, I would then end up with:
dim strSearchedArray as string
strSearchedArray (1) = "How are you?"
strSearchedArray (2) = "Yes i am ok thank you and you??"
strSearchedArray (3) = "So what are you up to?"
Obviously all the strings in the array that have the word "you" in them have now been put into a different array ready to be exported into Excel