Wednesday, November 22, 2017

yogi_Extract Row By Row Substring Using Query Function

Google Spreadsheet   Post  #2296

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-22-2017
question by: DaveGoogle
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/-GlmlC1qgaQ;context-place=topicsearchin/docs/authorid$3AAPn2wQc7O4EQsX1gkj1mKYiVqjACnXxOUJfDW9aP6REEoSb26rzIBkrBhpHOgIm3cS21f6-y3rVl%7Csort:date%7Cspell:false
How do I use substring / MID formula with Google Query?
Hi,

Below is my basic query.

=QUERY(Tracker,"select K,M,N,A,F")

This returns all the columns I need. However, I want to extract a substring of column M. Something like below:

=QUERY(Tracker,"select K,substring("M",2,7),N,A,F")

Can anyone advise the correct syntax?

Thanks

No comments:

Post a Comment