Extract texts between and pair of the bellow characters.
( ) * [ ] { }
الحل الاول :
=MAP(B3:B7,LAMBDA(a,LET(st,FILTER(SEARCH({"(","[","{"},a),ISNUMBER(SEARCH({"(","[","{"},a))),en,FILTER(SEARCH({")","]","}"},a),ISNUMBER(SEARCH({")","]","}"},a))),MID(a,st+1,en-st-1))))
-------------------
الحل الثاني
=TEXTBEFORE(TEXTAFTER(B3:B7,{"(","[","{"}),{")","]","}"})
------------
الحل الثالث
=MAP(B3:B7,LAMBDA(a,TEXTBEFORE(TEXTAFTER(a,{"(","[","{"}),{")","]","}"})))
ليست هناك تعليقات:
إرسال تعليق