1. esProc’s function options
Many functions in esProc can use function options with which the same function can have different work patterns. The basic format of function options is f@o(…) in which o is f function’s option. For example:
A
B
1
2004-5-5
2014-7-7
2
=interval(A1,B1)
3
=interval@y(A1...
2015-02-18 895 0
0
To make data analysis, first you need to load the original data. The data used most frequently comes from the text files or the databases. In esProc, you can load data from the text files or the databases easily and quickly.
1. Text file data
esProc can loaddata from a text file as a table sequence. For example, the te...
2015-02-11 938 0
0
esProc provides a large number of functions, many of which use many parameters. In order to clearly judge the positions of these parameters and make writing and reading easier, esProc is specially equipped with multilayer separators of function parameters.
1. Separators of function parameters
Colon (:), comma (,) and s...
2015-02-10 935 0
0
In esProc computing, we use constants frequently or sometimes store the data in the cellset directly. In this article, let’s learn the usage of constants in the esProc.
1. Directly using constant in the expressions
Constants can be directly used in the esProc expressions:
A
1
=64*32
2
=round(1.45*5.5)
3...
2014-11-13 798 0
0
esProc can be embedded into Java program. So the latter can call the cellset program written in esProc using a way of connection such as JDBC. The method of calling the esProc program is the same as that of calling the stored procedure. The following is a brief introduction to esProc JDBC.
1. Description of the j...
2014-11-12 967 0
0
1. Data types in esProc
In esProc, the following basic data types are available:
Integer
Any integer between -231 and 231-1, i.e. the value range is -2147483648~2147483647. The type conversion function int() can be used to convert other types of data into integer.
Long integer
-263~263-1, which is a value range bigger ...
2014-11-05 1094 0
0
1. Cell Copy and Paste
In esProc, you can press Ctrl+C and Ctrl+V to copy data or an expression in some cell and paste it on the target done. But unlike EXCEL, the copy and paste operations on the cell will not perform the adjust-paste on the expression automatically.
If you need to adjust the cell quoted by the expre...
2014-11-04 818 0
0
In esProc, cells are automatically classified into different types according to their values or the expressions they contain. In a cellset, each type of cell has its own appearance, which highlights the code in the cells.
1.Types of cells
1.1 Constant cell
A cell in which the cell string can be interpreted as the co...
2014-11-04 792 0
0
esProc is a tool for programmed data computing. It can execute various types of data analysis and structured data computing, as well as get access to the database freely and perform online data analysis.
1. Installation
You can download esProc installation package on the following official website: http://www.raqs...
2014-11-03 911 0
0