I'm having trouble figuring out how to make use of Text Explorer for the following situation:
Patient narratives in a dataset. The narrative describes adverse events a patient experienced, along with medications, etc. Each narrative could be up to 20,000 characters long, and there could be up to 1000 narratives.
About 2400 regular expressions in another dataset. The regular expressions are searching for a particular condition
I need to search all the narratives using all of the regular expressions. We have a solution in Excel + VBA but I'd like to implement something in JMP, possibly using Text Explorer. I played around with a small set of regular expressions using Text Explorer and Customize Regex, but the resulting display was disappointing.
Ideally what I'd like is a column next to the FULL NARRATIVE column with the found regular expressions highlighted.
Our VBA solution is quite fast; I tried using JSL + for loops and regex to search a small set of narratives (23) for all of the regular expressions, and it was very slow.
Here's the code for a text explorer search with 5 regular expressions: