Astera Data Stack
⌘Ctrlk
Astera Data Stack
  • Welcome to Astera Data Stack Documentation
    • Upgrading Astera 6 to Version 7
    • Release Notes for Astera 7.1
    • What is New in Astera 7.4
    • What’s New in Astera 7.4.1.221
    • What’s New in Astera 7.6
    • Upgrading to Astera 7.6
    • System Requirements
    • Installing Astera Data Integrator
    • Setting up Astera Integration Server 7
    • UI Walkthrough - Astera Data Integrator
    • Introducing Dataflows
    • Sources
    • Transformations
    • Destinations
    • Data Logging and Profiling
    • Database Write Strategies
    • Text Processors
    • Adding Workflow Tasks
    • Creating Workflows
    • Using Workflow Designer
    • Customizing Workflows With Parameters
    • Workflows with a Dynamic Destination Path
    • Resuming and Rerunning Workflows in Astera
    • Using Subflows
    • Functions Glossary
    • Introducing Function Transformations
    • Custom Functions
    • Logical
    • Conversion
    • Math
    • Financial
    • String
      • Center (String)
      • Chr (IntAscii)
      • Asc (String)
      • AddCDATAEnvelope
      • Concatenate (String)
      • ContainsAnyChar (String)
      • Contains (String)
      • Compact (String)
      • Find (Int64)
      • EndsWith (String)
      • FindIntStart (Int32)
      • Extract (String)
      • GetFindCount (Int64)
      • FindLast (Int64)
      • GetDigits (String)
      • GetLineFeed
      • Insert (String)
      • IsAlpha
      • GetToken
      • IndexOf
      • IsBlank
      • IsLower
      • IsUpper
      • IsSubstringOf
      • Length (String)
      • LeftOf (String)
      • Left (String)
      • IsValidName
      • Mid (String)
      • PadLeft
      • Mid (String Chars)
      • LSplit (String)
      • PadRight
      • ReplaceAllSpecialCharsWithSpace
      • RemoveChars (String str, StringCharsToRemove)
      • ReplaceLast
      • RightAlign
      • Reverse
      • Right (String)
      • RSplit (String)
      • SplitStringMultipleRecords
      • SplitStringMultipleRecords (2 Separators)
      • SplitString (3 separators)
      • SplitString
      • SplitStringMultipleRecords (3 Separators)
      • Trim
      • SubString (NoOfChars)
      • StripHtml
      • Trim (Start)
      • TrimExtraMiddleSpace
      • TrimEnd
      • PascalCaseWithSpace (String str)
      • Trim (String str)
      • ToLower(String str)
      • ToProper(String str)
      • ToUpper (String str)
      • Substring (String str, Integer startAt)
      • StartsWith (String str, String value)
      • RemoveAt (String str, Integer startAt, Integer noofChars)
      • Proper (String str)
      • Repeat (String str, Integer count)
      • ReplaceAll (String str, String lookFor, String replaceWith)
      • ReplaceFirst (String str, String lookFor, String replaceWith)
      • RightOf (String str, String lookFor)
      • RemoveChars (String str, String charsToRemove)
      • SplitString (String str, String separator1, String separator2)
    • Date Time
    • Files
    • Date Time With Offset
    • GUID
    • Encoding
    • Regular Expressions
    • TimeSpan
    • Matching
    • User Guide
    • Report Model Interface
    • Use Cases
    • Exporting Options
    • Miscellaneous
    • Project Management
    • Job Scheduler
    • Configuring Google Drive API through REST Client in Astera
    • Connecting to Eloqua using Astera REST API
    • POSTing Data Using the REST Client
    • Using the REST Client to Download a Text File
    • Lineage and Impact Analysis
    • Setting Up Oracle ODP.Net Connectivity in Astera
    • Running Microsoft Access Database Engine with Astera
    • Oracle Client Tools Setup
    • Oracle Data Load Options
    • Job Trace Improvements
    • SmartMatch Feature
    • Synonym Dictionary File
    • Using the Data Source Browser in Astera
    • Astera Best Practices - Dataflows
    • Cardinality Errors FAQs
    • Overview of Cardinality in Data Modeling
Powered by GitBook
  1. Functions

String

Center (String)Chr (IntAscii)Asc (String)AddCDATAEnvelopeConcatenate (String)ContainsAnyChar (String)Contains (String)Compact (String)Find (Int64)EndsWith (String)FindIntStart (Int32)Extract (String)GetFindCount (Int64)FindLast (Int64)GetDigits (String)GetLineFeedInsert (String)IsAlphaGetTokenIndexOfIsBlankIsLowerIsUpperIsSubstringOfLength (String)LeftOf (String)Left (String)IsValidNameMid (String)PadLeftMid (String Chars)LSplit (String)PadRightReplaceAllSpecialCharsWithSpaceRemoveChars (String str, StringCharsToRemove)ReplaceLastRightAlignReverseRight (String)RSplit (String)SplitStringMultipleRecordsSplitStringMultipleRecords (2 Separators)SplitString (3 separators)SplitStringSplitStringMultipleRecords (3 Separators)TrimSubString (NoOfChars)StripHtmlTrim (Start)TrimExtraMiddleSpaceTrimEndPascalCaseWithSpace (String str)Trim (String str)ToLower(String str)ToProper(String str)ToUpper (String str)Substring (String str, Integer startAt)StartsWith (String str, String value)RemoveAt (String str, Integer startAt, Integer noofChars)Proper (String str)Repeat (String str, Integer count)ReplaceAll (String str, String lookFor, String replaceWith)ReplaceFirst (String str, String lookFor, String replaceWith)RightOf (String str, String lookFor)RemoveChars (String str, String charsToRemove)SplitString (String str, String separator1, String separator2)
PreviousSYDNextCenter (String)

© Copyright 2026, Astera Software