search

KiaraGrouwstra / pquery

A collection of functions for use in Excel Power Query
MIT License
234 stars 76 forks source link

Update Text.ContainsAny.m #5

Closed IvanBond closed 9 years ago

IvanBond commented 9 years ago

Assume that needles = {"A".."Z"}, List.Count gives 26. However loop on i starts from 0, while <= count. Case "=count" will take 27th element, which doesn't exist in needles.

KiaraGrouwstra commented 9 years ago

My bad -- thanks! :)

KiaraGrouwstra commented 9 years ago

Thanks for reminding me I needed to update this as well. Added a bit more now, among which readme links to my current batch import approach by VBA.

IvanBond commented 9 years ago

Thanks to you :) It is me stealing ideas, not you :) New pack of functions even more powerful than I expected!

KiaraGrouwstra commented 9 years ago

Glad you like it! :)

On Fri, May 22, 2015 at 2:12 PM, Ivan Bondarenko notifications@github.com wrote:

Thanks to you :) It is me stealing ideas, not you :) New pack of functions even more powerful than I expected!

— Reply to this email directly or view it on GitHub https://github.com/tycho01/pquery/pull/5#issuecomment-104533175.