# Functions

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