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:.
- How can I make these html & php patterns work?
- Replace backslash '\' with forward '/' slash in VS Code snippets with Regex
- Python regular expression for multiple split criteria
- Using regular expression to extract substring
- Regex to find a float
- Regex replace with a small text change?
- Regex for one or more words separated by spaces
- How does Python's unittest library match patterns passed via the -p parameter?
- What regex can allow a delimiter, but only if the surrounding groups exist?
- Apache Nifi Expression Language: find part of content, which matches to regex
- Using a gsub to split a name based on special characters
- Extracting only characters from a string in Python
- RegEx for word boundary but still match if is preceded or followed by special chars
- Analogue for regex '?' (preceding item optional) in T-SQL like?
- Private IP Address Identifier in Regular Expression
- Whitespace woes in Regex
- Visual Basic .net Regex match does not work - despite working on a testing tool?
- Extracting with regex two conditions of some text
- Google Sheets Regex for the inconsistent pattern
- String Expansion program gives incorrect output
- regex to remove ordinals
- Using gsub to extract all information before and after the first white space
- How to replace all BUT the first occurrence of a pattern in string
- How to solve JS Regex not working during keypress
- Match whitespace but not newlines
- Regex - Match repeated character not in sequence
- Regular expressions: Matching strings with dot (.)?
- How to deal with Polish Characters while using regex?
- ADF - Dataflow expression builder cleaning/parsing columns
- Can I test if a regex is valid in C# without throwing exception