User Profile
Sameer_Bhide
Iron Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: LAMDA to find last instance of a search string within another string
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))1.2KViews0likes0CommentsRe: LAMDA to find last instance of a search string within another string
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 Sam1.4KViews1like2CommentsLAMDA 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 SamSolved1.4KViews0likes4Comments