Online tool to test & validate regular expressions: www.regexr.com
- Make sure PCRE is selected in the top right corner
- Switch between Details and Explain tab
Example: Get product code from filename which is at the beginning and 14 characters long.
Check Filename of Image, Get Product Code and Store in "parsed_filename" Variable
(?<productCode>^(F-|G-|V-)[^_]*?)_()
Example: Use RegEx to extract a product code from the original filename of an image.
RegEx
(?<productCode>^[0-9]{2} [0-9]{3} [^-]*)-(?<filename>.*)
Short Explanation:
- Create a group "productCode"
- Start a the beginning ^
- Get the first two numbers
- Get the next three numbers
- Get the rest until you find a dash -
| Input | Original File name | 01 747 7715 7754-Set_HighRes_4035.jpg |
| Output | productCode (from Regular Expression) | 01 747 7715 7754 |
| Output | filenmae (from Regular Expression) | Set_HighRes_4035.jpg |
Example: Find a code that starts with MT-
(?:MT|\G)-(?<mediaType>[A-Z\s]{3,4})
Short Explanation:
- Create a group "mediaType"
- Get a code that starts with MT
| Input | Original File name | Summer-Campaign_MT-EMOS-Set_HighRes_4035.jpg |
| Output | mediaType (from Regular Expression) | MT-EMOS |