摘要:OverviewGrammarFIND(find_text,within_text,start_num)Returns the first specified substring (find_text)[阅读全文:]

摘要:Extracted DataOverviewGrammarLEN(args)Returns the number of characters of a string.Parameter 1argsPar[阅读全文:]

摘要:OverviewGrammarCONCATENATE(text1,text2,...)Joins at least two strings into one.Parameter 1Text1,text2[阅读全文:]

摘要:Usage 1: Replacing Specified Content of a TextOverviewGrammarREPLACE(text,textorreplace,replacetext)R[阅读全文:]

摘要:OverviewGrammarINDEXOF(str1,index)Returns the character in str1 at the position specified by index.Pa[阅读全文:]

摘要:OverviewGrammarTODOUBLE(text)Converts a text to a Double object (a double-precision floating-point nu[阅读全文:]

摘要:OverviewGrammarRIGHT(text,num_chars)Returns the last or last several characters in the text, based on[阅读全文:]

摘要:OverviewGrammarUPPER(text)Converts all characters in a text to uppercase.Parameter 1TextText to be co[阅读全文:]

摘要:OverviewGrammarSPLIT(String1,String2 )Returns an array of character strings splited from String1 by t[阅读全文:]

摘要:OverviewGrammarREPEAT(text,number_times)Repeats a text a specified number of times.Parameter 1textTex[阅读全文:]

摘要:OverviewGrammarTOINTEGER(text)Converts a text to an Integer object.Parameter 1TextText to be converte[阅读全文:]

摘要:OverviewGrammarEXACT(text1,text2)Determines whether two text strings are identical. If they are exact[阅读全文:]

摘要:OverviewGrammarMID(text,start_num,num_chars)Returns a user-specified number of characters from a spec[阅读全文:]

摘要:Extracted DataUsage 1OverviewGrammarREGEXP(str,pattern)Determines whether a character string (specifi[阅读全文:]

摘要:OverviewGrammarSTARTWITH(str1,str2)Determining whether str1 starts with str2.Parameter 1str1Character[阅读全文:]

摘要:OverviewGrammarPROPER(text)Capitalizes the first letter and letters that follow any non-letter charac[阅读全文:]

摘要:OverviewGrammarCODE(text)Returns a numeric code for the first character in a text string. The returne[阅读全文:]

摘要:OverviewGrammarCHAR(number)Returns the character specified by a number, by which you can convert code[阅读全文:]

摘要:OverviewGrammarLOWER(text)Converts all characters in text to lowercase.Parameter 1textText to be conv[阅读全文:]

摘要:Overview GrammarTRIM(text)Returns the text with all leading and trailing spaces removed.Paramete[阅读全文:]

摘要:OverviewGrammarENDWITH(str1, str2)Determines whether str1 ends with str2.Parameter 1str1Character str[阅读全文:]

摘要:OverviewGrammarNUMTO (number, bool) or NUMTO (number)Returns number-converted Chinese texts.Parameter[阅读全文:]

摘要:OverviewGrammarLEFT(text, num_chars)Returns the first or first several characters in the text, based[阅读全文:]

摘要:OverviewGrammarSUBSTITUTE(text, old_text, new_text, instance_num)Substitutes new_text for old_text in[阅读全文:]

摘要:OverviewIn scenarios where frequent format conversion is required during data analysis, FineBI provid[阅读全文:]