Regular Expressions Discussion Boards

Re: Regular Expression To Extract Everything Including the String And Before The First Space Character

Richard MacCutchan30-Aug-19 21:42

30-Aug-19 21:42

Yes, the documentation is right there on the front page. You put your own test data into the box labelled "Text". Then add your regex in the box titled "Expression". The menus on the left point you to the documentation for all the regex types. What could be simpler?

Regex Expression to extract everything following a string and before a space

Member 1457241529-Aug-19 6:30

Member 14572415

29-Aug-19 6:30

Hi all,

I am looking for a regular expression to extract everything following a string and before a space. Please see the example below.

Order placed at the store. Order Date: 01/12/2017 This was completed.

From the above string, I would like to extract the following.

Order Date: 01/12/2017

Thanks,
Ana

Re: Regex Expression to extract everything following a string and before a space

Richard MacCutchan29-Aug-19 6:55

Richard MacCutchan

29-Aug-19 6:55

How about: Order Date: \d\d\/\d\d\/\d\d

Re: Regex Expression to extract everything following a string and before a space

Richard Deeming29-Aug-19 7:04

Richard Deeming

29-Aug-19 7:04

Perhaps with a couple of extra \ds to cope with the four-digit year? Smile | :)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Regex Expression to extract everything following a string and before a space

Richard MacCutchan29-Aug-19 8:44

Richard MacCutchan

29-Aug-19 8:44

Oops again. D'Oh! | :doh:

Re: Regex Expression to extract everything following a string and before a space

Member 1457241529-Aug-19 8:36

Member 14572415

29-Aug-19 8:36

Hi Richard,

My string is like the following.

Order placed at the store. Order Date: 01/12/2017 10:54 AM This was completed.

I would like to pull "Order Date: 01/12/2017 10:54 AM"

Hope this helps.

Thanks,
Ana

Re: Regex Expression to extract everything following a string and before a space

Richard MacCutchan29-Aug-19 8:47

Richard MacCutchan

29-Aug-19 8:47

If you take my original Order Date: \d\d\/\d\d\/\d\d , plus Richard Deeming's reply to me \d\d for the rest of the year, then you should be able to work out what else is needed. And you can test your expression online at RegExr: Learn, Build, & Test RegEx[^].

Re: Regex Expression to extract everything following a string and before a space

Member 1457241529-Aug-19 9:29

Member 14572415

29-Aug-19 9:29

Yes, that work!

Thanks

Re: Regex Expression to extract everything following a string and before a space

Richard Deeming29-Aug-19 7:10

Richard Deeming

29-Aug-19 7:10

If you want to include the "Order Date: " in your extracted value:

Order Date:\s*[^\s]+

If you just want the "01/12/2017", and you're using C#, then:

(?<=Order Date:\s*)[^\s]+

(Other regular expression processors may also support "zero-width positive lookbehind" assertions. But Javascript, for example, doesn't.)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Regex Expression to extract everything following a string and before a space

Member 1457241529-Aug-19 8:00

Member 14572415

29-Aug-19 8:00

Hi Richard,

Thanks for your response!

Since I need the order date, I tried using "Order Date:\s*[^\s]+" per your post above, and it is pulling text after the date, time and AM/PM. So, I would like to pull everything before the date, time and AM/PM.

Any suggestions would be appreciated.

Thank you!
Ana

Re: Regex Expression to extract everything following a string and before a space

Member 1457241529-Aug-19 8:03

Member 14572415

29-Aug-19 8:03

So, my string is like the following.

Order placed at the store. Order Date: 01/12/2017 10:54 AM This was completed.

I would like to pull "Order Date: 01/12/2017 10:54 AM"

Hope this helps.

Thanks,
Ana

Re: Regex Expression to extract everything following a string and before a space

Richard Deeming29-Aug-19 8:50

Richard Deeming

29-Aug-19 8:50

You specifically said you wanted to extract the text up to the first space, and there is a space between 2017 and 10:54. And then another space between 10:54 and AM.

If the date and time is always in the same format - which doesn't match the example you gave in your original message - then try something like:

Order Date: \d\d\/\d\d\/\d\d\d\d \d\d:\d\d [AP]M

Demo[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Regex Expression to extract everything following a string and before a space

Member 1457241529-Aug-19 9:12

Member 14572415

29-Aug-19 9:12

Hi Richard,

Sorry for the confusion. I tried the expression that you posted and it works perfectly!

Also, I would like to pull "Name is: Tia" from the following string:

My friend's Name is: Tia She lives in Argentina.

Thanks so much,
Ana

Re: Regex Expression to extract everything following a string and before a space

Richard Deeming29-Aug-19 9:53

Richard Deeming

29-Aug-19 9:53

Only one name, with no spaces?

Name is: [^\s]+

Demo[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Regex Expression to extract everything following a string and before a space

Member 1457241529-Aug-19 10:05

Member 14572415

29-Aug-19 10:05

Hi,

I tried "Name is: [^\s]+" but I am getting back the text after the space as well. How can I fix this?

Thanks,
Ana

Re: Regex Expression to extract everything following a string and before a space

phil.o29-Aug-19 19:29

phil.o

29-Aug-19 19:29

You could try "Name is:\s([^\s]+).*$".
The result will be in the first numbered group of the result.

string input = "My friend's Name is: Tia She lives in Argentina.";
Regex r = new Regex(@"Name is:\s([^\s]+).*$");
string name = r.Match(input).Groups[0].Value;

while (!(success = Try()));

Re: Regex Expression to extract everything following a string and before a space

Richard Deeming30-Aug-19 3:05

Richard Deeming

30-Aug-19 3:05

Then there's either a bug with the regular expression engine you're using, or there's something wrong with your code.

[^\s]+ explicitly excludes any spaces. That pattern will match the first run of characters which are not spaces to appear after the prefix "Name is: ".

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Matching separate regions

Member 1450443318-Jun-19 4:10

Member 14504433

18-Jun-19 4:10

Hi,
I'm using Notepad++ to do some Regex replacements and have come up against a problem I can't solve.
I'm looking to match a region between two fixed strings inclusive (called <startstring> and <endstring> for the sake of example). The problem I have is these strings appear multiple times throughout, but I want to match EACH instance, rather than one match from the very first <startstring> to the last <endstring>. They may or may not be over many lines. For example:

<startstring>

...text body...

<endstring>

...other text...

<startstring>

...text body...

<endstring>

...other text...

<startstring>

...text body...

<endstring>

I need my Regex to make 3 separate matches, rather than 1 big match which includes all the ..other text... which I need to be left intact.

The above needs to work irrespective of whether the <startstring> and <endstring> are on the same line or many lines apart.

Thanks in advance.

Re: Matching separate regions

OriginalGriff18-Jun-19 4:12

OriginalGriff

18-Jun-19 4:12

Try:

public static Regex regex = new Regex(
      "\\<startstring\\>.*?\\<endstring\\>",
    RegexOptions.Singleline
    | RegexOptions.CultureInvariant
    | RegexOptions.Compiled
    );
...
    MatchCollection ms = regex.Matches(InputText);

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Re: Matching separate regions

Member 1450443318-Jun-19 5:40

Member 14504433

18-Jun-19 5:40

Thanks, that's led me to the correct solution for all eventualities Thumbs Up | :thumbsup:

Re: Matching separate regions

OriginalGriff18-Jun-19 5:46

OriginalGriff

18-Jun-19 5:46

You're welcome!

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Cannot extract end of line data

mo14927-Jan-19 3:44

mo1492

7-Jan-19 3:44

Hello, I am new to using Regex and hope someone can help with my expresion.
I am using VB.net Regex.Match() to extract info.

I cannot figure out how to include the text at the end of a line in my expression.
I'm using Expresso for testing my expression.

Expression without double quotes:
"(.*?)(\\~zs\\~ls)(.*?)(\\~le\\~ks)(.*?)(\\~ke\\~hs)(.*?)(\\~he\\~ze)(.*?)"

Source Data1:
test \~zs\~lsMt+22:21\~le\~ksMt+22:211\~ke\~hs\~he\~ze end of line

Returns:
[test \~zs\~lsMt+22:21\~le\~ksMt+22:211\~ke\~hs\~he\~ze]
1: [test ]
2: [\~zs\~ls]
3: [Mt+22:21]
4: [\~le\~ks]
5: [Mt+22:211]
6: [\~ke\~hs]
7: []
8: [\~he\~ze]
9: []

I do not get a reference to [end of line]

Source Data2:
\~zs\~lsMark+1:1\~le\~ksMark+1:11\~ke\~hs\~he\~ze some data \~zs\~lsMark+2:1\~le\~ksMark+2:11\~ke\~hs\~he\~ze end of line

Returns 2 matches:
Match1:
[\~zs\~lsMark+1:1\~le\~ksMark+1:11\~ke\~hs\~he\~ze]
1: []
2: [\~zs\~ls]
3: [Mark+1:1]
4: [\~le\~ks]
5: [Mark+1:11]
6: [\~ke\~hs]
7: []
8: [\~he\~ze]
9: []

Match2:
[ some data \~zs\~lsMark+2:1\~le\~ksMark+2:11\~ke\~hs\~he\~ze]
1: [ some data ]
2: [\~zs\~ls]
3: [Mark+2:1]
4: [\~le\~ks]
5: [Mark+2:11]
6: [\~ke\~hs]
7: []
8: [\~he\~ze]
9: []

Again, I do not get a reference to [end of line]

I've tried end the expression with this (.*$) which works for Source Data 1 but
Source data 2 just returns one match with 9:[ some data \~zs....]

Can someone help me with extracting the [end of line] text to item 9:?

thank you

Re: Cannot extract end of line data

jsc4211-Apr-20 8:48

jsc42

11-Apr-20 8:48

I'm not a Reg Exp expert, but I recall that '.' matches anything EXCEPT newline so try replacing (.*$) with ((.|\n)*$). You may also need to switch on multiline matching

Regex code to check textfield is working until a 'enter' is given

Member 1255403315-Mar-18 6:10

Member 12554033

15-Mar-18 6:10

Hi, we are having troubles whit checking a textfield. What we try to do here is to check if the default text has changed. If that is not the case, then a warning will appear at the end of the form.

Everything is working fine until a textfield contains a 'return' (enter) in the text. Even when the default text is gone, the enter will be responsible for the regex-code to fail..

Here the code i have used:

^((?!\bThis contains the default text).)*$

Pleas let me know if you can help me out here

What I have tried:

several codes... Sorry, i don't have them anymore. We also checked the code with a validator.

Re: Regex code to check textfield is working until a 'enter' is given

Gerry Schmitz15-Mar-18 6:27

Gerry Schmitz

15-Mar-18 6:27

You can use (c#) .Trim() on a string to remove leading / trailing "white space", carriage returns, etc.

I tend to do that automatically any time I "save" a string (in a database, for example).

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.