Forum Discussion

Sameer_Bhide's avatar
Sameer_Bhide
Iron Contributor
Aug 01, 2021
Solved

LAMDA to find last instance of a search string within another string

Can some one help covert the below to a lambda function using recursion

I am aware that this is possible using SUBSTITUTE - I was just wondering how to get LAMDBA to exit on Error when it is used recursively

 

Cheers Sam

Formulas and Functions

4 Replies

    • Sameer_Bhide's avatar
      Sameer_Bhide
      Iron Contributor
      Aug 02, 2021

      tboulden 

      Oh Wow !!!  Thanks - I was struggling with this problem for quite some time and your solution is going to take most part of today for me to figure out.


      Also a great way of showing now the new Lambda helper functions (SCAN in this case) leads to a more elegant solution


      Thanks once again for your effort.

      Cheers
      Sam

      • tboulden's avatar
        tboulden
        Iron Contributor
        Aug 02, 2021

        Sameer_Bhide  It occurred to me later that the new ISOMITTED function could make this inner-loop structure unnecessary; had used it so that outer function only needed two parameters and the inner function's array argument wasn't needed to be a blank parameter.

         

         

Resources