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

[Sameer_Bhide]

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

[#2 · Accepted solution]

@Sameer_Bhide   Please see attached, or transcribe from below snapshot.

[#3]

@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

[#4]

@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.

[#5]

@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))