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

Help Studio
, ,
2

Hello

Try this pattern - 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.

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)
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)633×505 44.2 KB

Use it in an assign activity like this:
Left assign
str_Result

Right assign
system.Text.RegularExpressions.Regex.Match(yourStr, “(?<=Specimen Type:).+”).ToString.Trim

Some feedback on your provided pattern. A good attempt with the right approach but with a few mistakes:

  • There was an extra space after the colon ‘:’ (meaning nothing was going to match unless there was a 2+ spaces).
  • The square brackets matching all whitespace and non whitespace characters would match everything
  • The quantifier on the square brackets ? was incorrect as it mean ‘0 or 1’ character. You should have used a ‘+’ as it meant you are expecting 1 to infinite.
  • Another way of writing your intended pattern with less characters is like this.

You can check out my Regex megapost if you want to see few more examples.

Cheers

Steve

1 Like