Regular Expression function for EasyCatalog/InDesign

Question

Hi allHope you can help with the below. I am working with EasyCatalog plugin for InDesign and am trying to extract certain data from a cell with a function in a Custom Field Options. This is the usual data in the cell:

Yarn: 100% New Zealand Thin Wool or Tencel

– Primary backing: 100% Polyester

– Backing: 100% Polyester

– Pile Height: 16mm

I need to extract "Pile Height: (and the numbers) ". I spend the last 2 days reading about REGEX expressions etc. and I can't manage to do that no matter how I try. Could someone have any ideas? Many thanks!Miro.

Eugene Tyson · Accepted Answer

Pile Height: 16mm Regex(?i)Pile\hHeight\:\h\d+?mm Not sure if it's helpful for the catalog - but looks right to me

Calculer_enligne1704 · Answer

Hi Miro,It sounds like you're trying to extract the "Pile Height" value using a regex expression in EasyCatalog, and it’s definitely doable with the right pattern. Given the structure of your data, here's a regex that should work: Pile Height:\s*(\d+mm)Explanation:Pile Height: is the literal text you're looking to match.\s* accounts for any spaces or line breaks after the colon.(\d+mm) captures the number (digits) followed by "mm", which is the value you're interested in.You should be able to use this regex in the Custom Field Options to pull out the "Pile Height" and its corresponding number.Let me know if that works, or if you run into any issues!Best,Henry James

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded