# Functions

- [Introducing Function Transformations](/functions/introducing-function-transformations.md)
- [Custom Functions](/functions/custom-functions.md)
- [Logical](/functions/logical.md)
- [Coalesce (Any value1, Any value2)](/functions/logical/coalesce-any-value1-any-value2.md)
- [IsNotNull (AnyValue)](/functions/logical/isnotnull-anyvalue.md)
- [IsRealNumber (AnyValue)](/functions/logical/isrealnumber-anyvalue.md)
- [IsValidSqlDate (Date)](/functions/logical/isvalidsqldate-date.md)
- [IsDate (AnyValue)](/functions/logical/isdate-anyvalue.md)
- [If (Boolean)](/functions/logical/if-boolean.md)
- [If (DateTime)](/functions/logical/if-datetime.md)
- [If (Double)](/functions/logical/if-double.md)
- [Exists](/functions/logical/exists.md)
- [If (Int64)](/functions/logical/if-int64.md)
- [If (String)](/functions/logical/if-string.md)
- [IsDate (str, strformat)](/functions/logical/isdate-str-strformat.md)
- [IsInteger (AnyValue)](/functions/logical/isinteger-anyvalue.md)
- [IsNullOrWhitespace (StringValue)](/functions/logical/isnullorwhitespace-stringvalue.md)
- [IsNullorEmpty (StringValue)](/functions/logical/isnullorempty-stringvalue.md)
- [IsNull (AnyValue)](/functions/logical/isnull-anyvalue.md)
- [IsNumeric (AnyValue)](/functions/logical/isnumeric-anyvalue.md)
- [Conversion](/functions/conversion.md)
- [GetDateComponents (DateWithOffset)](/functions/conversion/getdatecomponents-datewithoffset.md)
- [ParseDate (Formats, Str)](/functions/conversion/parsedate-formats-str.md)
- [GetDateComponents (Date)](/functions/conversion/getdatecomponents-date.md)
- [HexToInteger (Any Value)](/functions/conversion/hextointeger-any-value.md)
- [ToInteger (Any value)](/functions/conversion/tointeger-any-value.md)
- [ToDecimal (Any value)](/functions/conversion/todecimal-any-value.md)
- [ToReal (Any value)](/functions/conversion/toreal-any-value.md)
- [ToDate (String dateStr)](/functions/conversion/todate-string-datestr.md)
- [TryParseDate (String, UnknownDate)](/functions/conversion/tryparsedate-string-unknowndate.md)
- [ToString (Any value)](/functions/conversion/tostring-any-value.md)
- [ToString (DateValue)](/functions/conversion/tostring-datevalue.md)
- [ToString (Any data, String format)](/functions/conversion/tostring-any-data-string-format.md)
- [Math](/functions/math.md)
- [Abs (Double)](/functions/math/abs-double.md)
- [Abs (Decimal)](/functions/math/abs-decimal.md)
- [Ceiling (Real)](/functions/math/ceiling-real.md)
- [Ceiling(Decimal)](/functions/math/ceiling-decimal.md)
- [Floor (Decimal)](/functions/math/floor-decimal.md)
- [Floor (Real)](/functions/math/floor-real.md)
- [Max (Decimal)](/functions/math/max-decimal.md)
- [Max (Date)](/functions/math/max-date.md)
- [Min (Decimal)](/functions/math/min-decimal.md)
- [Min (Date)](/functions/math/min-date.md)
- [Max (Real)](/functions/math/max-real.md)
- [Max (Integer)](/functions/math/max-integer.md)
- [Min (Real)](/functions/math/min-real.md)
- [Pow (BaseExponent)](/functions/math/pow-baseexponent.md)
- [Min (Integer)](/functions/math/min-integer.md)
- [RandomReal (Int)](/functions/math/randomreal-int.md)
- [Round (Real)](/functions/math/round-real.md)
- [Round (Real Integer)](/functions/math/round-real-integer.md)
- [Round (Decimal Integer)](/functions/math/round-decimal-integer.md)
- [Round (Decimal)](/functions/math/round-decimal.md)
- [Financial](/functions/financial.md)
- [DDB](/functions/financial/ddb.md)
- [FV](/functions/financial/fv.md)
- [IPmt](/functions/financial/ipmt.md)
- [IPmt (FV)](/functions/financial/ipmt-fv.md)
- [Pmt](/functions/financial/pmt.md)
- [Pmt (FV)](/functions/financial/pmt-fv.md)
- [PPmt](/functions/financial/ppmt.md)
- [PPmt (FV)](/functions/financial/ppmt-fv.md)
- [PV (FV)](/functions/financial/pv-fv.md)
- [Rate](/functions/financial/rate.md)
- [Rate (FV)](/functions/financial/rate-fv.md)
- [SLN](/functions/financial/sln.md)
- [SYD](/functions/financial/syd.md)
- [String](/functions/string.md)
- [Center (String)](/functions/string/center-string.md)
- [Chr (IntAscii)](/functions/string/chr-intascii.md)
- [Asc (String)](/functions/string/asc-string.md)
- [AddCDATAEnvelope](/functions/string/addcdataenvelope.md)
- [Concatenate (String)](/functions/string/concatenate-string.md)
- [ContainsAnyChar (String)](/functions/string/containsanychar-string.md)
- [Contains (String)](/functions/string/contains-string.md)
- [Compact (String)](/functions/string/compact-string.md)
- [Find (Int64)](/functions/string/find-int64.md)
- [EndsWith (String)](/functions/string/endswith-string.md)
- [FindIntStart (Int32)](/functions/string/findintstart-int32.md)
- [Extract (String)](/functions/string/extract-string.md)
- [GetFindCount (Int64)](/functions/string/getfindcount-int64.md)
- [FindLast (Int64)](/functions/string/findlast-int64.md)
- [GetDigits (String)](/functions/string/getdigits-string.md)
- [GetLineFeed](/functions/string/getlinefeed.md)
- [Insert (String)](/functions/string/insert-string.md)
- [IsAlpha](/functions/string/isalpha.md)
- [GetToken](/functions/string/gettoken.md)
- [IndexOf](/functions/string/indexof.md)
- [IsBlank](/functions/string/isblank.md)
- [IsLower](/functions/string/islower.md)
- [IsUpper](/functions/string/isupper.md)
- [IsSubstringOf](/functions/string/issubstringof.md)
- [Length (String)](/functions/string/length-string.md)
- [LeftOf (String)](/functions/string/leftof-string.md)
- [Left (String)](/functions/string/left-string.md)
- [IsValidName](/functions/string/isvalidname.md)
- [Mid (String)](/functions/string/mid-string.md)
- [PadLeft](/functions/string/padleft.md)
- [Mid (String Chars)](/functions/string/mid-string-chars.md)
- [LSplit (String)](/functions/string/lsplit-string.md)
- [PadRight](/functions/string/padright.md)
- [ReplaceAllSpecialCharsWithSpace](/functions/string/replaceallspecialcharswithspace.md)
- [RemoveChars (String str, StringCharsToRemove)](/functions/string/removechars-string-str-stringcharstoremove.md)
- [ReplaceLast](/functions/string/replacelast.md)
- [RightAlign](/functions/string/rightalign.md)
- [Reverse](/functions/string/reverse.md)
- [Right (String)](/functions/string/right-string.md)
- [RSplit (String)](/functions/string/rsplit-string.md)
- [SplitStringMultipleRecords](/functions/string/splitstringmultiplerecords.md)
- [SplitStringMultipleRecords (2 Separators)](/functions/string/splitstringmultiplerecords-2-separators.md)
- [SplitString (3 separators)](/functions/string/splitstring-3-separators.md)
- [SplitString](/functions/string/splitstring.md)
- [SplitStringMultipleRecords (3 Separators)](/functions/string/splitstringmultiplerecords-3-separators.md)
- [Trim](/functions/string/trim.md)
- [SubString (NoOfChars)](/functions/string/substring-noofchars.md)
- [StripHtml](/functions/string/striphtml.md)
- [Trim (Start)](/functions/string/trim-start.md)
- [TrimExtraMiddleSpace](/functions/string/trimextramiddlespace.md)
- [TrimEnd](/functions/string/trimend.md)
- [PascalCaseWithSpace (String str)](/functions/string/pascalcasewithspace-string-str.md)
- [Trim (String str)](/functions/string/trim-string-str.md)
- [ToLower(String str)](/functions/string/tolower-string-str.md)
- [ToProper(String str)](/functions/string/toproper-string-str.md)
- [ToUpper (String str)](/functions/string/toupper-string-str.md)
- [Substring (String str, Integer startAt)](/functions/string/substring-string-str-integer-startat.md)
- [StartsWith (String str, String value)](/functions/string/startswith-string-str-string-value.md)
- [RemoveAt (String str, Integer startAt, Integer noofChars)](/functions/string/removeat-string-str-integer-startat-integer-noofchars.md)
- [Proper (String str)](/functions/string/proper-string-str.md)
- [Repeat (String str, Integer count)](/functions/string/repeat-string-str-integer-count.md)
- [ReplaceAll (String str, String lookFor, String replaceWith)](/functions/string/replaceall-string-str-string-lookfor-string-replacewith.md)
- [ReplaceFirst (String str, String lookFor, String replaceWith)](/functions/string/replacefirst-string-str-string-lookfor-string-replacewith.md)
- [RightOf (String str, String lookFor)](/functions/string/rightof-string-str-string-lookfor.md)
- [RemoveChars (String str, String charsToRemove)](/functions/string/removechars-string-str-string-charstoremove.md)
- [SplitString (String str, String separator1, String separator2)](/functions/string/splitstring-string-str-string-separator1-string-separator2.md)
- [Date Time](/functions/date-time.md)
- [AddMinutes (DateTime)](/functions/date-time/addminutes-datetime.md)
- [AddDays (DateTimeOffset)](/functions/date-time/adddays-datetimeoffset.md)
- [AddDays (DateTime)](/functions/date-time/adddays-datetime.md)
- [AddHours (DateTime)](/functions/date-time/addhours-datetime.md)
- [AddSeconds (DateTime)](/functions/date-time/addseconds-datetime.md)
- [AddMonths (DateTime)](/functions/date-time/addmonths-datetime.md)
- [AddMonths (DateTimeOffset)](/functions/date-time/addmonths-datetimeoffset.md)
- [AddMinutes (DateTimeOffset)](/functions/date-time/addminutes-datetimeoffset.md)
- [AddSeconds (DateTimeOffset)](/functions/date-time/addseconds-datetimeoffset.md)
- [AddYears (DateTimeOffset)](/functions/date-time/addyears-datetimeoffset.md)
- [AddYears (DateTime)](/functions/date-time/addyears-datetime.md)
- [Age (DateTime)](/functions/date-time/age-datetime.md)
- [Age (DateTimeOffset)](/functions/date-time/age-datetimeoffset.md)
- [CharToSeconds (Str)](/functions/date-time/chartoseconds-str.md)
- [DateDifferenceDays (DateTimeOffset)](/functions/date-time/datedifferencedays-datetimeoffset.md)
- [DateDifferenceDays (DateTime)](/functions/date-time/datedifferencedays-datetime.md)
- [DateDifferenceHours (DateTimeOffset)](/functions/date-time/datedifferencehours-datetimeoffset.md)
- [DateDifferenceHours (DateTime)](/functions/date-time/datedifferencehours-datetime.md)
- [DateDifferenceMonths (DateTimeOffset)](/functions/date-time/datedifferencemonths-datetimeoffset.md)
- [DateDifferenceMonths (DateTime)](/functions/date-time/datedifferencemonths-datetime.md)
- [DatePart (DateTimeOffset)](/functions/date-time/datepart-datetimeoffset.md)
- [DatePart (DateTime)](/functions/date-time/datepart-datetime.md)
- [DateDifferenceYears (DateTimeOffset)](/functions/date-time/datedifferenceyears-datetimeoffset.md)
- [DateDifferenceYears (DateTime)](/functions/date-time/datedifferenceyears-datetime.md)
- [Month (DateTime)](/functions/date-time/month-datetime.md)
- [Month (DateTimeOffset)](/functions/date-time/month-datetimeoffset.md)
- [Now](/functions/date-time/now.md)
- [Quarter (DateTime)](/functions/date-time/quarter-datetime.md)
- [Quarter (DateTimeOffset)](/functions/date-time/quarter-datetimeoffset.md)
- [Second (DateTime)](/functions/date-time/second-datetime.md)
- [Second (DateTimeOffset)](/functions/date-time/second-datetimeoffset.md)
- [SecondsToChar (String)](/functions/date-time/secondstochar-string.md)
- [TimeToInteger (DateTime)](/functions/date-time/timetointeger-datetime.md)
- [TimeToInteger (DateTimeOffset)](/functions/date-time/timetointeger-datetimeoffset.md)
- [ToDate Date (DateTime)](/functions/date-time/todate-date-datetime.md)
- [ToDate DateTime (DateTime)](/functions/date-time/todate-datetime-datetime.md)
- [ToDateString (DateTime)](/functions/date-time/todatestring-datetime.md)
- [ToDateTimeOffset-Date (DateTimeOffset)](/functions/date-time/todatetimeoffset-date-datetimeoffset.md)
- [ToDate DateTime (DateTimeOffset)](/functions/date-time/todate-datetime-datetimeoffset.md)
- [ToDateString (DateTimeOffset)](/functions/date-time/todatestring-datetimeoffset.md)
- [Today](/functions/date-time/today.md)
- [ToLocal (DateTime)](/functions/date-time/tolocal-datetime.md)
- [ToJulianDate (DateTime)](/functions/date-time/tojuliandate-datetime.md)
- [ToJulianDayNumber (DateTime)](/functions/date-time/tojuliandaynumber-datetime.md)
- [ToTicks (Date dateTime)](/functions/date-time/toticks-date-datetime.md)
- [ToTicks (DateTimeWithOffset dateTime)](/functions/date-time/toticks-datetimewithoffset-datetime.md)
- [ToUnixEpoc (Date dateTime)](/functions/date-time/tounixepoc-date-datetime.md)
- [ToUtc (Date dateTime)](/functions/date-time/toutc-date-datetime.md)
- [UnixTimeStampToDateTime (Real unixTimeStamp)](/functions/date-time/unixtimestamptodatetime-real-unixtimestamp.md)
- [UtcNow ()](/functions/date-time/utcnow.md)
- [Week (Date dateTime)](/functions/date-time/week-date-datetime.md)
- [Week (DateTimeWithOffset dateTime)](/functions/date-time/week-datetimewithoffset-datetime.md)
- [Year (Date dateTime)](/functions/date-time/year-date-datetime.md)
- [Year (DateTimeWithOffset dateTime)](/functions/date-time/year-datetimewithoffset-datetime.md)
- [DateToJulian (Date dateTime, Integer length)](/functions/date-time/datetojulian-date-datetime-integer-length.md)
- [DateTimeOffsetUtcNow ()](/functions/date-time/datetimeoffsetutcnow.md)
- [DateTimeOffsetNow ()](/functions/date-time/datetimeoffsetnow.md)
- [Day (DateTimeWithOffset dateTime)](/functions/date-time/day-datetimewithoffset-datetime.md)
- [Day (Date dateTime)](/functions/date-time/day-date-datetime.md)
- [DayOfWeekStr (DateTimeWithOffset dateTime)](/functions/date-time/dayofweekstr-datetimewithoffset-datetime.md)
- [DayOfWeek (DateTimeWithOffset dateTime)](/functions/date-time/dayofweek-datetimewithoffset-datetime.md)
- [DayOfWeek (Date dateTime)](/functions/date-time/dayofweek-date-datetime.md)
- [DateToJulian (DateTimeWithOffset dateTime, Integer length)](/functions/date-time/datetojulian-datetimewithoffset-datetime-integer-length.md)
- [DayOfWeekStr (Date dateTime)](/functions/date-time/dayofweekstr-date-datetime.md)
- [FromJulianDate (Real julianDate)](/functions/date-time/fromjuliandate-real-juliandate.md)
- [DayOfYear (Date dateTime)](/functions/date-time/dayofyear-date-datetime.md)
- [DaysInMonth(Integer year, Integer month)](/functions/date-time/daysinmonth-integer-year-integer-month.md)
- [DayOfYear (DateTimeWithOffset dateTime)](/functions/date-time/dayofyear-datetimewithoffset-datetime.md)
- [FromUnixEpoc](/functions/date-time/fromunixepoc.md)
- [FromJulianDayNumber (Integer julianDayNumber)](/functions/date-time/fromjuliandaynumber-integer-juliandaynumber.md)
- [FromTicksUtc(Integer ticks)](/functions/date-time/fromticksutc-integer-ticks.md)
- [FromTicksLocal(Integer ticks)](/functions/date-time/fromtickslocal-integer-ticks.md)
- [Hour (Date dateTime)](/functions/date-time/hour-date-datetime.md)
- [Hour (DateTimeWithOffset dateTime)](/functions/date-time/hour-datetimewithoffset-datetime.md)
- [Minute (Date dateTime)](/functions/date-time/minute-date-datetime.md)
- [JulianToDate (String julianDate)](/functions/date-time/juliantodate-string-juliandate.md)
- [Minute (DateTimeWithOffset dateTime)](/functions/date-time/minute-datetimewithoffset-datetime.md)
- [DateToIntegerYYYYMMDD (DateTimeWithOffset dateTime)](/functions/date-time/datetointegeryyyymmdd-datetimewithoffset-datetime.md)
- [DateToIntegerYYYYMMDD (Date dateTime)](/functions/date-time/datetointegeryyyymmdd-date-datetime.md)
- [Files](/functions/files.md)
- [AppendTextToFile (String filePath, String text)](/functions/files/appendtexttofile-string-filepath-string-text.md)
- [CopyFile (String sourceFilePath, String destFilePath, Boolean overWrite)](/functions/files/copyfile-string-sourcefilepath-string-destfilepath-boolean-overwrite.md)
- [CreateDateTime (String filePath)](/functions/files/createdatetime-string-filepath.md)
- [DeleteFile (String filePath)](/functions/files/deletefile-string-filepath.md)
- [DirectoryExists (String filePath)](/functions/files/directoryexists-string-filepath.md)
- [FileExists (String filePath)](/functions/files/fileexists-string-filepath.md)
- [FileLength (String filePath)](/functions/files/filelength-string-filepath.md)
- [FileLineCount (String filePath)](/functions/files/filelinecount-string-filepath.md)
- [GetDirectory (String filePath)](/functions/files/getdirectory-string-filepath.md)
- [GetEDIFileMetaData (String filePath)](/functions/files/getedifilemetadata-string-filepath.md)
- [GetExcelWorksheets (String excelFilePath)](/functions/files/getexcelworksheets-string-excelfilepath.md)
- [GetFileExtension (String filePath)](/functions/files/getfileextension-string-filepath.md)
- [GetFileInfo (String filePath)](/functions/files/getfileinfo-string-filepath.md)
- [GetFileName (String filePath)](/functions/files/getfilename-string-filepath.md)
- [GetFileNameWithoutExtension (String filePath)](/functions/files/getfilenamewithoutextension-string-filepath.md)
- [LastUpdateDateTime (String filePath)](/functions/files/lastupdatedatetime-string-filepath.md)
- [MoveFile (String filePath, String newDirectory)](/functions/files/movefile-string-filepath-string-newdirectory.md)
- [ReadFileBytes (String filePath)](/functions/files/readfilebytes-string-filepath.md)
- [ReadFileFirstLine (String filePath)](/functions/files/readfilefirstline-string-filepath.md)
- [ReadFileText (String filePath)](/functions/files/readfiletext-string-filepath.md)
- [ReadFileText (String filePath, String codePage)](/functions/files/readfiletext-string-filepath-string-codepage.md)
- [WriteBytesToFile (String filePath, ByteArray bytes)](/functions/files/writebytestofile-string-filepath-bytearray-bytes.md)
- [WriteTextToFile (String filePath, String text)](/functions/files/writetexttofile-string-filepath-string-text.md)
- [Date Time With Offset](/functions/date-time-with-offset.md)
- [ToDateTimeOffsetFromDateTime (dateTime String)](/functions/date-time-with-offset/todatetimeoffsetfromdatetime-datetime-string.md)
- [ToUtc (DateTimeWithOffset)](/functions/date-time-with-offset/toutc-datetimewithoffset.md)
- [ToDateTimeOffsetFromDateTime](/functions/date-time-with-offset/todatetimeoffsetfromdatetime.md)
- [ToDateTimeOffset (String dateTimeOffsetStr)](/functions/date-time-with-offset/todatetimeoffset-string-datetimeoffsetstr.md)
- [ToDateTimeFromDateTimeOffset](/functions/date-time-with-offset/todatetimefromdatetimeoffset.md)
- [GUID](/functions/guid.md)
- [NewGuid](/functions/guid/newguid.md)
- [Encoding](/functions/encoding.md)
- [ToBytes](/functions/encoding/tobytes.md)
- [FromBytes](/functions/encoding/frombytes.md)
- [UrlEncode](/functions/encoding/urlencode.md)
- [UrlDecode](/functions/encoding/urldecode.md)
- [ComputeSHA256](/functions/encoding/computesha256.md)
- [ComputeMD5](/functions/encoding/computemd5.md)
- [ComputeHash (Str, Key)](/functions/encoding/computehash-str-key.md)
- [ComputeHash (Str, Key, hex)](/functions/encoding/computehash-str-key-hex.md)
- [ConvertEncoding](/functions/encoding/convertencoding.md)
- [Regular Expressions](/functions/regular-expressions.md)
- [ReplaceRegEx](/functions/regular-expressions/replaceregex.md)
- [ReplaceRegEx (Integer StartAt)](/functions/regular-expressions/replaceregex-integer-startat.md)
- [IsMatchRegEx (StartAt)](/functions/regular-expressions/ismatchregex-startat.md)
- [IsMatchRegEx](/functions/regular-expressions/ismatchregex.md)
- [IsUSPhone](/functions/regular-expressions/isusphone.md)
- [IsUSZipCode](/functions/regular-expressions/isuszipcode.md)
- [GetMatchRegEx](/functions/regular-expressions/getmatchregex.md)
- [GetMatchRegEx (StartAt)](/functions/regular-expressions/getmatchregex-startat.md)
- [TimeSpan](/functions/timespan.md)
- [Minutes](/functions/timespan/minutes.md)
- [Hours](/functions/timespan/hours.md)
- [Days](/functions/timespan/days.md)
- [Milliseconds](/functions/timespan/milliseconds.md)
- [TotalMilliseconds](/functions/timespan/totalmilliseconds.md)
- [TimeSpanFromTicks](/functions/timespan/timespanfromticks.md)
- [Ticks](/functions/timespan/ticks.md)
- [TotalHours](/functions/timespan/totalhours.md)
- [Seconds](/functions/timespan/seconds.md)
- [TotalDays](/functions/timespan/totaldays.md)
- [ToTimeSpan (Hours, Min, Sec)](/functions/timespan/totimespan-hours-min-sec.md)
- [ToTimeSpan (Milli)](/functions/timespan/totimespan-milli.md)
- [ToTimeSpan](/functions/timespan/totimespan.md)
- [TotalSeconds](/functions/timespan/totalseconds.md)
- [TotalMinutes](/functions/timespan/totalminutes.md)
- [Matching](/functions/matching.md)
- [Soundex](/functions/matching/soundex.md)
- [DoubleMetaphone](/functions/matching/doublemetaphone.md)
- [RefinedSoundex](/functions/matching/refinedsoundex.md)
- [Processes](/functions/processes.md)
- [TerminateProcess](/functions/processes/terminateprocess.md)
- [IsProcessRunning](/functions/processes/isprocessrunning.md)