How to extract a substring from an EDL line, between 2 sequences of characters
With Powershell, I want to extract from a video markers EDL file (Edit Decision List), the content related the Marker name. Here an example of an EDL line
|C:ResolveColorBlue |M:The Importance of Planning and Preparedness |D:1
I want all what's contained after |M: and before |D: and assign it to a variable.
I applied Regex
$MarkerName = [regex]::Match($line, '[^|M:]+(?= |D:)').Value
In my mind it should extract all what's included between |M: and |D:
I saw an example here https://collectingwisdom.com/powershell-substring-after-character/
No it doesn't. It extracts ResolveColorBlue and nothing else.
Io also tried to apply what's int here
powershell extract text between two strings
But it deosn't work. It's referred to a file, while I have already elaborated all the file content to get my string I need to filter
Where am I wrong please?
Your pattern, [^|M:]+(?= |D:), matches like this:
[^|M:]+- one or more occurrences (+) of any characters but|andM([^|M:], a negated character class)(?= |D:)- that is immediately followed with either a space orD:.
As you see here (mind the selected .NET regex engine on the left!), the match is really ResolveColorBlue as the matching can start after the first : as there is no : and | until the first space, and then it matches till the first whitespace since right after it there is a | char and it cannot be matched with [^|M]. You can see for yourself how the regex engine processes the string at regex101.com:
Use
(?<=\|M:).*?(?=\|D:)
Or, to trim any whitespaces from the match with the regex itself:
(?<=\|M:\s*).*?(?=\s*\|D:)
This regex (see its demo) extracts strings between |M and |D:.
The pipe must be escaped to match a literal | char.
More details:
(?<=\|M:\s*)- a positive lookbehind that matches a location that is immediately preceded with|M:and any zero or more whitespaces.*?- any zero or more chars other than newline as few as possible(?=\s*\|D:)- a positive lookahead that matches a location that is immediately followed with any zero or more whitespaces and then|D:.
- Perl Regex fails to compile looking for \object
- Test if elements in a character string could be numeric
- How to remove all but emojis in a (Javascript) string?
- How to remove all characters from string apart from emoji
- How can I find all matches to a regular expression in Python?
- Zip code validation to exclude some formats
- How to allow specific words using javax.validation.constraints.Pattern?
- Create array of regex matches
- Handling complex parentheses structures to get the expected data
- Catching optional content just after a new line
- Regex to compare strings with Umlaut and non-Umlaut variations
- How can I check when there are only opening or closing quotes in PHP to make replacements?
- Regular Expression | Leap Years and More
- Regex date format validation on Java
- How can I replace every instance of a character from 3 groups of characters with just 3 different characters respectively?
- Regex to match 1 or less occurrence of string?
- Getting parts of a URL (Regex)
- Trim trailing spaces before newlines in a single multi-line string in JavaScript
- Only keep this String in Notepad++ (Regex)
- Redirect Youtube channel main page to videos section the proper way using regex
- Regular expression to validate repeating comma-separated groups without trailing comma
- Angular regex validator allows empty value, while the regex clause should demand at least one digit
- Parsing DeepDiff result
- Rewriting HTTP url to HTTPS using regular expression and javascript
- regex to match HTML <p ...> tag starting with a lowercase letter
- String.split() *not* on regular expression?
- How can I find the last occurance of a dot not preceding with a slash?
- How to extract table names and column names from sql query?
- How to use Rust regex on bytes (Vec<u8> or &[u8])?
- How to validate email by whitelist domain regex