You are viewing limited content. For full access, please sign in.

Question

Date substitution complication

Quick Fields Pattern Matching and Regular Expressions

Updated June 17, 2016

asked on June 17, 2016

How can I get this date substitution to work?

Every QF capture will be something like this: 9th day of May, 2016. What I'm not sure about is what to type into the Replace field to get it to ignore the parts of the capture that I don't need (like the word "day" and "of"). Here's what I've tried:

0 0

Replies

replied on June 17, 2016

The 'replace' pattern doesn't quite match your example.

The \d{1,2} part matches "9" but doesn't account for the "th" after it, so you'll want to add something like \w{2} so that it would be able to match "th", "st", "nd", and "rd". Also, the \w? part matches only zero or one word characters, so to match an entire month name like "May" you want something like \w+

After making these changes, I got:

2 0

replied on June 17, 2016

Excellent, thank you! I completely missed the th and wouldn't have thought to use what you have here. Thanks for all the tips; it works!

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked June 17, 2016
Updated June 17, 2016
100 views