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