0

Is there a way to find a word between delimiters in Microsoft Query? For example find "this", which is the 3rd word between underscores in "what_could_this_be".

For reference, in MySQL I would have done it by SUBSTRING_INDEX(SUBSTRING_INDEX(field, ' ', 3), ' ', -1).

LWC
  • 1,084
  • 1
  • 10
  • 28
  • For those who might not know MS-Query, you might want to give a link to the available string functions. – Tim Biegeleisen May 20 '18 at 09:27
  • Well, there's no explicit documentation, but it seems to follow [Access (in this case text) Expressions](https://support.office.com/en-us/article/Expressions-684295d0-97c2-443c-8e0a-8c6b635bec56#ID0EAABAAA=Text). – LWC May 20 '18 at 17:23

0 Answers0