AFinScript functions:
GETTRANSLATION GETDATAODBC
  GETDATAJSON
VAL2TEXT / SŁOWNIE GETDATAXML
KURS_NBP GETDATATEXT
URLENCODE, URLDECODE GETDATAGSHEETS
IsUserAnAdmin GETEXCELVALUE
INFO_ABOUT_EXCEL_OBJECTS GETHTMLTABLE
INFO_ABOUT_AFINSCRIPT_VARIABLES GETWORDTEXT --> GETDATATEXT
   
Italic font = a function in process yet, it will be described in the future.  
   
Function specification  
Function example(s) Function value
   
GETTRANSLATION(lsText; lsLangFrom; lsLangTo)  
GETTRANSLATION("I like AfinScript";"EN";"PL") Lubię AfinScript....
   
   
VAL2STR(ldValue; lsLanguage; lsCurrency; lsCentsString; lbThreeLetters)  
SŁOWNIE(ldValue; lsLanguage; lsCurrency; lsCentsString; lbThreeLetters)  
VAL2STR(1234,56;"pl") Jeden tysiąc dwieście trzydzieści cztery złote 56/100
VAL2STR(1234,56;"en";"EUR") One thousand two hundred thirty four EUR 56/100
VAL2STR(1234,56;"en";"EUR";"cts") One thousand two hundred thirty four EUR 56cts
VAL2STR(1234,56;"en";;;1) ONE#TWO#THR#FOU#56/100
   
   
KURS_NBP(Waluta; Data) (Function in Polish, because it is specified to Polish National Bank (NBP))
KURS_NBP("EUR"; "2017-01-10") 4,3735
   
   
GETEXCELVALUE(lsWbkName, lsShtName, lsRngAddr) (This function can be used in a single-cell- or table- form.)
GETEXCELVALUE("C:\AnyPath\ExcelWbk";"Sheet1";"A1:B10") (The content of specified range)
   
   
GETDATAODBC(ConnStr; Sql) (This function can be used in a single-cell- or table- form.)
GETDATAODBC("DSN=Excel files; DBQ=C:\AnyPath\MyWorkbook.xlsx"; "SELECT COUNT(*) FROM [Sheet1$]") 5
GETDATAODBC("C:\AnyPath\MyAccessDB.accdb"; "SELECT ContactName FROM [tblUsefulApps] WHERE Company='AFIN' ") Wojciech
   
   
GETDATAJSON(myUrl; myReturn)  
GETDATAJSON("http://api.nbp.pl/api/exchangerates/rates/c/usd/2016-04-04/?format=json") {"table":"C","currency":"dolar amerykański","code":"USD","rates":[{"no":"064/C/NBP/2016","effectiveDate":"2016-04-04","bid":3.6929,"ask":3.7675}]}
GETDATAJSON("http://api.nbp.pl/api/exchangerates/rates/c/usd/2016-04-04/?format=json";"rates[0].bid") 3,6929
   
   
GETDATAXML(myUrl; myXPath) (This function can be used in a single-cell- or table- form.)
GETDATAXML("http://api.nbp.pl/api/exchangerates/rates/c/usd/2016-04-04/?format=xml") <?xml version="1.0" encoding="utf-8"?><ExchangeRatesSeries xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Table>C</Table><Currency>dolar amerykański</Currency><Code>USD</Code><Rates><Rate><No>064/C/NBP/2016</No><EffectiveDate>2016-04-04</EffectiveDate><Bid>3.6929</Bid><Ask>3.7675</Ask></Rate></Rates></ExchangeRatesSeries>
GETDATAXML("http://api.nbp.pl/api/exchangerates/rates/c/usd/2016-04-04/?format=xml";"//Rate/Bid") 3.6929
GETDATAXML("http://www.afin.net/samples/Data/ODBC/SalesInHTML/HTML1.html";"//html/body/table/tr[0]/td[1]/a[1]") url2-1
   
   
GETDATATEXT(lsTextSource; lsPatternToRemoveBefore;
lsPatternToMatch; lsPatternToRemoveAfter)
(This function can be used in a single-cell- or table- form.
If a reaturn value is a table value AND ITS SIZE IS GREATER then a caller table (table formula or single cell formula) it returns values like "{value} #Tbl!". This is not the error.)
GETDATATEXT("http://www.afin.net/samples/Data/ODBC/SalesInHTML/HTML1.html";"";">[a-zA-Z0-9]*[^<>]<") (table function - table value)
{">url1<";">url2<";">url3<"}
GETDATATEXT("http://www.afin.net/samples/Data/ODBC/SalesInHTML/Faktura.htm";"";">.*A.*X<") (table function - table value)
{">AREX<";">JARIMPEX<";">HANIMPEX<";">DAREX<";">FRANEX<";">ANEX<";">SIANEX<"}
GETDATATEXT("http://www.afin.net/samples/Data/ODBC/SalesInHTML/Faktura.htm";"";">\d\d\d\d-\d\d-\d\d<") (table function - table value)
{">2004-01-03<";">2004-01-24<";">2004-02-03<";">2004-02-24<";">2004-03-03<";">2004-03-24<";">2004-04-03<";">2004-04-24<";">2004-05-03<";">2004-05-24<";">2004-06-03<";">2004-06-24<";">2004-07-03<";">2004-07-24<";">2004-08-04<";">2004-09-04<";">2004-09-25<";">2004-10-04<";">2004-10-25<";">2004-11-04<";">2004-11-25<";">2004-12-04<";">2005-01-05<";">2005-01-26<";">2005-02-05<";">2005-02-26<";">2005-03-05<";">2005-03-26<";">2005-04-05<";">2005-04-26<";">2005-06-05<";">2005-07-05<";">2005-08-05<";">2005-08-26<"}
450,00 zł 450
   
Frequently used HTML tags to remove from HTML document:  
HTML5 <!(.|\s)*?>
HTML tags </?[a-z][a-z0-9]*[^<>]*>
HTML comments <!--(.|\s)*?-->
HTML script tags <script.*?</script>
HTML stylesheets <style.*?</style>
all above together: <!(.|\s)*?> </?[a-z][a-z0-9]*[^<>]*> <!--(.|\s)*?--> <script.*?</script> <style.*?</style>
Specified HTML tag <td> <[^<>]*>
   
   
GETDATAGSHEETS("GoogleSheetId";"SheetName";"RangeAddress") (This function can be used in a single-cell- or table- form.)
{=GETDATAGSHEETS("1CXy8JGFeREFRKE9t9WiDn82xtXh32UxagJcL4RxRQ50";"Sheet1";"A1:C4")} (table function - table value) {"I can read"\"from"\2;"Google"\"Sheets!!!"}
GETDATAGSHEETS("1CXy8JGFeREFRKE9t9WiDn82xtXh32UxagJcL4RxRQ50";"Sheet1";"D5") 5
   
   
GETHTMLTABLE(lsUrl; liTableNo; liMode; lsPatternToRemoveAfter; li RowNo; liColno) (This function can be used in a single-cell- or table- form.)
{=GETHTMLTABLE("http://www.bankier.pl/gielda";2)}  
   
Arguments:  
liMode=1 (default) : MSXML2.XMLHTTP library, own AfinScript HTML table parser (the fastest)  
liMode=2 : Using Dataset object  
liMode=3 : Internet Explorer library, IE's HTML table parser (standard html objects) (problems)  
liMode=4 : Standard HTML table parser - (in process)  
lsPatternToRemove Default Regex pattern removed from every table cell: "<td> <[^<>]*> &nbsp;". To avoid using this default say "!" as a first character.
Other / Old :  
GETWORDTEXT(lsWordFileName)  
Removed. You can use this functionality in the GETDATATEXT() function (the same usage). (The Word document text content)