Extract part of string from certain position using regex

Question

String to search for = "in relation to Company A"

Document Contain two lines

(a) in relation to Company A, 31 December 2025;
(b) in relation to Company A, Company B, Company C is 31 December 2025;

Regex which im trying = "(?<=in relation to Company A)(.*)"

But this gives me both lines, I only need first line:

Output Required (means extracting point (a)):

31 December 2025

I'm struggling with changing regex so that i add date part after the word...

Several expressions might help, e.g. in relation to Company A,\s*(\d+.+), this requires at least one digit after your needle. — Jan
– Jan, Commented Oct 26, 2018 at 15:13

Jan · Accepted Answer · 2018-10-26 15:20:05Z

1

For your given examples you could use

in relation to Company A,\s*(\d+[^\n\;]+)

and take the first group, see the demo on regex101.com.

This means

in relation to Company A, # "in relation to Company A," literally
\s*                       # 0+ whitespaces
(\d+[^\n\;]+)             # at least one digit + not a newline nor a semicolon

In the end use the first group in your programming language/tool.

answered Oct 26, 2018 at 15:20

Jan

43.3k11 gold badges57 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract part of string from certain position using regex

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related