TEXTBEFORE
Returns the text that occurs before the start of given instance of a delimiter substring.
TEXTBEFORE( Text [; Delimiter [; Instance Number [; Match Mode [; Match End [; Kung Hindi Natagpuan ]]]]])
Text : ang orihinal na teksto.
Delimiter: (optional) the delimiter. Multiple delimiters can be supplied. If omitted or supplied as an empty string, then returns the error #N/A or the value expressed by If Not Found.
Instance Number: (optional) the instance of the delimiter before which to extract text. The default is 1. A negative number starts searching from the end. Value 0 returns the error #N/A
Mode ng Pagtutugma : (opsyonal) itinakda sa 1 para magsagawa ng case-insensitive na tugma. Ang default ay 0.
Pagtatapos ng Tugma : (opsyonal) itinakda sa 1 para ituring ang dulo ng text bilang delimiter. Ang default ay 0.
If Not Found: (optional) the value returned if no match is found. The default is #N/A.
Maaaring tanggalin ang alinman sa mga opsyonal na argumento. Ang isang opsyonal na argumento ay nangangailangan ng lahat ng naunang separator na naroroon.
=TEXTBEFORE("To be or not to be";" be";2;0;0;"@@@") returns the string "To be or not to", taking up to the second instance of the delimiter " be".
=TEXTBEFORE("To be or not to be";"tanong";1;0;0;"@@@") ibinabalik ang text na "@@@" dahil ang delimiter na "tanong" ay wala sa source text.
=TEXTBEFORE("To be or not to be";"question";1;0;1;"@@@") returns the text "To be or not to be" because the delimiter "question" is not in the source text and Match End is 1, which then returns everything before the end of text.
=TEXTBEFORE("To be or not to be";"question";-1;0;1;"@@@") returns the empty string "" because the delimiter "question" is not in the source text, Instance Number is negative (starts from the end) and Match End is 1, which prevents the function to return the error #N/A or the value defined in If Not Found.
COM.MICROSOFT.TEXTBEFORE
