=TEXTBETWEEN("(123) 456 - 7890", "(", ")") -> "123" =TEXTBETWEEN("123-45-6789", "(", ")") -> 123
DEFINE( TEXTBETWEEN, LAMBDA( source_text, first_boundary, second_boundary, LET( text_after_first_boundary, RIGHT( source_text, DIFFERENCE( LEN(source_text), DECREMENT( SUM( FIND( first_boundary, source_text), LEN(first_boundary))))), LEFT( text_after_first_boundary, DECREMENT( FIND( second_boundary, text_after_first_boundary))))))
Help us optimize this function