How to extract a company name from this expression?

Question

I am struggling with what is most probably a very simple regular expression.

Consider this the text I wish to evaluate:

??Company=My Company Name Ltd??Address= 29 Acacia Road, Nuttytown, AA1 9AA??Description=A very rambling description here... goes on for a bit and then somemore??E-mail=bert@bertswork.com??Version=Super Plus??Expiration date=01/01/2026??First name=Bert??Last name=Bloggs??

I want to extract the string for My Company Name Ltd that is between the Company= and the ??Address= tags.

Please can some kind soul put me out of my misery!

http://stackoverflow.com/questions/6109882/regex-match-all-characters-between-two-strings — Charlie Haley, Aug 14 '15 at 13:18

score 0 · Answer 1 · answered Aug 14 '15 at 13:20

0

Although we usually want to see what you've tried, I've been in your situation - A complete noob and not knowing even where to start, so hope this helps...

Since you know each tag starts with a ?, you can use the following:

\?\?Company\=([^?]*)

This basically says:

It starts with ??Company=
Take all the characters after that until you find the next ? character and place them in a capture group.

Hope that does the trick

answered Aug 14 '15 at 13:20

John Bustos

19,036
17
89
151

Thank you. I am glad you didn't ask what I had tried first before helping me. For the record: I tried google and realised I was not 'getting it'. I then had a cup of tea and a cake to make myself feel better. I then asked the community of experts and you came to my rescue. Cheers :-) – mc1903 Aug 14 '15 at 13:37

Narendrasingh Sisodia · Accepted Answer · 2015-08-14T13:33:42.757

0

You can try this

/(?<=\?{2}Company=)(.*?)(?=\?{2})/

I used lookbehind (?<=) and look ahead (?=) so that ??Company= and ?? is not included in the match.

Regex

edited Aug 14 '15 at 13:33

answered Aug 14 '15 at 13:22

Narendrasingh Sisodia

21,247
6
47
54

Can you deepen your answer? This is not a proper answer. – Altay Mazlum Aug 14 '15 at 13:24
[Check This](https://regex101.com/r/uF4oY4/36) @AltayMazlum – Narendrasingh Sisodia Aug 14 '15 at 13:24
Any Issues with my regex @AltayMazlum – Narendrasingh Sisodia Aug 14 '15 at 13:29
I never had any issue with your regex. It just would have been better if you described the details about it instead of saying _You can try this_. – Altay Mazlum Aug 14 '15 at 13:31
I have updated my answer @AltayMazlum – Narendrasingh Sisodia Aug 14 '15 at 13:33
Thank you for your help. – mc1903 Aug 14 '15 at 13:34
You're welcome @mc1903 – Narendrasingh Sisodia Aug 14 '15 at 13:34

How to extract a company name from this expression?

2 Answers2