alpha_pinene
New Member
- Joined
- Jan 27, 2022
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
Hi all!
I am so grateful for the help I received with my last question regarding pulling numbers from text, truly saved the day. I am interested in extracting more text-based data regarding tumor characteristics from pathology reports, and relevant metrics would include ulceration, regression, and anatomic level (something called Clark level). I am going to include an XL2BB file with some examples (the file does not contain any actual patient information or protected health information - examples generated to show the different ways the data is entered in these reports).
It might be a lofty goal, but I would like to find some way to pull yes/no for ulceration and regression, and the actual Clark level (often entered as a roman numeral). Ulceration and regression are coded in a frustratingly diverse number of ways, such as present, absent, identified, not identified, yes, no. If getting each of these words is the only workaround rather than converting to a simple yes/no column, that is fine and I can sort through them later (hopefully makes sense when seeing my XL2BB file).
Many thanks in advance if this is possible. I am in awe of the excel prowess and genius of the users on this forum.
Best,
alpha_pinene
I am so grateful for the help I received with my last question regarding pulling numbers from text, truly saved the day. I am interested in extracting more text-based data regarding tumor characteristics from pathology reports, and relevant metrics would include ulceration, regression, and anatomic level (something called Clark level). I am going to include an XL2BB file with some examples (the file does not contain any actual patient information or protected health information - examples generated to show the different ways the data is entered in these reports).
It might be a lofty goal, but I would like to find some way to pull yes/no for ulceration and regression, and the actual Clark level (often entered as a roman numeral). Ulceration and regression are coded in a frustratingly diverse number of ways, such as present, absent, identified, not identified, yes, no. If getting each of these words is the only workaround rather than converting to a simple yes/no column, that is fine and I can sort through them later (hopefully makes sense when seeing my XL2BB file).
Many thanks in advance if this is possible. I am in awe of the excel prowess and genius of the users on this forum.
Best,
alpha_pinene
Book4 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | What text says: | What I need (ulceration): | Alternatively, and better, would be a yes/no for ulceration: | Would also like to adapt formula to check for regression yes/no | Would also like to adapt to collect Clark level (roman numeral or alphanumeric okay) | ||
2 | Regression: not identified, Ulceration: not identified, Anatomic (Clark) level: I | Not identified | No | No | I | ||
3 | Regression: identified, Ulceration: present, Anatomic (Clark) level: III | Present | Yes | Yes | III | ||
4 | Regression: none, Ulceration: absent, Anatomic (Clark) level: V | Absent | No | No | V | ||
5 | Regression; identified Ulceration; yes Anatomic (Clark) level: at least I | Yes | Yes | Yes | ≥I | ||
6 | Regression; no Ulceration; no Anatomic (Clark) level: at least I | No | No | No | ≥I | ||
7 | Regression present, ulceration not identified, clark level cannot be determined | Not identified | No | Yes | Cannot be determined (or whatever placeholder for this) | ||
Sheet1 |