715 lines
12 KiB
Markdown
715 lines
12 KiB
Markdown
# 基础函数
|
||
|
||
这一页只负责函数定位：先按主题找到模块，再在页内搜索函数名。
|
||
|
||
## 使用方式
|
||
|
||
- 返回总目录：[catalog/index.md](index.md)
|
||
- 需要基础语法时回到 [../../syntax/index.md](../../syntax/index.md)
|
||
- 需要金融任务组织方式时回到 [../../finance/index.md](../../finance/index.md)
|
||
|
||
## 模块范围
|
||
|
||
- 说明：字符串、数组、日期时间、类型转换与常用基础能力
|
||
- 主题数：41
|
||
- 函数数：574
|
||
|
||
## 主题目录
|
||
|
||
### 数字
|
||
|
||
- `FloatN`
|
||
- `FloatToStrEx`
|
||
- `FormatFloatExt`
|
||
- `WebZero`
|
||
- `RoundTo5`
|
||
- `SimpleRoundTo2`
|
||
- `DivValue`
|
||
- `Dataisequal`
|
||
|
||
### 日期时间
|
||
|
||
- `ISO8601`
|
||
|
||
### 日期时间 / 常用日期时间函数
|
||
|
||
- `Time`
|
||
- `DecodeTime`
|
||
- `DayOfWeek`
|
||
- `EncodeTime`
|
||
- `Now`
|
||
- `DecodeDate`
|
||
- `Date`
|
||
- `TryEncodeDate`
|
||
- `TryEncodeTime`
|
||
- `DecodeDateFully`
|
||
- `EncodeDate`
|
||
- `TryStrToDate`
|
||
- `StrToDateTimeDef`
|
||
- `DateTimeToInternetStr`
|
||
- `IncAMonth`
|
||
- `StrToTime`
|
||
- `CurrentYear`
|
||
- `TryStrToTime`
|
||
- `StrToDate`
|
||
- `DateTimeGMTToHttpStr`
|
||
- `DateToStr`
|
||
- `StrToTimeDef`
|
||
- `DateTimeToStr`
|
||
- `DateTimeToString`
|
||
- `Strtodatetime2`
|
||
- `FormatDateTime`
|
||
- `DateTimeGMTToCookieStr`
|
||
- `StrToDateTime`
|
||
- `IsLeapYear`
|
||
- `GMTToLocalDateTime`
|
||
- `TimeToStr`
|
||
- `StrToDateDef`
|
||
- `TryStrToDateTime`
|
||
|
||
### 日期时间 / 简单转换函数
|
||
|
||
- `DateToInt`
|
||
- `IntToDate`
|
||
- `StrToDateExt`
|
||
- `ExcelIntToDate`
|
||
- `ExcelDateToInt`
|
||
- `FormatStrToDateTime2`
|
||
|
||
### 日期时间 / 普通日期函数
|
||
|
||
- `IsInLeapYear`
|
||
- `IsPM`
|
||
- `IsValidDate`
|
||
- `IsValidTime`
|
||
- `IsValidDateTime`
|
||
- `IsValidDateDay`
|
||
- `IsValidDateWeek`
|
||
- `IsValidDateMonthWeek`
|
||
- `WeeksInYear`
|
||
- `WeeksInAYear`
|
||
- `DaysInYear`
|
||
- `DaysInAYear`
|
||
- `DaysInMonth`
|
||
- `DaysInAMonth`
|
||
- `Today`
|
||
- `Yesterday`
|
||
- `Tomorrow`
|
||
- `IsToday`
|
||
- `IsSameDay`
|
||
|
||
### 日期时间 / 分解函数
|
||
|
||
- `DateOf`
|
||
- `TimeOf`
|
||
- `YearOf`
|
||
- `MonthOf`
|
||
- `DayOf`
|
||
- `HourOf`
|
||
- `MinuteOf`
|
||
- `SecondOf`
|
||
- `MilliSecondOf`
|
||
|
||
### 日期时间 / 起始结束函数
|
||
|
||
- `StartOfTheYear`
|
||
- `EndOfTheYear`
|
||
- `StartOfAYear`
|
||
- `EndOfAYear`
|
||
- `StartOfTheMonth`
|
||
- `EndOfTheMonth`
|
||
- `StartOfAMonth`
|
||
- `EndOfAMonth`
|
||
- `StartOfTheWeek`
|
||
- `EndOfTheWeek`
|
||
- `StartOfAWeek`
|
||
- `EndOfAWeek`
|
||
- `StartOfTheDay`
|
||
- `EndOfTheDay`
|
||
- `StartOfADay`
|
||
- `EndOfADay`
|
||
- `StartOfTheHalfYear`
|
||
- `StartOfTheQuarter`
|
||
- `EndOfTheQuarter`
|
||
- `EndOfTheHalfYear`
|
||
|
||
### 日期时间 / 关系函数
|
||
|
||
- `HourOfTheYear`
|
||
- `HourOfTheMonth`
|
||
- `MonthOfTheYear`
|
||
- `MilliSecondOfTheYear`
|
||
- `WeekOfTheYear`
|
||
- `WeekOfTheMonth`
|
||
- `MinuteOfTheYear`
|
||
- `SecondOfTheYear`
|
||
- `DayOfTheYear`
|
||
- `DayOfTheMonth`
|
||
- `SecondOfTheMinute`
|
||
- `HourOfTheWeek`
|
||
- `SecondOfTheMonth`
|
||
- `DayOfTheWeek`
|
||
- `MinuteOfTheDay`
|
||
- `MilliSecondOfTheSecond`
|
||
- `SecondOfTheWeek`
|
||
- `MinuteOfTheMonth`
|
||
- `MinuteOfTheHour`
|
||
- `MinuteOfTheWeek`
|
||
- `MilliSecondOfTheDay`
|
||
- `MilliSecondOfTheMonth`
|
||
- `HourOfTheDay`
|
||
- `MilliSecondOfTheHour`
|
||
- `SecondOfTheHour`
|
||
- `MilliSecondofTheMinute`
|
||
- `SecondOfTheDay`
|
||
- `MilliSecondOfTheWeek`
|
||
|
||
### 日期时间 / 范围判定函数
|
||
|
||
- `WithinPastYears`
|
||
- `WithinPastMonths`
|
||
- `WithinPastWeeks`
|
||
- `WithinPastDays`
|
||
- `WithinPastHours`
|
||
- `WithinPastMinutes`
|
||
- `WithinPastSeconds`
|
||
- `WithinPastMilliSeconds`
|
||
|
||
### 日期时间 / 范围获得函数
|
||
|
||
- `YearsBetween`
|
||
- `MonthsBetween`
|
||
- `WeeksBetween`
|
||
- `DaysBetween`
|
||
- `HoursBetween`
|
||
- `MinutesBetween`
|
||
- `SecondsBetween`
|
||
- `MilliSecondsBetween`
|
||
|
||
### 日期时间 / 范围生成函数
|
||
|
||
- `YearSpan`
|
||
- `MonthSpan`
|
||
- `WeekSpan`
|
||
- `DaySpan`
|
||
- `HourSpan`
|
||
- `MinuteSpan`
|
||
- `SecondSpan`
|
||
- `MilliSecondSpan`
|
||
|
||
### 日期时间 / 时间推移函数
|
||
|
||
- `IncYear`
|
||
- `IncHalfYear`
|
||
- `IncQuarter`
|
||
- `IncMonth`
|
||
- `IncWeek`
|
||
- `IncDay`
|
||
- `IncHour`
|
||
- `IncMinute`
|
||
- `IncSecond`
|
||
- `IncMilliSecond`
|
||
|
||
### 日期时间 / 组合、分解日期函数
|
||
|
||
- `EncodeDateTime`
|
||
- `DecodeDateTime`
|
||
- `EncodeDateWeek`
|
||
- `DecodeDateWeek`
|
||
- `DecodeDateDay`
|
||
- `EncodeDateMonthWeek`
|
||
- `DecodeDateMonthWeek`
|
||
- `TryEncodeDateTime`
|
||
- `TryEncodeDateWeek`
|
||
- `TryEncodeDateDay`
|
||
- `TryEncodeDateMonthWeek`
|
||
|
||
### 日期时间 / 日期重组函数
|
||
|
||
- `RecodeYear`
|
||
- `RecodeMonth`
|
||
- `RecodeDay`
|
||
- `RecodeHour`
|
||
- `RecodeMinute`
|
||
- `RecodeSecond`
|
||
- `RecodeMilliSecond`
|
||
- `RecodeDate`
|
||
- `RecodeTime`
|
||
- `RecodeDateTime`
|
||
- `TryRecodeDateTime`
|
||
- `CompareDateTime`
|
||
- `SameDateTime`
|
||
- `CompareDate`
|
||
- `SameDate`
|
||
- `CompareTime`
|
||
- `SameTime`
|
||
- `NthDayOfWeek`
|
||
- `DecodeDayOfWeekInMonth`
|
||
- `EncodeDayOfWeekInMonth`
|
||
- `TryEncodeDayOfWeekInMonth`
|
||
|
||
### 日期时间 / 日期格式的转换
|
||
|
||
- `DateTimeToJulianDate`
|
||
- `JulianDateToDateTime`
|
||
- `TryJulianDateToDateTime`
|
||
- `DateTimeToModifiedJulianDate`
|
||
- `ModifiedJulianDateToDateTime`
|
||
- `TryModifiedJulianDateToDateTime`
|
||
- `DateTimeToUnix`
|
||
- `UnixToDateTime`
|
||
- `FileDateToDateTime`
|
||
- `DateTimeToFileDate`
|
||
- `ExcelRDate`
|
||
|
||
### 日期时间 / 宽字节日期格式转换函数
|
||
|
||
- `DateTimeGMTToCookieStrw`
|
||
- `DateTimeGMTToHttpStrw`
|
||
- `DateTimeToInternetStrw`
|
||
- `Datetimetostrw`
|
||
- `TimetoStrw`
|
||
- `DateToStrw`
|
||
|
||
### 字符串 / 常用字符串函数
|
||
|
||
- `StrCmp`
|
||
- `Chr`
|
||
- `WideChr`
|
||
- `Str2Array`
|
||
- `Concat`
|
||
- `Array2Str`
|
||
- `Format`
|
||
- `Ord`
|
||
- `SetLength`
|
||
- `CompareText`
|
||
- `Copy`
|
||
- `UpperCase`
|
||
- `LeftBStr`
|
||
- `RightBStr`
|
||
- `MidBStr`
|
||
- `GetFormatLocalCode`
|
||
- `Str`
|
||
- `RightStr`
|
||
- `CompareStr`
|
||
- `LeftStr`
|
||
- `Trim`
|
||
- `SameText`
|
||
- `SetChar`
|
||
- `AppendStr`
|
||
- `GetChar`
|
||
- `LowerCase`
|
||
- `SetFormatLocalCode`
|
||
- `Val`
|
||
- `Pos`
|
||
- `TrimRight`
|
||
- `AnsiFormat`
|
||
- `TrimLeft`
|
||
- `StrToIntDef`
|
||
- `FormatFloat`
|
||
- `StrToCurrDef`
|
||
- `Booltostr2`
|
||
- `StrToFloatDef`
|
||
- `IntToHex`
|
||
- `TryStrToInt`
|
||
- `FloatToStr`
|
||
- `TryStrToFloat`
|
||
- `FormatCurr`
|
||
- `TryStrToCurr`
|
||
- `StrToInt`
|
||
- `BoolToStr`
|
||
- `CurrToStr`
|
||
- `TryStrToBool`
|
||
- `SpaceByNumber`
|
||
- `IsValidIdent`
|
||
- `StrToBool`
|
||
- `StrToFloat`
|
||
- `StrToBoolDef`
|
||
- `IntToStr`
|
||
- `StrToCurr`
|
||
- `AnsiStr2Array`
|
||
- `TryUppercase`
|
||
- `TryLowercase`
|
||
- `SysEncodecryptStr`
|
||
- `Letters`
|
||
- `DecToInt64`
|
||
- `DecToInt64def`
|
||
- `TryDecToInt64`
|
||
- `DecToInt32`
|
||
- `DecToInt32def`
|
||
- `TryDecToInt32`
|
||
- `StrToInt64`
|
||
- `StrToInt64Def`
|
||
- `TryStrToInt64`
|
||
- `StrToInt32`
|
||
- `StrToInt32Def`
|
||
- `TryStrToInt32`
|
||
- `DecToInt`
|
||
- `DecToIntDef`
|
||
- `TryDecToInt`
|
||
|
||
### 字符串 / 判定函数
|
||
|
||
- `AnsiContainsText`
|
||
- `AnsiStartsText`
|
||
- `AnsiEndsText`
|
||
- `AnsiMatchText`
|
||
- `AnsiContainsStr`
|
||
- `AnsiStartsStr`
|
||
- `AnsiEndsStr`
|
||
- `AnsiMatchStr`
|
||
- `FormatStrExt`
|
||
|
||
### 字符串 / 替换以及处理函数
|
||
|
||
- `StuffString`
|
||
- `AnsiReplaceText`
|
||
- `AnsiReplaceStr`
|
||
- `ReplaceText`
|
||
- `ReplaceStr`
|
||
- `WrapText`
|
||
- `AdjustLineBreaks`
|
||
- `ReverseString`
|
||
- `SeprateStrToTotal`
|
||
- `TotalStrToSeprate`
|
||
- `DateStrToArr`
|
||
- `RdateStrToArr`
|
||
|
||
### 字符串 / 字符串数组相关函数
|
||
|
||
- `AnsiIndexText`
|
||
- `AnsiIndexStr`
|
||
|
||
### 字符串 / 重复函数
|
||
|
||
- `DupeString`
|
||
|
||
### 字符串 / 多字节语言支持函数
|
||
|
||
- `LengthW`
|
||
- `MidStr`
|
||
|
||
### 字符串 / 字节函数
|
||
|
||
- `ContainsText`
|
||
- `StartsText`
|
||
- `EndsText`
|
||
- `ContainsStr`
|
||
- `StartsStr`
|
||
- `EndsStr`
|
||
- `StuffbString`
|
||
- `ReversebString`
|
||
|
||
### 字符串 / 发音相关函数
|
||
|
||
- `SoundEx`
|
||
- `SoundexInt`
|
||
- `DecodeSoundexInt`
|
||
- `SoundexWord`
|
||
- `DecodeSoundexWord`
|
||
- `SoundexSimilar`
|
||
- `SoundexCompare`
|
||
- `SoundexProc`
|
||
- `AnsiResemblesText`
|
||
|
||
### 字符串 / 正则表达式函数
|
||
|
||
- `ParseRegExpr`
|
||
- `GetLikeFlag`
|
||
- `SetLikeFlag`
|
||
- `ReplaceStrByReg`
|
||
- `ReplaceTextByReg`
|
||
- `ParseRegExpr3`
|
||
|
||
### 字符串 / 多语言支持函数
|
||
|
||
- `NextCharIndex`
|
||
- `AnsiToUTF8`
|
||
- `UTF8ToAnsi`
|
||
- `CharToByteIndex`
|
||
- `ByteToCharLen`
|
||
- `AnsiQuotedStr`
|
||
- `AnsiPos`
|
||
- `AnsiDequotedStr`
|
||
- `CharToByteLen`
|
||
- `CharLength`
|
||
- `ByteToCharIndex`
|
||
- `ByteType`
|
||
- `Booltostrw`
|
||
- `UnicodeESC`
|
||
- `unUnicodeESC2`
|
||
- `FloattoStrw`
|
||
- `UnicodeESC2`
|
||
- `unUnicodeESCw`
|
||
- `UnicodetoUTF8`
|
||
- `CurrtoStrw`
|
||
- `Inttostrw`
|
||
- `Booltostrw2`
|
||
- `Strw`
|
||
- `Inttohexw`
|
||
- `LCMapString`
|
||
- `MultibytetoUnicodew`
|
||
- `UTF8toUnicode`
|
||
- `Exportjsonstring`
|
||
- `unUnicodeESC2w`
|
||
- `unUnicodeESC`
|
||
- `Ifwstring`
|
||
- `Importjsonstring`
|
||
- `ExportJsonStringUTF8`
|
||
- `ExportJSONStringMBCS`
|
||
|
||
### 字符串 / 文件名以及目录名相关处理函数
|
||
|
||
- `ChangeFileExt`
|
||
- `ExtractFilePath`
|
||
- `ExtractFileDir`
|
||
- `ExtractFileDrive`
|
||
- `ExtractFileName`
|
||
- `ExtractFileExt`
|
||
- `ExtractRelativePath`
|
||
- `IsPathDelimiter`
|
||
- `IsDelimiter`
|
||
- `IncludeTrailingPathDelimiter`
|
||
- `IncludeTrailingBackslash`
|
||
- `ExcludeTrailingPathDelimiter`
|
||
- `ExcludeTrailingBackslash`
|
||
- `LastDelimiter`
|
||
- `AnsiCompareFileName`
|
||
- `SameFileName`
|
||
- `AnsiLowerCaseFileName`
|
||
- `AnsiUpperCaseFileName`
|
||
|
||
### 字符串 / 其它
|
||
|
||
- `GetPYStringList`
|
||
- `HztoPY`
|
||
- `DataUnitConversion`
|
||
|
||
### 数组 / 基本
|
||
|
||
- `FieldCount`
|
||
- `FieldExist`
|
||
- `FieldNames`
|
||
- `FieldName`
|
||
- `IsTable`
|
||
- `MagicSetArray`
|
||
- `NoRecordTable`
|
||
- `MagicGetArray`
|
||
- `RecordExist`
|
||
- `RecordExist2`
|
||
- `RecordExist3`
|
||
- `FieldNamesOfStrSubscript`
|
||
- `StrSubscriptTableToNormal`
|
||
- `FieldCountOfStrSubscript`
|
||
- `argmax`
|
||
- `Argmin`
|
||
- `PasswordGen`
|
||
|
||
### 数组 / 数组下标以及长度相关函数
|
||
|
||
- `GetStrIndexNum`
|
||
- `GetStrIndexs`
|
||
- `GetIntIndexs`
|
||
- `GetAllIndexs`
|
||
- `DeleteIndex`
|
||
- `DeleteField`
|
||
- `Length`
|
||
|
||
### 数组 / 排序函数
|
||
|
||
- `RankIt`
|
||
- `RankIt2`
|
||
- `RPSIt`
|
||
- `SortTableByFieldExt`
|
||
- `RankValue`
|
||
- `SortArray`
|
||
- `SortTableByField`
|
||
- `argsort`
|
||
|
||
### 数组 / 增删改查
|
||
|
||
- `AppendArray`
|
||
- `SeekPosInArray`
|
||
- `StockAmount`
|
||
- `DeleteNILValueByField`
|
||
- `FilterIn`
|
||
- `FilterNotIn`
|
||
- `IN1`
|
||
- `searchsorted`
|
||
- `argconfirst`
|
||
- `DeleteColumnByField`
|
||
- `Inserttablebyrno`
|
||
- `GetValuesByFieldValue`
|
||
- `Arrayextend`
|
||
- `Arrayinsert`
|
||
- `Frameinsert`
|
||
|
||
### 数组 / 数组操作
|
||
|
||
- `OutPutTableToCanBeUnderstood`
|
||
- `SeperateTable`
|
||
- `Unitary`
|
||
- `Reverse`
|
||
- `DescartesJoin`
|
||
- `TableVectorizeArray`
|
||
- `DataProcess_MF`
|
||
- `AbnormalData`
|
||
- `QKsplit_Trailing`
|
||
- `QKsplit_Resampling`
|
||
- `WebFormatToRung`
|
||
- `RPSValue`
|
||
- `ZValue`
|
||
- `QKsplit_ToDate`
|
||
- `GroupByFieldValue`
|
||
- `FilterOneDimEx2`
|
||
- `GroupRankIt`
|
||
- `ElementWhere`
|
||
- `Histogram`
|
||
- `FrameGetSubByReg`
|
||
- `Factorize`
|
||
- `GroupPercentrankIt`
|
||
- `SparseMatFill`
|
||
- `ArrayAddGap`
|
||
- `dumies_decode`
|
||
- `GroupTransformByFunc`
|
||
- `Framedrop_duplicates`
|
||
- `Field_ReSortCols`
|
||
- `Framedrop_na`
|
||
- `Framemerge`
|
||
- `Frameqcut`
|
||
- `Frameupdate`
|
||
- `GroupZscoreIt`
|
||
- `get_dummies`
|
||
- `get_dummies2`
|
||
- `framePivot_table`
|
||
- `framecut`
|
||
- `frameMelt`
|
||
- `GroupDemeanIt`
|
||
- `ArrDropDuplicate`
|
||
|
||
### 数组 / 数组取值
|
||
|
||
- `ColumnValue`
|
||
- `GetSubTableByField`
|
||
- `GetTopN`
|
||
- `FilterTableEx`
|
||
- `ColumnValue2`
|
||
- `GetBottomN`
|
||
- `FilterOneDimEx`
|
||
- `GetDistinctValue`
|
||
- `GetMiddleN`
|
||
- `FilterTable`
|
||
- `GetSubField`
|
||
- `GetSubTable`
|
||
- `Arraygetdefault`
|
||
- `Arraysetdefault`
|
||
- `Arraysetdefault2`
|
||
- `Randomchoice`
|
||
|
||
### 数组 / 集合运算
|
||
|
||
- `MergeArray`
|
||
- `FilterIntersectionPart`
|
||
- `FilterIntersectionPart2`
|
||
- `DistinctStr`
|
||
- `IntersectionPart`
|
||
- `QuickIntersectionPart`
|
||
- `Frameconcat`
|
||
|
||
### 数组 / 统计函数
|
||
|
||
- `GeoMeanByColumn`
|
||
- `SumValueByColumn`
|
||
- `AverageValueByColumn`
|
||
- `PercentValueByField`
|
||
- `MedianByColumn`
|
||
- `VarByColumn`
|
||
- `SumValueByColumn2`
|
||
- `SkewByColumn`
|
||
- `AveDevByColumn`
|
||
- `SumValueByRow2`
|
||
- `MaxValueByColumn`
|
||
- `DevsqByColumn`
|
||
- `KurtByColumn`
|
||
- `SumValueByRow`
|
||
- `HarMeanByColumn`
|
||
- `StatByColumn`
|
||
- `AverageByColumn`
|
||
- `StdevByColumn`
|
||
- `MinValueByColumn`
|
||
- `Describe`
|
||
- `Framecorrel`
|
||
- `Framecov`
|
||
- `Framehhi`
|
||
- `Framelag_zf`
|
||
- `Framepct_change`
|
||
- `Framevaluecounts`
|
||
- `Simpledescribe`
|
||
|
||
### 数组 / 重构函数
|
||
|
||
- `NormalTabletoStrSubscript`
|
||
- `RenameField`
|
||
- `Field_AddSuffix`
|
||
- `RenameFieldByFormat`
|
||
- `Field_AddPrefix`
|
||
- `ReIndex`
|
||
- `ReIndexCopy`
|
||
- `Reshape`
|
||
- `Frame_addprefix`
|
||
- `Frame_addsuffix`
|
||
|
||
### 数组 / 稀疏矩阵
|
||
|
||
- `Sparse1`
|
||
- `Sparse2`
|
||
- `Speye`
|
||
- `Sprand1`
|
||
- `Sprand2`
|
||
- `Sprandn1`
|
||
- `Sprandn2`
|
||
- `Sprandsym1`
|
||
- `Sprandsym2`
|
||
- `Sparsefull`
|
||
- `Spones`
|
||
- `Spnnz`
|
||
- `Spnonzeros`
|
||
- `Ifsparse`
|
||
- `Spdiags1`
|
||
- `Spdiags2`
|
||
- `Spdiags3`
|
||
- `Spdiags4`
|
||
|
||
### 数组 / 数据比较
|
||
|
||
- `TwoRDateCompare_M1`
|
||
- `CompareDataOfDifferentDataProvider`
|
||
|
||
### 数组 / 表格显示
|
||
|
||
- `Pivot`
|
||
- `Pivot_table`
|
||
- `Show3DTable`
|
||
- `Show2DTable`
|
||
- `ShowTableByField`
|
||
- `ShowTableByUnit`
|
||
- `ShowTableByInverse`
|
||
- `QuickRecordExist`
|
||
- `RotateTable`
|
||
- `NonIntersectionPart`
|
||
- `FooterValue`
|
||
- `FooterAverage`
|
||
- `FooterSum`
|
||
- `SetRowDefaultValue`
|
||
- `InverseTable`
|
||
- `GetSubTableByKey`
|
||
- `TableSelect`
|
||
- `TableType`
|
||
- `GetSubTableFreeParam`
|
||
- `ExpandTable`
|
||
|
||
### 数组 / 数组下标
|
||
|
||
- `frameIndex_filter`
|
||
- `frameIndex_getilocDZ`
|