regular expression (usually called regex or regexp) are a sequence of characters which help you search in text (strings). Various systems use Regex for field validation, find or find&replace operations in text (strings). Regex is common in computer science. See Wikipedia Regex for more details.

Regex is used in Picturepark Business Rules or field format validations. Regex is best suited when you have a proper file naming convention in place.

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

Get specific product code from the filename

The product code must be at the beginning and must be 14 characters long. 

(?<productCode>^(F-|G-|V-)[^_]*?)_()
CODE

Get any type of product code from the original filename

(?<productCode>^[0-9]{2} [0-9]{3} [^-]*)-(?<filename>.*)
CODE

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

Get code that starts with MT-

(?:MT|\G)-(?<mediaType>[A-Z\s]{3,4})
CODE

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