- Data Type
- Operators
- Mathematical Functions
- String Functions
- Date/Time Functions
- Sequence Functions
- Table Sequence Functions
- Loop Functions
- Functions for Associative Operations
- File-handling Functions
- Database Functions
- Cursor Functions
- Statements
- System- & interface-related Functions
- Cluster Computing Functions
- Chart-plotting Functions
- External Library Functions
- Composite-Table-Related Functions
- Remote-service-related functions
- Simple SQL
-
Functions
- #c
- $(d)dql...
- $(db)sql;…
- ${macroExp}
- =expression
- >statement
- [a:b]
- @
- @x:…
- A()
- A.( x,… )
- [a 1 ,…a n ]
- abs()
- acos()
- acosh()
- age()
- align()
- ali_open()
- ali_close()
- ali_query()
- alter()
- and()
- append()
- argpost
- array()
- asc ()
- asin()
- asinh()
- atan()
- atanh()
- attach()
- avg()
- base64 ()
- between ()
- bi()
- bits()
- bit1( x )
- bit1( x,y )
- blob()
- bool ()
- break {a}
- C
- Cr()
- calc()
- call()
- call path/spl( … )
- calls path/spl( … )
- callx()
- cand()
- canvas()
- case()
- ceil()
- cellname()
- ch.()
- channel()
- char()
- chardetect()
- charencode()
- chi_p()
- chi2inv()
- chn()
- clear
- clipboard()
- close()
- cmp()
- cor()
- comabs()
- comangle()
- combin()
- comconj()
- comexp()
- comimage()
- commit()
- compair()
- complex()
- comreal()
- comsign()
- comstr()
- comunwrap()
- concat()
- conj()
- connect()
- contain()
- corskew()
- cos()
- cosh()
- count()
- cov()
- covm()
- create()
- cs.()
- cum ()
- cursor()
- date()
- datederive()
- dateinterval()
- datetime()
- day()
- days()
- decimal()
- delete()
- deq()
- derive()
- det()
- diff()
- digits()
- directory()
- dis()
- dism()
- dql()
- dup()
- dynadb._close()
- dynadb.execute()
- dyna_open()
- dynadb._query()
- dynadb.table()
- E()
- E()
- elapse()
- elasticnet()
- end s
- enum()
- env()
- eq()
- error()
- eval()
- es_close()
- es_delete ()
- es_export ()
- es_head ()
- es_open ()
- es_get ()
- es_post ()
- es_put ()
- exec()
- execute()
- exists()
- exp()
- export()
- eye()
- f@o(…)
- Faccrint()
- Faccrintm()
- fact()
- false
- Fcoupcd()
- Fcoups()
- Fdb()
- Fddb()
- Fdisc()
- Fduration()
- fetch()
- field()
- file()
- filename()
- fill()
- find()
- Fintrate()
- finv()
- Firr()
- fisher_p ()
- fjoin()
- float()
- floor()
- Fmirr()
- fname()
- fno()
- Fnper()
- Fnpv()
- for
- fork
- format()
- Fpmt()
- Fprice()
- Frate()
- Freceived()
- freq ()
- Fsln()
- Fsyd()
- ftp_cd()
- ftp_open()
- ftp_close()
- ftp_dir()
- ftp_get()
- ftp_mget()
- ftp_mput()
- ftp_put()
- func()
- Fv()
- Fvdb()
- Fyield()
- get()
- gcd()
- goto C
- group()
- groupi()
- groupn()
- groups()
- groupx()
- hash()
- hbase_close()
- hbase_cmp()
- hbase_filter()
- hbase_filterlist()
- hbase_get()
- hbase_open()
- hbase_rest()
- hbase_scan()
- hdfs_open()
- hdfs_close()
- hdfs_dir()
- hdfs_download()
- hdfs_exists()
- hdfs_file()
- hdfs_upload()
- hdfs_write()
- hive_open()
- hive_close()
- hive_cursor()
- hive_execute ()
- hive_query()
- hosts()
- hour ()
- httpfile()
- I()
- i()
- icursor()
- icount()
- id()
- if
- if()
- ifa()
- ifdate()
- ifind()
- ifn()
- ifnumber()
- ifpure()
- ifr()
- ifstring()
- ift()
- iftime()
- ifv()
- ifx_close()
- ifx_conn()
- ifx_cursor()
- ifx_listfrag()
- ifx_savefrag()
- ifx_setfrag()
- ifx_takefrag()
- import()
- impute()
- index()
- inf()
- influx_close()
- influx_insert()
- influx_open()
- influx_query()
- influx2_close()
- influx2_delete()
- influx2_open()
- influx2_query()
- influx2_rest()
- insert()
- int()
- interval()
- inv()
- inverse()
- invoke()
- isalpha()
- isdigit()
- isect()
- iselect()
- islower()
- isolate()
- isupper()
- iterate()
- j()
- join()
- joinx()
- json()
- jvm()
- k()
- kafka_close()
- kafka_commit()
- kafka_offset()
- kafka_open()
- kafka_poll()
- kafka_send()
- key()
- keys()
- kmeans()
- lasso()
- lcm()
- left()
- len()
- lg()
- like()
- linefit()
- lineplan()
- ln()
- load()
- lock()
- long()
- lower()
- m()
- mae()
- max()
- maxp()
- mcumsum()
- mcursor()
- md5()
- median()
- memory()
- merge()
- mfind()
- mi()
- mid()
- millisecond()
- min()
- minp()
- minute()
- mmean()
- mnorm()
- mode()
- modify()
- mongo_close ()
- mongo_open()
- mongo_shell()
- month()
- movefile()
- mul()
- mse()
- mstd()
- msum()
- mvp()
- n.f( x )
- name()
- new()
- news()
- next{a}
- nodes()
- norm()
- norminv()
- not()
- now()
- ntile ()
- null
- number()
- numnorm()
- nvl()
- o()
- olap_close()
- olap_open()
- olap_query()
- ones()
- open()
- or()
- output()
- p()
- pad()
- parse()
- paste()
- pca()
- pdate ()
- pearson()
- penum()
- periods()
- permut()
- pfind()
- pi()
- pivot()
- pjoin()
- pls()
- pmax()
- pmin()
- polyfit()
- pos()
- power()
- prior()
- proc()
- product()
- property()
- pseg()
- pselect()
- pseudo()
- psort()
- ptop()
- push()
- Qconnect()
- Qdirectory()
- Qenv()
- Qfile()
- Qload()
- Qlock()
- Qmove()
- query()
- r.( x )
- r.F
- r.F=x
- r2dbc_close()
- r2dbc_exec()
- r2dbc_open()
- r2dbc_query()
- rand()
- rands()
- range()
- rank()
- ranki()
- rankm()
- ranks()
- read()
- record()
- redis_close()
- redis_command()
- redis_open()
- regex()
- register()
- remainder()
- rename()
- replace()
- report_config()
- report_exportDoc()
- report_exportHtml()
- report_exportPdf()
- report_exportXls()
- report_open()
- report_run()
- reset()
- result
- return xi
- rgb()
- ridge()
- right()
- rollback()
- round()
- run()
- rvs()
- s3_ bucket ()
- s3_ close ()
- s3_ copy ()
- s3_ file ()
- s3_ list ()
- s3_ open ()
- sap_client()
- sap_close()
- sap_cursor ()
- sap_execute ()
- sap_getparam ()
- sap_table ()
- savepoint()
- sbs()
- se()
- second()
- segp()
- select()
- seq()
- sert()
- setenum()
- sf_close()
- sf_open()
- sf_query()
- sf_wsdlclose()
- sf_wsdlopen()
- sf_wsdlquery()
- sf_wsdlview()
- sg()
- shift()
- sign()
- sin()
- sinh()
- size()
- skew ()
- skip()
- sleep()
- smooth()
- sort()
- sortx()
- spark_open()
- spark_close()
- spark_cursor()
- spark_query()
- spark_read()
- spearman()
- split()
- splserver()
- sqlparse()
- sqltranslate()
- substr ()
- stax_close ()
- stax_open()
- stax_cursor()
- stax_query ()
- sqrt()
- step()
- string()
- structure
- sum()
- svm()
- swap()
- switch()
- syncfile( hs,p )
- system()
- T()
- tarcorskew()
- tan()
- tanh()
- time()
- tinv()
- to()
- top()
- total()
- transpose()
- trim()
- true
- try
- ttest_p()
- union()
- update()
- upper()
- urlencode()
- uuid()
- v()
- var()
- web_crawl()
- webhdfs()
- webhdfs_file()
- words()
- workday()
- workdays()
- write()
- ws_call()
- ws_client()
- xjoin()
- xjoinx()
- xlscell()
- xlsclose()
- xlsexport()
- xlsimport()
- xlsopen()
- xlswrite()
- xml()
- xor()
- xunion()
- year()
- ym_build_model()
- ym_close()
- ym_env()
- ym_exec()
- ym_importance()
- ym_json()
- ym_load_pcf()
- ym_model()
- ym_performance()
- ym_predict()
- ym_present()
- ym_result()
- ym_save_pcf()
- ym_setparam()
- ym_server_quit()
- ym_statistics()
- ym_target()
- zeros()
- zip()
- zip_add()
- zip_close ()
- zip_compress()
- zip_del()
- zip_encrypt()
- zip_extract()
- zip_open()
- Intersection of sequences
- Comparison operation
- Hexadecimal long integer
- Modulus
- Concatenation of sequences
- Arithmetic operations
- Compound assignment
- String
- String concatenation
- Alignment arithmetic operations
- Difference between sequences
- Union of sequences
- Multiplication of sequences
- Table sequence constant
- Record constant
- The writing rules for expression x in loop functions
- Batch Computation
- Identifier
- Opposite Number
- Empty Sequence
- Assignment
- Value Computation and Assignment
- Escape Character
- Logical Operations
- Long Integer
- Cell type
- Code block type
- Chart Elements
String
Description:
Define a string constant.
Syntax:
"string" or $[string]
Note:
An expression must be double quoted in use. But the quotation marks are not required if the string constants are defined directly.
The macro in "string" will not be replaced. When copying/pasting/inserting/deleting the row, the cell referenced by "string" will not change automatically.
The macro in $[string] will be replaced. When copying/pasting/inserting/deleting the row, the cell referenced by $[string] will change automatically.
The double quotation marks in $[string] do not need an escape character; while the double quotation marks in "string" needs one.
Parameter:
|
string |
Contents of the string, which can be any character. |
Return value:
String constant
Example:
"asd"
$[asd]
The the cell referenced by the string enclosed in $[] will change automatically when copying/pasting/inserting/deleting a row,but the one referenced by the string enclosed in "" will not change automatically in the same situation.
The macro in $[] will be replaced automatically, while macro in "" will not.
|
"${arg1}abc" |
"${arg1}abc " |
|
$[${arg1}abc] |
"Tomabc", (Suppose the value of arg1 is "Tom") |
The double quotation marks in $[] do not need to be escaped; while the escaping of double quotation marks in "" is needed.
$[a"s]
"a\"s"
Related function: