> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: Expressions & Functions

> Write expressions and use 180+ built-in functions in Integrate.io ETL for string manipulation, date handling, math, JSON/XML processing, and encryption.

Expressions let you transform individual fields within your ETL components. Integrate.io provides 180+ built-in functions covering string operations (CONCAT, REPLACE, REGEX), date arithmetic (DaysBetween, ParseDate), math (ABS, ROUND, POW), JSON and XML processing, geolocation from IP, HTTP calls (Curl, CCurl), encryption (SHA256, AES), and more. The guides below cover expression syntax, variables, and the full function reference.

<CardGroup>
  <Card title="Functions Reference" icon="arrow-right" href="/etl/integrateio-etl-functions" horizontal />

  <Card title="Using Expressions" icon="arrow-right" href="/etl/using-expressions-in-integrateio-etl" horizontal />

  <Card title="Using and Setting Variables" icon="arrow-right" href="/etl/using-and-setting-variables-in-your-packages" horizontal />

  <Card title="Global Variables" icon="arrow-right" href="/etl/global-variables-account-level" horizontal />

  <Card title="System and Pre-Defined Variables" icon="arrow-right" href="/etl/system-and-pre-defined-variables" horizontal />

  <Card title="ISO 8601 String Functions" icon="arrow-right" href="/etl/using-iso-8601-string-functions" horizontal />

  <Card title="Encrypting and Decrypting Data" icon="arrow-right" href="/etl/how-do-i-encrypt-and-decrypt-sensitive-data" horizontal />

  <Card title="Processing JSON Data" icon="arrow-right" href="/etl/how-do-i-process-json-data" horizontal />

  <Card title="Processing XML Data" icon="arrow-right" href="/etl/how-do-i-process-xml-data" horizontal />

  <Card title="Processing Different Encodings" icon="arrow-right" href="/etl/how-do-i-process-a-different-encoding" horizontal />

  <Card title="Working with Datetime Data" icon="arrow-right" href="/etl/how-do-i-work-with-datetime-data" horizontal />

  <Card title="ABS" icon="arrow-right" href="/etl/abs" horizontal />

  <Card title="ACOS" icon="arrow-right" href="/etl/acos" horizontal />

  <Card title="AddDuration" icon="arrow-right" href="/etl/addduration" horizontal />

  <Card title="ASIN" icon="arrow-right" href="/etl/asin" horizontal />

  <Card title="ATAN" icon="arrow-right" href="/etl/atan" horizontal />

  <Card title="BagToString" icon="arrow-right" href="/etl/bagtostring" horizontal />

  <Card title="BagToTuple" icon="arrow-right" href="/etl/bagtotuple" horizontal />

  <Card title="Base64Decode" icon="arrow-right" href="/etl/base64decode" horizontal />

  <Card title="Base64DecodeToString" icon="arrow-right" href="/etl/base64decodetostring" horizontal />

  <Card title="Base64Encode" icon="arrow-right" href="/etl/base64encode" horizontal />

  <Card title="Base64EncodeToString" icon="arrow-right" href="/etl/base64encodetostring" horizontal />

  <Card title="BinaryCCurl" icon="arrow-right" href="/etl/binaryccurl" horizontal />

  <Card title="BinaryCurl" icon="arrow-right" href="/etl/binarycurl" horizontal />

  <Card title="BrowserFamily" icon="arrow-right" href="/etl/browserfamily" horizontal />

  <Card title="BrowserFullName" icon="arrow-right" href="/etl/browserfullname" horizontal />

  <Card title="BrowserMajor" icon="arrow-right" href="/etl/browsermajor" horizontal />

  <Card title="BrowserMinor" icon="arrow-right" href="/etl/browserminor" horizontal />

  <Card title="BrowserPatch" icon="arrow-right" href="/etl/browserpatch" horizontal />

  <Card title="BrowserVersion" icon="arrow-right" href="/etl/browserversion" horizontal />

  <Card title="ByteArrayToString" icon="arrow-right" href="/etl/bytearraytostring" horizontal />

  <Card title="CBRT" icon="arrow-right" href="/etl/cbrt" horizontal />

  <Card title="CCurl" icon="arrow-right" href="/etl/ccurl" horizontal />

  <Card title="CCurlPoll" icon="arrow-right" href="/etl/ccurlpoll" horizontal />

  <Card title="CCurlWithPagination" icon="arrow-right" href="/etl/ccurlwithpagination" horizontal />

  <Card title="CEIL" icon="arrow-right" href="/etl/ceil" horizontal />

  <Card title="CityNameFromIP" icon="arrow-right" href="/etl/citynamefromip" horizontal />

  <Card title="ClockTime" icon="arrow-right" href="/etl/clocktime" horizontal />

  <Card title="COALESCE" icon="arrow-right" href="/etl/coalesce" horizontal />

  <Card title="CONCAT" icon="arrow-right" href="/etl/concat" horizontal />

  <Card title="ContinentCodeFromIP" icon="arrow-right" href="/etl/continentcodefromip" horizontal />

  <Card title="ContinentNameFromIP" icon="arrow-right" href="/etl/continentnamefromip" horizontal />

  <Card title="COS" icon="arrow-right" href="/etl/cos" horizontal />

  <Card title="COSH" icon="arrow-right" href="/etl/cosh" horizontal />

  <Card title="CountryCodeFromIP" icon="arrow-right" href="/etl/countrycodefromip" horizontal />

  <Card title="CountryNameFromIP" icon="arrow-right" href="/etl/countrynamefromip" horizontal />

  <Card title="CSVSPLIT" icon="arrow-right" href="/etl/csvsplit" horizontal />

  <Card title="Curl" icon="arrow-right" href="/etl/curl" horizontal />

  <Card title="CurlPoll" icon="arrow-right" href="/etl/curlpoll" horizontal />

  <Card title="CCurlWithPagination" icon="arrow-right" href="/etl/curlwithpagination" horizontal />

  <Card title="CurrentTime" icon="arrow-right" href="/etl/currenttime" horizontal />

  <Card title="DateDiffDays" icon="arrow-right" href="/etl/datediffdays" horizontal />

  <Card title="DateDiffHours" icon="arrow-right" href="/etl/datediffhours" horizontal />

  <Card title="DateDiffMinutes" icon="arrow-right" href="/etl/datediffminutes" horizontal />

  <Card title="DateDiffMonths" icon="arrow-right" href="/etl/datediffmonths" horizontal />

  <Card title="DateDiffSeconds" icon="arrow-right" href="/etl/datediffseconds" horizontal />

  <Card title="DateDiffYears" icon="arrow-right" href="/etl/datediffyears" horizontal />

  <Card title="DaysBetween" icon="arrow-right" href="/etl/daysbetween" horizontal />

  <Card title="Decrypt" icon="arrow-right" href="/etl/decrypt" horizontal />

  <Card title="DeviceFamily" icon="arrow-right" href="/etl/devicefamily" horizontal />

  <Card title="DistInMilesHaversine" icon="arrow-right" href="/etl/distinmileshaversine" horizontal />

  <Card title="Encrypt" icon="arrow-right" href="/etl/encrypt" horizontal />

  <Card title="ExecuteBQInsert" icon="arrow-right" href="/etl/executebqinsert" horizontal />

  <Card title="ExecuteSqlBoolean" icon="arrow-right" href="/etl/executesqlboolean" horizontal />

  <Card title="ExecuteSqlDateTime" icon="arrow-right" href="/etl/executesqldatetime" horizontal />

  <Card title="ExecuteSqlDouble" icon="arrow-right" href="/etl/executesqldouble" horizontal />

  <Card title="ExecuteSqlFloat" icon="arrow-right" href="/etl/executesqlfloat" horizontal />

  <Card title="ExecuteSqlInt" icon="arrow-right" href="/etl/executesqlint" horizontal />

  <Card title="ExecuteSqlLong" icon="arrow-right" href="/etl/executesqllong" horizontal />

  <Card title="ExecuteSqlNonQuery" icon="arrow-right" href="/etl/executesqlnonquery" horizontal />

  <Card title="ExecuteSqlString" icon="arrow-right" href="/etl/executesqlstring" horizontal />

  <Card title="EXP" icon="arrow-right" href="/etl/exp" horizontal />

  <Card title="ExtractQueryStringParam" icon="arrow-right" href="/etl/extractquerystringparam" horizontal />

  <Card title="ExtractSearchQuery" icon="arrow-right" href="/etl/extractsearchquery" horizontal />

  <Card title="ExtractUABrowserID" icon="arrow-right" href="/etl/extractuabrowserid" horizontal />

  <Card title="ExtractUABrowserName" icon="arrow-right" href="/etl/extractuabrowsername" horizontal />

  <Card title="ExtractUrlPart" icon="arrow-right" href="/etl/extracturlpart" horizontal />

  <Card title="Flatten" icon="arrow-right" href="/etl/flatten" horizontal />

  <Card title="FLOOR" icon="arrow-right" href="/etl/floor" horizontal />

  <Card title="GetBytes" icon="arrow-right" href="/etl/getbytes" horizontal />

  <Card title="GetDay" icon="arrow-right" href="/etl/getday" horizontal />

  <Card title="GetHour" icon="arrow-right" href="/etl/gethour" horizontal />

  <Card title="GetMilliSecond" icon="arrow-right" href="/etl/getmillisecond" horizontal />

  <Card title="GetMinute" icon="arrow-right" href="/etl/getminute" horizontal />

  <Card title="GetMonth" icon="arrow-right" href="/etl/getmonth" horizontal />

  <Card title="GetSecond" icon="arrow-right" href="/etl/getsecond" horizontal />

  <Card title="GetWeek" icon="arrow-right" href="/etl/getweek" horizontal />

  <Card title="GetWeekYear" icon="arrow-right" href="/etl/getweekyear" horizontal />

  <Card title="GetYear" icon="arrow-right" href="/etl/getyear" horizontal />

  <Card title="HoursBetween" icon="arrow-right" href="/etl/hoursbetween" horizontal />

  <Card title="INDEXOF" icon="arrow-right" href="/etl/indexof" horizontal />

  <Card title="IntervalIntersection" icon="arrow-right" href="/etl/intervalintersection" horizontal />

  <Card title="IsBase64" icon="arrow-right" href="/etl/isbase64" horizontal />

  <Card title="IsEmpty" icon="arrow-right" href="/etl/isempty" horizontal />

  <Card title="IsISODatetime" icon="arrow-right" href="/etl/isisodatetime" horizontal />

  <Card title="ISOAddDuration" icon="arrow-right" href="/etl/isoaddduration" horizontal />

  <Card title="ISODatetimeToString" icon="arrow-right" href="/etl/isodatetimetostring" horizontal />

  <Card title="ISODatetimeToTimestampFormat" icon="arrow-right" href="/etl/isodatetimetotimestampformat" horizontal />

  <Card title="ISOSubtractDuration" icon="arrow-right" href="/etl/isosubtractduration" horizontal />

  <Card title="ISOToDay" icon="arrow-right" href="/etl/isotoday" horizontal />

  <Card title="ISOToHour" icon="arrow-right" href="/etl/isotohour" horizontal />

  <Card title="ISOToMinute" icon="arrow-right" href="/etl/isotominute" horizontal />

  <Card title="ISOToMonth" icon="arrow-right" href="/etl/isotomonth" horizontal />

  <Card title="ISOToSecond" icon="arrow-right" href="/etl/isotosecond" horizontal />

  <Card title="ISOToWeek" icon="arrow-right" href="/etl/isotoweek" horizontal />

  <Card title="ISOToYear" icon="arrow-right" href="/etl/isotoyear" horizontal />

  <Card title="JsonExtract" icon="arrow-right" href="/etl/jsonextract" horizontal />

  <Card title="JsonExtractScalar" icon="arrow-right" href="/etl/jsonextractscalar" horizontal />

  <Card title="JsonStringToBag" icon="arrow-right" href="/etl/jsonstringtobag" horizontal />

  <Card title="JsonStringToMap" icon="arrow-right" href="/etl/jsonstringtomap" horizontal />

  <Card title="LAST_INDEX_OF" icon="arrow-right" href="/etl/last-index-of" horizontal />

  <Card title="LatitudeFromIP" icon="arrow-right" href="/etl/latitudefromip" horizontal />

  <Card title="LCFIRST" icon="arrow-right" href="/etl/lcfirst" horizontal />

  <Card title="Length" icon="arrow-right" href="/etl/length" horizontal />

  <Card title="LOG" icon="arrow-right" href="/etl/log" horizontal />

  <Card title="LOG10" icon="arrow-right" href="/etl/log10" horizontal />

  <Card title="LongitudeFromIP" icon="arrow-right" href="/etl/longitudefromip" horizontal />

  <Card title="LOWER" icon="arrow-right" href="/etl/lower" horizontal />

  <Card title="MapToBag" icon="arrow-right" href="/etl/maptobag" horizontal />

  <Card title="MapToQueryString" icon="arrow-right" href="/etl/maptoquerystring" horizontal />

  <Card title="MD2" icon="arrow-right" href="/etl/md2" horizontal />

  <Card title="MD5" icon="arrow-right" href="/etl/md5" horizontal />

  <Card title="MilliSecondsBetween" icon="arrow-right" href="/etl/millisecondsbetween" horizontal />

  <Card title="MinutesBetween" icon="arrow-right" href="/etl/minutesbetween" horizontal />

  <Card title="MonthsBetween" icon="arrow-right" href="/etl/monthsbetween" horizontal />

  <Card title="OsFamily" icon="arrow-right" href="/etl/osfamily" horizontal />

  <Card title="OsFullName" icon="arrow-right" href="/etl/osfullname" horizontal />

  <Card title="OsMajor" icon="arrow-right" href="/etl/osmajor" horizontal />

  <Card title="OsMinor" icon="arrow-right" href="/etl/osminor" horizontal />

  <Card title="OsPatch" icon="arrow-right" href="/etl/ospatch" horizontal />

  <Card title="OsPatchMinor" icon="arrow-right" href="/etl/ospatchminor" horizontal />

  <Card title="OsVersion" icon="arrow-right" href="/etl/osversion" horizontal />

  <Card title="ParseDate" icon="arrow-right" href="/etl/parsedate" horizontal />

  <Card title="ParseDoubleOrDefault" icon="arrow-right" href="/etl/parsedoubleordefault" horizontal />

  <Card title="ParseFloatOrDefault" icon="arrow-right" href="/etl/parsefloatordefault" horizontal />

  <Card title="ParseIntOrDefault" icon="arrow-right" href="/etl/parseintordefault" horizontal />

  <Card title="ParseLongOrDefault" icon="arrow-right" href="/etl/parselongordefault" horizontal />

  <Card title="PlatformFamily" icon="arrow-right" href="/etl/platformfamily" horizontal />

  <Card title="POW" icon="arrow-right" href="/etl/pow" horizontal />

  <Card title="QueryStringToMap" icon="arrow-right" href="/etl/querystringtomap" horizontal />

  <Card title="RANDOM" icon="arrow-right" href="/etl/random" horizontal />

  <Card title="REGEX_EXTRACT" icon="arrow-right" href="/etl/regex-extract" horizontal />

  <Card title="REGEX_EXTRACT_ALL" icon="arrow-right" href="/etl/regex-extract-all" horizontal />

  <Card title="REGEX_FIND_ALL" icon="arrow-right" href="/etl/regex-find-all" horizontal />

  <Card title="RegionCodeFromIP" icon="arrow-right" href="/etl/regioncodefromip" horizontal />

  <Card title="RegionNameFromIP" icon="arrow-right" href="/etl/regionnamefromip" horizontal />

  <Card title="REPLACE" icon="arrow-right" href="/etl/replace" horizontal />

  <Card title="Reverse" icon="arrow-right" href="/etl/reverse" horizontal />

  <Card title="ROUND" icon="arrow-right" href="/etl/round" horizontal />

  <Card title="ROUND_TO" icon="arrow-right" href="/etl/round-to" horizontal />

  <Card title="SecondsBetween" icon="arrow-right" href="/etl/secondsbetween" horizontal />

  <Card title="SHA1" icon="arrow-right" href="/etl/sha1" horizontal />

  <Card title="SHA256" icon="arrow-right" href="/etl/sha256" horizontal />

  <Card title="SHA256WithRSA" icon="arrow-right" href="/etl/sha256withrsa" horizontal />

  <Card title="SHA384" icon="arrow-right" href="/etl/sha384" horizontal />

  <Card title="SHA512" icon="arrow-right" href="/etl/sha512" horizontal />

  <Card title="SIN" icon="arrow-right" href="/etl/sin" horizontal />

  <Card title="SINH" icon="arrow-right" href="/etl/sinh" horizontal />

  <Card title="SIZE" icon="arrow-right" href="/etl/size" horizontal />

  <Card title="Sleep" icon="arrow-right" href="/etl/sleep" horizontal />

  <Card title="SPRINTF" icon="arrow-right" href="/etl/sprintf" horizontal />

  <Card title="SQRT" icon="arrow-right" href="/etl/sqrt" horizontal />

  <Card title="StringToISODatetime" icon="arrow-right" href="/etl/stringtoisodatetime" horizontal />

  <Card title="STRSPLIT" icon="arrow-right" href="/etl/strsplit" horizontal />

  <Card title="STRSPLITTOBAG" icon="arrow-right" href="/etl/strsplittobag" horizontal />

  <Card title="SUBSTRING" icon="arrow-right" href="/etl/substring" horizontal />

  <Card title="SubtractDuration" icon="arrow-right" href="/etl/subtractduration" horizontal />

  <Card title="SwitchTimeZone" icon="arrow-right" href="/etl/switchtimezone" horizontal />

  <Card title="TAN" icon="arrow-right" href="/etl/tan" horizontal />

  <Card title="TANH" icon="arrow-right" href="/etl/tanh" horizontal />

  <Card title="TimestampFormatToISODatetime" icon="arrow-right" href="/etl/timestampformattoisodatetime" horizontal />

  <Card title="TOBAG" icon="arrow-right" href="/etl/tobag" horizontal />

  <Card title="ToDate" icon="arrow-right" href="/etl/todate" horizontal />

  <Card title="ToDateCustomFormats" icon="arrow-right" href="/etl/todatecustomformats" horizontal />

  <Card title="ToHexString" icon="arrow-right" href="/etl/tohexstring" horizontal />

  <Card title="ToJson" icon="arrow-right" href="/etl/tojson" horizontal />

  <Card title="TOKENIZE" icon="arrow-right" href="/etl/tokenize" horizontal />

  <Card title="TOMAP" icon="arrow-right" href="/etl/tomap" horizontal />

  <Card title="ToMilliSeconds" icon="arrow-right" href="/etl/tomilliseconds" horizontal />

  <Card title="ToString" icon="arrow-right" href="/etl/tostring" horizontal />

  <Card title="TOTUPLE" icon="arrow-right" href="/etl/totuple" horizontal />

  <Card title="ToUnixTime" icon="arrow-right" href="/etl/tounixtime" horizontal />

  <Card title="TRIM" icon="arrow-right" href="/etl/trim" horizontal />

  <Card title="UCFIRST" icon="arrow-right" href="/etl/ucfirst" horizontal />

  <Card title="UPPER" icon="arrow-right" href="/etl/upper" horizontal />

  <Card title="URLDecode" icon="arrow-right" href="/etl/urldecode" horizontal />

  <Card title="URLEncode" icon="arrow-right" href="/etl/urlencode" horizontal />

  <Card title="UUID" icon="arrow-right" href="/etl/uuid" horizontal />

  <Card title="WeeksBetween" icon="arrow-right" href="/etl/weeksbetween" horizontal />

  <Card title="XPath" icon="arrow-right" href="/etl/xpath" horizontal />

  <Card title="XPathToBag" icon="arrow-right" href="/etl/xpathtobag" horizontal />

  <Card title="YearsBetween" icon="arrow-right" href="/etl/yearsbetween" horizontal />
</CardGroup>