Field 1 contains different length strings separated by commas. I want to find the partial string "trache". If it is present in field 1 I want to find the date from field 2 which will be in the same comma-separated order.
1 thought is to expand both fields (I could transpose them if that's easier) to separate the text of each, then search for "trache" and if present, move to find the corresponding date. Not sure how to do that or whether it is best thing.
2 example cells:
A Arterial Line, Central Line, Hypertonic Saline, ICP Monitoring, Bronchoscopy, Arterial Line, Percutaneous Tracheostomy
B 03/06/2007, 03/06/2007, 03/06/2007, 03/06/2007, 05/06/2007, 13/06/2007, 13/06/2007
Bookmarks