Forum Discussion
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...
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.
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))