Astera Data Stack
CtrlK
  • Welcome to Astera Data Stack Documentation
  • RELEASE NOTES
    • Astera 12.0 - Release Notes
  • SETTING UP
    • Express
    • Cloud
    • On Prem
  • Dataprep
    • Introduction to Dataprep
    • Getting Started with Astera Dataprep
    • Recipe Panel
    • Dataprep Profile Browser
    • Grid Central Preview
    • Reading Sources
    • Exporting Data
    • Transforming Data
    • Layout
    • Cleanse
    • Joins
    • Union
    • Lookup
    • Variables
    • Validate
  • Astera Intelligence
    • LLM Generate
    • Prompt Engineering Best Practices
    • Use Cases
  • DATAFLOWS
    • What are Dataflows?
    • Sources
    • Transformations
    • Destinations
    • Data Logging and Profiling
    • Database Write Strategies
    • Text Processors
    • Data Warehouse
    • EDI
  • WORKFLOWS
    • What are Workflows?
    • Creating Workflows in Astera
    • Decision
    • EDI Acknowledgment
    • File System
    • File Transfer
    • Or
    • Run Dataflow
    • Run Program
    • Run SQL File
    • Run SQL Script
    • Run Workflow
    • Send Mail
    • Workflows with a Dynamic Destination Path
    • Customizing Workflows With Parameters
    • GPG-Integrated File Decryption in Astera
    • AS2
  • Subflows
    • Using Subflows in Astera
  • DATA MODEL
    • Creating a Data Warehousing Project
    • Data Models
    • Dimensional Modelling
    • Data Vaults
    • Documentation
    • Deployment and Usage
  • REPORT MODEL
    • User Guide
    • Report Model Interface
    • Use Cases
    • Auto Generate Layout
    • AI Powered Data Extraction
    • Optical Character Recognition
    • Exporting Options
    • Miscellaneous
  • API Flow
    • API Publishing
    • API Consumption
  • SERVER APIS
    • Accessing Astera’s Server APIs Through a Third-Party Tool
  • Project Management and Scheduling
    • Project Management
    • Job Scheduling
    • Configuring Multiple Servers to the Same Repository (Load Balancing)
    • Purging the Database Repository
  • Data Governance
    • Deployment of Assets in Astera Data Stack
    • Logging In
    • Tags
    • Modifying Asset Details
    • Data Discoverability
    • Data Profile
    • Data Quality
    • Scheduler
    • Access Management
  • Functions
    • Introducing Function Transformations
    • Custom Functions
    • Logical
    • Conversion
    • Math
    • Financial
    • String
    • Date Time
    • Files
      • AppendTextToFile (String filePath, String text)
      • CopyFile (String sourceFilePath, String destFilePath, Boolean overWrite)
      • CreateDateTime (String filePath)
      • DeleteFile (String filePath)
      • DirectoryExists (String filePath)
      • FileExists (String filePath)
      • FileLength (String filePath)
      • FileLineCount (String filePath)
      • GetDirectory (String filePath)
      • GetEDIFileMetaData (String filePath)
      • GetExcelWorksheets (String excelFilePath)
      • GetFileExtension (String filePath)
      • GetFileInfo (String filePath)
      • GetFileName (String filePath)
      • GetFileNameWithoutExtension (String filePath)
      • LastUpdateDateTime (String filePath)
      • MoveFile (String filePath, String newDirectory)
      • ReadFileBytes (String filePath)
      • ReadFileFirstLine (String filePath)
      • ReadFileText (String filePath)
      • ReadFileText (String filePath, String codePage)
      • WriteBytesToFile (String filePath, ByteArray bytes)
      • WriteTextToFile (String filePath, String text)
    • Date Time With Offset
    • GUID
    • Encoding
    • Regular Expressions
    • TimeSpan
    • Matching
    • Processes
  • USE CASES
    • End-to-End Use Cases
  • CONNECTORS
    • Setting Up IBM DB2/iSeries Connectivity in Astera
    • Connecting to SAP HANA Database
    • Connecting to MariaDB Database
    • Connecting to Salesforce Database
    • Connecting to Salesforce – Legacy Database
    • Connecting to Vertica Database
    • Connecting to Snowflake Database
    • Connecting to Amazon Redshift Database
    • Connecting to Amazon Aurora Database
    • Connecting to Google Cloud SQL in Astera
    • Connecting to MySQL Database
    • Connecting to PostgreSQL in Astera
    • Connecting to Netezza Database
    • Connecting to Oracle Database
    • Connecting to Microsoft Azure Databases
    • Amazon S3 Bucket Storage in Astera
    • Connecting to Amazon RDS Databases
    • Microsoft Azure Blob Storage in Astera
    • ODBC Connector
    • Microsoft Dynamics CRM
    • Connection Details for Azure Data Lake Gen 2 and Azure Blob Storage
    • Configuring Azure Data Lake Gen 2
    • Connecting to Microsoft Message Queue
    • Connecting to Google BigQuery
    • Azure SQL Server Configuration Prerequisites
    • Connecting to Microsoft Azure SQL Server
    • Connecting to Microsoft SharePoint in Astera
  • Incremental Loading
    • Trigger Based CDC
    • Incremental CDC
  • MISCELLANEOUS
    • Using Dynamic Layout & Template Mapping in Astera
    • Synonym Dictionary File
    • SmartMatch Feature
    • Role-Based Access Control in Astera
    • Updating Your License in Astera
    • Using Output Variables in Astera
    • Parameterization
    • Connection Vault
    • Safe Mode
    • Context Information
    • Using the Data Source Browser in Astera
    • Pushdown Mode
    • Optimization Scenarios
    • Using Microsoft’s Modern Authentication Method in Email Source Object
    • Shared Actions
    • Data Formats
    • AI Automapper
    • Resource Catalog
    • Cloud Deployment
    • GIT In Astera Data Stack
    • Astera Best Practices
    • Switching Between Light and Dark Mode
  • FAQs
    • Installation
    • Sources
    • Destinations
    • Transformations
    • Workflows
    • Scheduler
Powered by GitBook
On this page

Was this helpful?

  1. Functions

Files

AppendTextToFile (String filePath, String text)CopyFile (String sourceFilePath, String destFilePath, Boolean overWrite)CreateDateTime (String filePath)DeleteFile (String filePath)DirectoryExists (String filePath)FileExists (String filePath)FileLength (String filePath)FileLineCount (String filePath)GetDirectory (String filePath)GetEDIFileMetaData (String filePath)GetExcelWorksheets (String excelFilePath)GetFileExtension (String filePath)GetFileInfo (String filePath)GetFileName (String filePath)GetFileNameWithoutExtension (String filePath)LastUpdateDateTime (String filePath)MoveFile (String filePath, String newDirectory)ReadFileBytes (String filePath)ReadFileFirstLine (String filePath)ReadFileText (String filePath)ReadFileText (String filePath, String codePage)WriteBytesToFile (String filePath, ByteArray bytes)WriteTextToFile (String filePath, String text)
PreviousDateToIntegerYYYYMMDD (Date dateTime)NextAppendTextToFile (String filePath, String text)

Was this helpful?

© Copyright 2025, Astera Software