函数速查¶
- 1. 数值函数
- 2. 比较函数
- 3. 逻辑函数
- 4. 位运算
- 5. 三角函数
- 6. 随机函数
- 7. 字符串函数
- 7.1. AllButFirst
- 7.2. AllButLast
- 7.3. AlphaBefore
- 7.4. CharCommon
- 7.5. Count_SubString
- 7.6. DefaultToUTF8
- 7.7. EndString
- 7.8. EndsWith
- 7.9. HasChars
- 7.10. HasEndString
- 7.11. HasMidString
- 7.12. HasStartString
- 7.13. HasSubString
- 7.14. HasSubStringsAND
- 7.15. HasSubStringsOR
- 7.16. IndexOf
- 7.17. InsertString
- 7.18. InsertStringByWidth
- 7.19. IsMatch
- 7.20. JoinItems
- 7.21. JoinItems2
- 7.22. JsonListItemValues
- 7.23. JsonObjectValue
- 7.24. JsonValue
- 7.25. LastIndexOf
- 7.26. LCS
- 7.27. LeftStr
- 7.28. Length
- 7.29. LengthB
- 7.30. like
- 7.31. like escape
- 7.32. Lower
- 7.33. ltrim
- 7.34. Match
- 7.35. MatchDate
- 7.36. Matches
- 7.37. MatchGroup
- 7.38. MatchGroups
- 7.39. MatchTime
- 7.40. NewLine
- 7.41. not like
- 7.42. Padc
- 7.43. Padl
- 7.44. Padr
- 7.45. Proper
- 7.46. RemoveBetweenS
- 7.47. RemoveBreakAndSpace
- 7.48. RemoveChars
- 7.49. RemoveHiddenCharacters
- 7.50. RemoveLineBreak
- 7.51. RemoveMinLine
- 7.52. RemoveRedundantSpace
- 7.53. RemoveRept
- 7.54. RemoveStrings
- 7.55. Replace
- 7.56. ReplaceBetweenS
- 7.57. ReplaceLineBreak
- 7.58. ReplaceReg
- 7.59. Rept
- 7.60. Reverse
- 7.61. RightStr
- 7.62. rtrim
- 7.63. SimpleString
- 7.64. SpaceNormal
- 7.65. SplitString
- 7.66. SplitText
- 7.67. sscanf
- 7.68. StartString
- 7.69. StartsWith
- 7.70. StartsWithOR
- 7.71. StrFilter
- 7.72. StringCompare
- 7.73. SubStr
- 7.74. SubStrB
- 7.75. SubStrBetween
- 7.76. SubStrBetweenL
- 7.77. SubStrBetweenS
- 7.78. ToChineseMoney
- 7.79. ToDBC
- 7.80. ToPinyin
- 7.81. ToPinyinFirstLetter
- 7.82. ToSBC
- 7.83. trim
- 7.84. Upper
- 7.85. UrlDecode
- 7.86. UrlEncode
- 7.87. WordDF
- 7.88. ||
- 8. 字符编码
- 9. 日期与时间
- 9.1. CENCToDate
- 9.2. CreateDate
- 9.3. CreateDatetime
- 9.4. CreateTime
- 9.5. CreateTimeSpan
- 9.6. DateAfter
- 9.7. DateBefore
- 9.8. DateDiff
- 9.9. DateTime2
- 9.10. DateTime3
- 9.11. DatetimeEqual
- 9.12. From_UnixTime
- 9.13. JulianToDate
- 9.14. MondayByWeekNo
- 9.15. Now
- 9.16. TimeAfter
- 9.17. TimeBefore
- 9.18. To_UnixTime
- 9.19. ToCENCDate
- 9.20. ToChineseCalendar
- 9.21. ToDatetime
- 9.22. ToJulianDate
- 9.23. ToOAdate
- 10. 列表函数
- 10.1. CountEqual
- 10.2. CountGreaterThan
- 10.3. CountLessThan
- 10.4. CountNotEqual
- 10.5. CountNulls
- 10.6. CreateSequence
- 10.7. FirstGreaterThan
- 10.8. FirstIndex
- 10.9. FirstLessThan
- 10.10. FirstNonNull
- 10.11. FirstNonNullIndex
- 10.12. FirstOne
- 10.13. ItemsCountBetween
- 10.14. ItemsCountGreaterThan
- 10.15. ItemsCountLessThan
- 10.16. LastGreaterThan
- 10.17. LastIndex
- 10.18. LastLessThan
- 10.19. LastNonNull
- 10.20. LastNonNullIndex
- 10.21. LastOne
- 10.22. ListCount
- 10.23. ListDistinct
- 10.24. ListExcept
- 10.25. ListIntersect
- 10.26. ListItemsCount
- 10.27. ListJoinToString
- 10.28. ListSort
- 10.29. ListUnion
- 10.30. max_index
- 10.31. max_n
- 10.32. maxlength_n
- 10.33. member
- 10.34. min_index
- 10.35. min_n
- 10.36. minlength_n
- 10.37. RemoveMembers
- 10.38. StringListSimplify
- 10.39. SubList
- 10.40. SubListIndexs
- 10.41. ToStringlist
- 10.42. ToStringlistFixedWidth
- 10.43. ValueAt
- 11. 转换函数
- 11.1. Base642Byte
- 11.2. Base642String
- 11.3. Byte2Base64
- 11.4. Compress
- 11.5. Data2Base64
- 11.6. Decompress
- 11.7. Decrypt
- 11.8. Encrypt
- 11.9. F
- 11.10. Format
- 11.11. GetNumber
- 11.12. GetNumbers
- 11.13. HexDecode
- 11.14. HexEncode
- 11.15. String2Base64
- 11.16. ToBool
- 11.17. ToDoublelist
- 11.18. ToFieldname
- 11.19. ToInteger
- 11.20. ToIntegerlist
- 11.21. ToList
- 11.22. ToReal
- 11.23. ToString
- 12. 信息函数
- 13. 颜色函数
- 14. 统计
- 14.1. @AutoCorrelation
- 14.2. @avg
- 14.3. @count
- 14.4. @CountIF
- 14.5. @CovarianceP
- 14.6. @CovarianceS
- 14.7. @First
- 14.8. @group_concat
- 14.9. @InformationEntropy
- 14.10. @Kurtosis
- 14.11. @Last
- 14.12. @ListAgg
- 14.13. @LongestSubstring
- 14.14. @lower_quartile
- 14.15. @max
- 14.16. @MaxIF
- 14.17. @MaxIFByNumber
- 14.18. @mean
- 14.19. @median
- 14.20. @min
- 14.21. @MinIF
- 14.22. @MinIFByNumber
- 14.23. @mode
- 14.24. @Quartile
- 14.25. @Skew
- 14.26. @SkewP
- 14.27. @StdDevP
- 14.28. @StdDevS
- 14.29. @stdev
- 14.30. @sum
- 14.31. @SumIF
- 14.32. @total
- 14.33. @upper_quartile
- 14.34. @variance
- 14.35. @VarP
- 14.36. @VarS
- 15. 地理信息
- 15.1. Area
- 15.2. Beijing54_3To6
- 15.3. Beijing54_6To3
- 15.4. Beijing54toLL
- 15.5. Beijing54ToXian80
- 15.6. Bmap2Gmap
- 15.7. Bmap2GmapOnline
- 15.8. Buffer
- 15.9. Centroid
- 15.10. CentroidDistance
- 15.11. CombineTypeDifference
- 15.12. CombineTypeIntersection
- 15.13. CombineTypeSymmetricalDifference
- 15.14. CombineTypeUnion
- 15.15. DegreesToDigital
- 15.16. DegreesToDigital2
- 15.17. DigitalToDegrees
- 15.18. DistanceByDegree
- 15.19. DistanceByMeter
- 15.20. EndPoint
- 15.21. Extent2Polygon
- 15.22. Extent2Polyline
- 15.23. FeatureInPolygon
- 15.24. FirstPoint
- 15.25. Generalize
- 15.26. GetAddress
- 15.27. GetCoordinate
- 15.28. HDGIS2Polygon
- 15.29. LLToBeijing54_3
- 15.30. LLToBeijing54_6
- 15.31. LLToXian80_3
- 15.32. LLToXian80_6
- 15.33. MapIdNew
- 15.34. MapIdNew2Old
- 15.35. MapIdOld
- 15.36. MapIdOld2New
- 15.37. PointInPolygon
- 15.38. PointInPolygon2
- 15.39. PointX
- 15.40. PointY
- 15.41. PolygonArea
- 15.42. ProjectionTransformation
- 15.43. ShapeContain
- 15.44. ShapeDisjoint
- 15.45. ShapeExtent
- 15.46. ShapeIntersect
- 15.47. ShapeLength
- 15.48. ShapeNumParts
- 15.49. ShapeOverlap
- 15.50. ShapePointCount
- 15.51. ShapeTouch
- 15.52. ShapeType
- 15.53. ShapeWithIn
- 15.54. Smooth
- 15.55. ToGeoMap
- 15.56. ToLine
- 15.57. ToLine2
- 15.58. ToPoint
- 15.59. WGS84ToBmap
- 15.60. WGS84ToBmapOnline
- 15.61. Xian80ToBeijing54
- 15.62. Xian80toLL
- 15.63. Xian8_3To6
- 15.64. Xian8_6To3
- 16. 空间统计
- 17. HTML函数
- 17.1. GetHtmlCellValue
- 17.2. GetHtmlColumnID
- 17.3. GetHtmlRowID
- 17.4. HtmlA
- 17.5. HtmlBr
- 17.6. HtmlContentCompress
- 17.7. HtmlContentCompressEx
- 17.8. HtmlContext
- 17.9. HtmlDecode
- 17.10. HtmlDownload
- 17.11. HtmlExtract
- 17.12. HtmlImg
- 17.13. HtmlImgBase64
- 17.14. HtmlSpace
- 17.15. HtmlTagsCount
- 17.16. HttpGet
- 17.17. HttpPost
- 17.18. URLCapture
- 18. 文件相关
- 18.1. Base642String
- 18.2. Byte2String
- 18.3. CRC32
- 18.4. FileStream
- 18.5. GetDirectoryName
- 18.6. GetExtension
- 18.7. GetFileEncodeType
- 18.8. GetFileName
- 18.9. GetFileNameWithoutExtension
- 18.10. MD5
- 18.11. RemoveInvalidFileNameChars
- 18.12. RIPEMD160
- 18.13. SHA1
- 18.14. SHA256
- 18.15. SHA384
- 18.16. SHA512
- 18.17. String2Base64
- 18.18. String2Byte
- 19. 批处理命令
- 20. 图像处理
- 21. 数据缓存
- 22. 网络相关
- 23. 定时运行
- 24. 油田专用
- 25. 其它