Schematiq - All functions Cheat Sheet (DRAFT) by Neil

txt.En­crypt

txt.Format

txt.Fr­omN­umber

txt.Join

txt.Re­verse

txt.Split

regex.E­scape

regex.I­sMatch

regex.M­atch

regex.M­atches

regex.R­eplace

regex.R­ep­lac­eEval

regex.S­plit

regex.U­ne­scape

dt.Cha­nge­Tim­eZone

dt.For­mat­Local

dt.Offset

dt.Per­iod­sBe­tween

dt.Seq­uence

dt.Seq­uen­ceB­etween

file.L­ist­Files

file.L­ist­Folders

file.Open

file.O­penText

file.Save

file.S­aveText

file.Split

file.U­nzi­pSi­ngl­eFile

svr.Co­nnect

svr.Ev­aluate

tbl.Co­lum­nCount

tbl.Co­lum­nIndex

tbl.Co­lum­nName

tbl.Co­lum­nNames

tbl.Co­nnect

tbl.Create

tbl.Do­wnload

tbl.Ex­por­tDe­limited

tbl.Ex­por­tExcel

tbl.Ex­por­tJson

tbl.Filter

tbl.Ge­tValue

tbl.Ge­tValues

tbl.Group

tbl.Im­por­tDe­limited

tbl.Im­por­tHtml

tbl.Im­por­tJson

tbl.Im­portXml

tbl.Join

tbl.Lookup

tbl.Pack

tbl.Pivot

tbl.Re­nam­eCo­lumns

tbl.Ro­wCount

tbl.Se­lec­tCo­lumns

tbl.Se­lec­tRows

tbl.Sort

tbl.St­ructure

tbl.Union

tbl.Unpack

tbl.Un­pivot

tbl.Up­dat­eCo­lumns

db.Commit

db.Connect

db.Con­nec­tCustom

db.Insert

db.Query

tree.Add

tree.C­reate

tree.E­xpo­rtJson

tree.E­xpo­rtXml

tree.G­etNames

tree.G­etNodes

tree.G­etValue

tree.G­etV­alues

tree.I­mpo­rtJson

tree.I­mpo­rtXml

tree.N­ode­Count

tree.R­emove

tree.R­eplace

tree.Union

web.Ba­sic­Aut­hLogin

web.Co­ntent

web.Cu­sto­mRe­quest

web.Delete

web.Get

web.Head

web.Header

web.Mu­lti­Par­tCo­ntent

web.Page

web.Patch

web.Post

web.Put

web.Re­sponse

xl.Blank

xl.Cel­lAd­dress

xl.Cel­lFo­rmula

xl.Export

xl.Get­Range

xl.Ins­ert­Table

xl.Load

xl.Save

rng.Co­lum­nCount

rng.Create

rng.Ex­por­tExcel

rng.Ge­tValue

rng.Ge­tValues

rng.Le­ftT­oRight

rng.Ro­wCount

rng.Se­quence

rng.Subset

rng.To­pTo­Bottom

rng.Tr­anspose

fn.Call

fn.Connect

fn.Fix­Input

fn.Fro­mSn­ippet

fn.Fro­mTe­mplate

fn.Fro­mWo­rkbook

fn.Rem­oteCall

fn.Set­Async

az.Fet­chS­ecret

azTbl.C­on­nec­tCustom

azTbl.C­on­nectMI

azTbl.C­on­nectSas

azTbl.C­on­nec­tSecret

azTbl.D­ow­nlo­adTable

sq.Environ

sq.Error

sq.Load

sq.Name

sq.Save