I am working on a letter that is sent to our diabetic patients during their birthday month…the letter will contain the last known test date and results for several measures and then recommend action based on those results. The data comes from a text file (csv file separated by “^”) generated by our Electronic Medical Record (EMR) database…
What I need is a script or tool that will recognize specific text and then change the font size and cell background for that particular field…
In the first example below, everything is normal, so there is no notification necessary…
In the second example, the BP is too high (calculation is performed by our EMR), so the csv file includes “Due Now” and “Yes” for the final two columns in the table. The script needs to recognize “Due Now,” enlarge the font, change the color, and change the background color of the cell, and then recognize “Yes” and do the same.
<img src=”https://www.disabledveteran.net/script_output.jpg”>
Example 1
CSV File Text: ^130/70 (3-28-2011)^Next Visit^No^
InDesign Table:
Measure Your Goal Your Results Next Test? Contact Doctor?
Blood Pressure < 130/80 130/70 (3-28-2011) Next Visit No
Example 2
CSV File Text: ^160/90 (3-28-2011)^Due Now^Yes^
InDesign Table:
Measure Your Goal Your Results Next Test? Contact Doctor?
Blood Pressure < 130/80 160/90 (3-28-2011) Due Now Yes
Is this possible? Is there a tool/script/method that I need?
.
