use of substring to get text within text
Hi there,
I have a field that collects lab test impression (lab results) text for each lab test. The field is named Results. This text can be in multiple lines for each lab test.
Here's an example:
Lab_test_ID Results_LINE Results
LAC20009127 1 Lab test group:
LAC20009127 2 "Third Trimester: Group B Streptococcus"
LAC20009127 3
LAC20009127 4 IMPRESSION: Impression:
LAC20009127 5 screened group B strep
LAC20009127 6 Group B strep bacteria are present
LAC20009127 7 gestation 36 weeks
LAC20009127 8 susceptibility of GBS to erythromycin and clindamycin need to be determined
LAC20009127 9
LAC20009127 10 Tester_id: tac145
LAC20009128 11 Auth_id: bgg236
I need to retrieve all text starting at "IMPRESSION: Impression:" and ending before the line of text with the Tester_id. All impression text ALWAYS start with the words "IMPRESSION: Impression:". The text with the words "IMPRESSION: Impression:" may or may not start at line 4 in the Lab_Results table. The lines with the text in between "IMPRESSION: Impression:" and "Tester_id:" is always variable (it's never at a static 6 lines like this example has.
How can I use substring or other string manipulation to get the text I need?
Thanks much in advance!
Best regards,
wdelaney
I have a field that collects lab test impression (lab results) text for each lab test. The field is named Results. This text can be in multiple lines for each lab test.
Here's an example:
Lab_test_ID Results_LINE Results
LAC20009127 1 Lab test group:
LAC20009127 2 "Third Trimester: Group B Streptococcus"
LAC20009127 3
LAC20009127 4 IMPRESSION: Impression:
LAC20009127 5 screened group B strep
LAC20009127 6 Group B strep bacteria are present
LAC20009127 7 gestation 36 weeks
LAC20009127 8 susceptibility of GBS to erythromycin and clindamycin need to be determined
LAC20009127 9
LAC20009127 10 Tester_id: tac145
LAC20009128 11 Auth_id: bgg236
I need to retrieve all text starting at "IMPRESSION: Impression:" and ending before the line of text with the Tester_id. All impression text ALWAYS start with the words "IMPRESSION: Impression:". The text with the words "IMPRESSION: Impression:" may or may not start at line 4 in the Lab_Results table. The lines with the text in between "IMPRESSION: Impression:" and "Tester_id:" is always variable (it's never at a static 6 lines like this example has.
How can I use substring or other string manipulation to get the text I need?
Thanks much in advance!
Best regards,
wdelaney
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
that's ridiculous to be given an assist for the solution
ASKER
ah, apologies, sujith80! I'm not used to the way things are awarded points on the site. I liked both answers - both could work in my situation. I thought if I split the points, both would be "accepted". I agree with you, the first answer should be the accepted one.
ASKER
sujith80, I've emailed a request to customer service requesting an adjustment in the points awarded to the more appropriate answer.
Thank You, wdelaney05
ASKER
I hesitate to use LISTAGG because I think LISTAGG may have character limitations to it (I think it's 4000 characters. My text may be longer than 4000 characters sometimes).
I'll have to look around for other string concatenation techniques.