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 re...
Formulas and Functions
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.

 

 

  • Sameer_Bhide's avatar
    Sameer_Bhide
    Iron Contributor
    Sep 28, 2021

    tboulden 

     

    I also realized that the same output can be achieved without iteration as below

    FINDALL

    =LAMBDA(txt,dl,
    LET(
    vPos,SEQUENCE(LEN(txt)),
    vChars,MID(txt,vPos,1),
    result,FILTER(vPos,vChars=dl),
    result))

Resources