2024年4月19日发(作者：)

NC60公式函数使用说明

NC应用集成开发部 马志强

本文档主要是对NC60中公式的基本使用进行简要说明，给出公式可以支持的参数类型

以及对应的返回值类型结果等信息，并对公式函数中的一些特殊情况加以说明。在类型返回

值表中没有提及的情况均视为非法参数条件，会抛出异常。

本文档中由于书写匆忙，若有错误之处，欢迎批评指正。

NC60公式函数使用说明 ........................................................................................................ 1

NC应用集成开发部 马志强 .................................................................................................. 1

1.

字符串函数 ....................................................................................................................... 6

1.1 charat(string,index) .......................................................................................................... 6

1.2 endswith(string, end) ....................................................................................................... 6

1.3 equalsIgnoreCase(string1, string2) .................................................................................. 7

1.4 indexOf(st1, st2) .............................................................................................................. 7

1.5 isEmpty(str) ..................................................................................................................... 8

1.6 lastIndexOf(st1, st2) ........................................................................................................ 8

1.7 left(st, index) ................................................................................................................... 8

1.8 leftStr(st,len,defaultStr) ................................................................................................... 9

1.9 length(st) .......................................................................................................................... 9

1.10 mid(String st, int start, int end) .................................................................................... 10

1.11 right(String st, int index) ............................................................................................. 10

1.12 rightStr(st,len,defaultStr) ............................................................................................. 11

1.13 startsWith(String st, String start) ................................................................................. 11

1.14 toLowerCase(String st) ................................................................................................ 12

1.15 toString(obj) ................................................................................................................ 12

1.16 toUpperCase(String st) ................................................................................................ 12

1.17 trimZero(value, [decimal]) .......................................................................................... 13

2.

数学函数 ......................................................................................................................... 14

2.1 abs(num) ........................................................................................................................ 14

2.2 acos(x) ........................................................................................................................... 14

2.3 add(num1,num2) ........................................................................................................... 15

2.4 asin(x) ............................................................................................................................ 15

2.5 atan(x) ............................................................................................................................ 15

2.6 cos(x) ............................................................................................................................. 16

2.7 div(num1,num2) ............................................................................................................ 16

2.8 exp(x)............................................................................................................................. 17

2.9 int(x) .............................................................................................................................. 17