Astera Data Stack
Ctrlk
  • Welcome to Astera Data Stack Documentation
  • Release Notes
    • Upgrading from Astera 5.1 to 6.0
  • Getting Started
    • Introduction to Astera 6 Webinar Video
  • Dataflows
    • Introducing Dataflows
    • Dataflow Examples
    • Parameterizing Dataflows
    • Sources
    • Transformations
    • Destinations
    • Maps
    • Data Logging and Profiling
    • Database Write Strategies
  • Workflows
    • Adding Workflow Tasks
    • Creating Workflows
    • Customizing Workflows With Parameters
    • Using Workflow Designer
  • Subflows
    • Using Subflows in Astera
  • Report Model
    • Report Model Tutorial
    • Applying an Existing Model to a New Report
    • Using Report Models to Extract Business Information from Printed Documents
  • Functions
    • Introducing Function Transformations
    • Functions Glossary
    • 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
  • Integration Server
    • Job Scheduling
  • Miscellaneous
    • Astera API User Guide
    • Astera Best Practices Dataflows
    • Astera Options
    • Astera Webinar Series
    • MySQL date/time conversion error
    • Report Model Monthly Online Training
    • Server Command Line Utility
    • Shared Actions
    • Shared Connections
    • Working with Data Formats
    • Using the Data Source Browser
    • Using the Query Editor
Powered by GitBook
On this page
  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 2025, Astera Software