DS常用函数参考大全

Transformer函数大全Date$Time函数名称CurrentDateCurrentTimeCurrentTimestampHoursFromTimeJulianDayFromDateMicroSecondsFromTimeMinutesFromTimeMonthDayFromDateDateFromDaysSinceMonthFromDateNextWeekdayFromDate

测试用列CurrentDate()CurrentTime()CurrentTimestamp()HoursFromTime(’08:01:02’)JulianDayFromDate(‘2008-08-05’)MicroSecondsFromTime(‘17:52:31’)MinutesFromTime('14:24:45')MonthDayFromDate("2008-08-13")DateFromDaysSince('13',"2008-08-12")MonthFromDate('2008-09-01')NextWeekdayFromDate('2008-08-10','Thursday')

描述获取系统当天日期获取系统当天时间获取系统当天日期时间获取小时返回一个微妙数返回一个分钟数后的日期类型返回当月的月传入当月当天日期返回得到传入星期几的下一个日期几

测试结果2008-08-0517:52:312008-08-0517:52:3182454685024132008-08-2592008-08-14PreviousWeekdayFromDate PreviousWeekdayFromDate('2008-08-10','Wednesday') 传入当月当天日期

2008-08-06SecondsFromTime

SecondsFromTime('17:23:44') 传入时间返回时间 44的秒数SecondsSinceFromTimestamp SecondsSinceFromTimestamp('2008-08-0610:01:31','2008-08-1909:12:31')

返回两个日期的比较后得出的秒数

-1.12026e+06=-1120260TimeDate

TimeDate()

获取系统时间以时 14:07:50 06间，日，月，年显示Aug2008TimeFromMidnightSeconds

TimeFromMidnightSeconds('120')

传入秒数获得以计算秒为时间单位的时间

00:02:00TimestampFromDateTime TimestampFromDateTime('2008-09-01','07:30:41')TimestampFromSecondsSince TimestampFromSecondsSince('120','2008-08-0711:12:13')TimestampFromTimet TimestampFromTimet('120')

传入日期，时间整合返回TimestampTimestamp秒数累加到Timestamp类型上传入秒数返回一个unix上的类型

2008-09-0107:30:412008-08-0711:14:131970-01-0100:02:00TimetFromTimestampTimetFromTimestamp('1970-01-0100:02:00')传入timestamp类型120返回unixtime_tWeekdayFromDateWeekdayFromDate('2008-08-09','Wednesday')传入日期和星期几3返回传入日期当前星期（星期天排除为当前星期）的天数，向上查询YeardayFromDateYeardayFromDate('2008-09-09')传入日期返回传入253日期的当天数YearFromDateYearFromDate('2008-09-09')传入日期返回年份2008数YearweekFromDateYearweekFromDate('2008-09-09')传入日期返回传入37日期的所在周数IsValidif IsValid('int32', CUSTOMER)then传入一个参数和他123AsInteger(DSLink2.TXN_CNT)else''的匹配类型，如果匹配就输出，不匹配则if IsValid('dfloat',DSLink2.TXN_AMT)DSLink2.TXN_AMTelse''then为空"date","decimal",0000123．"dfloat","int8","sfloat","dfloat","int8","sfloat","uint8","int16","uint16","int32","uint32","int64", "uint64","raw","string","time","timestamp"."ustring"函数名称BitAnd测试用列BitAnd(235,25)描述 测试结果传入两个int型参数，将他们转化为二进9BitCompressifBitCompress(0)=00else1BitOr(321,123)1回1传入两个int型参数，将他们转化为二进0BitOr379BitXOr31411101011---235制，通过“或”关系将最后参数返回,当00011001---25为1与0比为0，1与1比为100001001--9101000001---321制，通过“与”关系将最后参数返回,当001111011---123为1与0比为1，1与1比为1101111011---379BitXOr(321,123) 传入两个int101000001---321制，当1与0比为1，1与1比为0001111011---123NotNot100111010 ---314Not(1=1)判断表达式，如果为真返回为0，如果为0假返回为1Number函数名称AsDoubleAsFloatAsInteger

测试用列AsDouble(12.123456)AsFloat(13.654321)AsInteger(11.23)

描述保留4为小数最后一位四舍五入保留4为小数最后一位四舍五入传入小数返回整数

测试结果12.123513.654311MantissaFromDecimalMantissaFromDFloatConvertConvert('bd','12',ConvertConvert('bd','12','abcdefghijk')a1c2efghijkCountDcountCount('jxj','j')Dcount('jxj','j')Arg1arg2后返回修改后的结果获取相同字符的合计获取相同字符的合计然后再加1将字符中的大写转化为小写23DownCaseDownCase('ACRM123ACrm123acRM')acrm123acrm123acrm

MantissaFromDecimal(15.123456) 取小数尾数MantissaFromDFloat(16.22222) 取小数尾数

1.23456e+0912345600002222函数名称测试用列描述测试结果AlNumAlNum('Sting12')传入的参数如果string类1型返回1AlphaAlpha('String')传入的参数为必须为1string不能带有其他字符，如果有则为0CompactWhiteSpaceCompactWhiteSpace('String'):'将多个字符串类型串联StringabcdABCD':CompactWhiteSpace('a bcd'):'为一个类型':CompactWhiteSpace('ABCD')CompareCompare('abc','def','L'):'比较字符串大小，按照-1':Compare('def','abc','R'):'ascII比较方式1':Compare('qwer','qwer','R')0CompareNoCaseCompareNoCase('B','C'):'比较两个字符串是否相-1':CompareNoCase('a','a')等，相等为0，不相等为-10CompareNumCompareNum('A','B',1):'比较传入的参数，如果绝-1':CompareNum('B','B',1):'对相同为0，传入的arg20':CompareNum('abc','cde',3):'arg1中为-1':CompareNum('abcd','a',4)1，不相等为-11DQuoteDQuote('abcd':'mnb'):'123'将两个字符串连接起来"abcdmnb"123用双引包括FieldField('parallel','l',3)将字符串中的字符串取e出来IndexIndex('a;lkdfjioquejrlkjasopdifu','j',2)索引字符串’j’直到发现第2个’j’的时候停止并13返回长度LeftLeft('abcdefghijk',4)从左边取4位字符串abcdRightRight('abcdefghijk',4)从右边取4位字符串hijkLenLen('asdlkfjalsdf')返回字符串的长度12NumNum(1234)如果是数字返回为1，非数字返回为01PadStringPadString('abcd','acr',3)第一个参数为输出参数，abcdaaa第二个为追加参数（只取字符串的第一位），第3个为追加几次SoundexSoundex('longtop')通过英文发音的比对来L523获取SquoteSquote('asdfasdf':'12')将传入的字符串想通过'asdfasdf12'单引号包括StrStr("A",20-Len('asd'))将传入第一个参数和后AAAAAAAAAAAAAAAAA面数字做联系，复制第一参数SpaceSpace(10-Len('asdf'))追加空格‘ ‘StripWhiteSpaceStripWhiteSpace('abeqwer')将字符串中所有的空格abeqwer去掉TrimTrim('askd ')去除左右两边空格askdTrim('kkabc','')去除多余的空格kkabcTrim('kkabc','','A')去除全部的空格kkabcTrim('kkabc','','L')去除左右的空格kk abcTrim('kkabc','','B')去除左右两边kk abcTrim('kkabc','','R')去左右两边和多余空格kkabcTrim('kkabc','','F')去除左边空格kk abcTrim('kkabc','','E')去除右边空格kka bcTrim('kkabc','','D')去除多余的空格kkabcTrimBTrimB('kkkk')去除右边的空格kkkkTrimFTrimLeadingTrailingUpCase

TrimF(' kkkk ')TrimLeadingTrailing(' kkkk UpCase('abcd')

去除左边的空格去除左右两边空格删除第一和最后的空格将所有小写转换为大写

kkkkkkkkABCD函数名称CharDateToStringDecimalToDecimalDecimalToDFloatDecimalToStringDFloatToDecimalDFloatToStringNoExpSeqStringToDateStringToDecimalStringToTimeStringToTimestampTimestampToDateTimestampToStringTimestampToTimeTimeToString

测试用列Char(123)DateToString('2008-08-01',"%yyyy-%mm-%dd")DecimalToDecimal(13.55)DecimalToDFloat(13.5678897866854464)DecimalToString(123.567)DFloatToDecimal(12.5658)DFloatToStringNoExp(29.10,'2'):'':DFloatToStringNoExp(29.120,'3'):'':DFloatToStringNoExp(29.120,'4')Seq('A'):'':Seq('B')StringToDate('19821114',"%yyyy%mm%dd")StringToDecimal('12.345','ceil'):'':StringToDecimal('12.345','floor')StringToTime('081114',"%hh%nn%ss")StringToTimestamp('19261212001245',"%yyyy%mm%dd%ss")TimestampToDate(CurrentTimestamp())TimestampToString(CurrentTimestamp(),"%yyyy/%mm/%dd %ss")TimestampToTime(CurrentTimestamp())TimeToString(CurrentTime(),"%hh-%nn-%ss")

描述将数字转化为对应的ASCII码将日期转化为字符将decimecl类型转化为decimal类型将decimecl类型转化为float类型并四舍五入将decimecl类型转化为string类型输出将float转化为decimal类型取dfloatstring输出将传入的字符转化为