Aug 01 2021 02:32 AM
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
Aug 01 2021 10:59 AM
SolutionAug 01 2021 10:43 PM
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
Aug 02 2021 10:47 AM
@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.
Sep 27 2021 08:40 PM
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))
Aug 01 2021 10:59 AM
Solution