Hi. I have a long string that I'm retrieving from a file. I have a list in the database of different strings. I want to take my list and compare it to the strings from the file. For all instances that it finds I want it to format the text as a link.
My issue is that I want to find the text that starts with specific letters and ends with a specific letter and then turn that part of the strng into an href. I need s/t like the percent symbol in SQL.
What I want to say is
Replace(string that has the text to replace, T%t. "<a href= "T%t."> T%t"
The text I want to search for is the word "Text."

Thanks.