Use content of a database field in RegEx
Regular Expressions
1
Posts
1
Posters
4
Views
1
Watching
-
I want to be able to use the content of a database table as part of a regex expression. This isn't the actual use case, but it shows what I want to do. Database table includes a field with customer names, "Acme","Starbucks","Delta". This table gets updated with new customers daily. I have a simple RegEx that looks for the existence of some text in an OCR'd document. (?i)(Acme|Starbucks|Delta) I want to update the RegEx statement with the new entries. I know I can do it through some external scripting, but what I would like to do is embed some sort of call to the table and column a the time of execution, like "(?i)(ODBC Hook to the data here)"