Hi, I have this text and want to extract the text after "Sample Type: " and before the \r character at the end of that line. HPV PRIMARY SCREENING Specimen Type: Liquid based cytology (SurePath) HrHPV: Not detected CYTOLOGY Site: Cervical The sp…

Hello Try this pattern - <a href="http://regexstorm.net/tester?p=%28%3f%3c%3dSpecimen+Type%3a%29.%2b&i=HPV+PRIMARY+SCREENING+%0d%0a%0d%0a++++Specimen+Type%3a+Liquid+based+cytology+%28SurePath%29%0d%0a%0d%0a++++HrHPV%3a+Not+detected%0d%0a%0d%0a++++++++++++++++++++++++++++++CYTOLOGY+%0d%0a++++Site%3a++Cervical%0d%0a%0d%0a++++The+specimen+is+satisfactory+for+evaluation.%0d%0a%0d%0a++++NEGATIVE+FOR+INTRAEPITHELIAL+LESION+OR+MALIGNANCY.%0d%0a%0d%0a++++The+next+HPV+screening+test+should+be+taken+in+5+years%2c+based+on+the%0d%0a++++NCSP+Register+history.+Overseas+tests+are+noted+on+the+request+form%0d%0a++++but+are+not+recorded+in+the+NCSP+Register.+This+recommendation+is%0d%0a++++based+on+current+test+results+and+the+NCSP+Register+records+only+and%0d%0a++++may+need+to+be+modified+if+other+results+were+reported+overseas.%0d%0a++++Please+forward+copies+of+overseas+pathology+reports+or+an+overseas%0d%0a++++specialist+letter+confirming+dates+and+results+of+previous+pathology%0d%0a++++tests+to+the+NCSP+Register." rel="noopener nofollow ugc">preview the pattern here : (?<=Specimen Type:).+ It will return all text until the end of the current line. We can capture and trim the result in the assign activity below. <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/4/d/2/4d2319db0242219799467d20a30f7485f4bd1b5a.png" data-download-href="/uploads/short-url/b0nY3W5aoK2hsVQouveLX4Jx5jA.png?dl=1" title="The image shows a regex test result from Regex Storm.net highlighting the extraction of the text "Liquid based cytology (SurePath)" under the "Specimen Type" from a sample input. (Captioned by AI)" rel="noopener nofollow ugc">[The image shows a regex test result from Regex Storm.net highlighting the extraction of the text …

Extract Words between a string and the end of the line in a multi-line string

Help Studio

Yoichi (Yoichi) August 21, 2024, 11:30pm 4

FYI, it’s known matter as the following post.

And the problem with your original pattern seems to be the extra white space at the red arrow in the following image.

Regards,

1 Like

Topic		Replies	Views
How to get text starting from a word to end of the line Studio studio , question , activities_panel	12	229	October 31, 2024
How to get a specfic text from a string Studio studio , question , activities_panel	6	155	January 5, 2024
Regex to extrac text between (multi-lines) Studio selector , uiautomation , robot , activities , studio , data_scraping , question	4	1161	May 26, 2021
Need to find string(word) position and next find or extract word right side 5 charecters Studio studio , question , activities_panel	12	149	June 3, 2024
To take a paragraph after a word using regex Help	3	2983	September 13, 2019

Extract Words between a string and the end of the line in a multi-line string

Related topics