Regex New Line Blank Output

(0) Share

Report

Posted on by UK_Mike

Hi All,

Both of these work on all regex builders but not in Pad (reading a simple string from a text file).

(?<=Shipping\sDate\n).+

(?<=Shipping\sDate[\r\n]).+

Shipping Date
13/10/2000

Any help appreciated 😊

Screenshot 2022-02-20 201716.png

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

josephb61 65 on at

Like (1)

Report
Copy link

Link copied!

@UK_Mike

The PAD regular expression actions use the .Net Regular Expression Engine, so you need to use syntax matching that dialect of regular expression syntax.
That said you syntax should have worked, unless as I suspect you have extra whitespace, before the the CRLF.

The way I code this is as follows. Try and let us know, if this works for you.

(?<=Shipping\s+Date)(.|\n)+

Was this reply helpful? Yes No
josephb61 65 on at

Like (1)

Report
Copy link

Link copied!

@UK_Mike
Also, when you use the Read Text File action - use into Single Text Variable option and suggest use Encoding: ANSI.

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Hey Joe, that worked a treat 😀
I treble checked for whitespace so yes my original should have worked.
Added a bit as I didnt want to catch a new line, if any.
I only used Regex Storm once or twice as there wasnt much help in the site.
I mainly use Regexr which works great, I think where I came unstuck was the new line ( Java versus .Net )
Below works on both Utf-8 and Ansi.

Many thanks Joe 👍

Was this reply helpful? Yes No
josephb61 65 on at

Like (0)

Report
Copy link

Link copied!

So, not to need to depend on text following, you can also do below.
(?<=Shipping\s+Date)(.|\n)+?\d+(\|-)\d+(\|-)\d+

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Hmmmmmmmmmm....
Not working 🤔
More often than not I will know if any text below what I want but that would be excellent... 😁

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

This works, room for improvement ?

Was this reply helpful? Yes No
josephb61 65 on at

Like (0)

Report
Copy link

Link copied!

@UK_Mike
I had my slashes in the wrong direction, they should have been forward slashes, as you discovered.

Was this reply helpful? Yes No
josephb61 65 on at

Like (1)

Report
Copy link

Link copied!

Corrected syntax below .... should accept both formats of date separators (slash or dash) 1/12/2020 or 1-12-2020
(?<=Shipping\s+Date)(.|\n)+?\d+(/|-)\d+(/|-)\d+

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Not just me huh 😂
Thats excellent.
Cheers buddy, will add to my never ending cheat sheet 😀

Was this reply helpful? Yes No