Coastal Technologies Group, Inc.

Serving Telecom Providers


OSSGate Supported Transformations



Data Transformations
  • Field Manipulation
    • Move Fields
    • Resize Fields
    • Add Fields
    • Split Fields
    • Combine Fields
    • Duplicate Fields
    • Support All Target DBMS Data Types
    • Support Null Data Type
    • Suport Logical Data Type
    • Set Decimal Scaling
  • Set Decimal Scaling
    • Set Precision
    • Set Signing Convention
    • Set Picture
    • Default Value/Expression
    • "must map" Condition
    • Field Locking/Security
Scrubbing & Cleansing
  • General String Parsing
  • Name Parsing
  • Address Parsing
  • City, State, Zip Parsing
  • Table Lookups for Validation
  • InputBox Function for User Cleansing via GUI
  • Default Data
  • Sorting
  • Dup Elimination
String Manipulation
  • Asc Function
  • Chr, Chr$ Functions
  • Format, Format$ Functions
  • InitCaps Function
  • Instr Function
  • LCase, LCase$ Functions
  • Left, Left$ Functions
  • LTrim Function
  • Mid (Substring), Mid$ Functions
  • Null
  • Parse (Unstring) Function
  • Right, Right$ Functions
  • RTrim Function
  • Space, Space$ Function
  • Str, Str$ Function
  • StrComp Function
  • String, String$ Functions
  • Trim, Trim$ Functions
  • UCase, UCase$ Functions
Math Functions
  • Operators ( -, +, *, /, ^ )
  • Abs Function
  • Fix Function
  • Int Function
  • Rnd Function
  • Sgn Function
  • Val Function
  • ValMask Function
  • CBool Function
  • CByte Function
  • Cdate Function
  • CDbl Function
  • Cint Function
  • CLng Function
  • CSng Function
Logarithmic Functions
  • Log Function
  • Log 10 Function
Date/Time Transformations
  • Date Calculations
  • Date Reformatting
  • Date Construction
  • Arbitrary Base Anchor Date
  • Custom Date Formats
  • Full Century Designation
  • Recognize String Dates
  • Julian Dates
  • Gregorian Dates
  • Packed/Binary Dates
  • Timestamping
  • 20+ Date/Time Functions
    • Date, Date$ Functions
    • DateAdd Function
    • DateConvert Function
    • DateDiff Function
    • DatePart Function
    • DateSerial Function
    • DateValMask Function
    • DateValue Function
    • Day Function
    • Hour Function
    • IsDate Function
    • Minute Function
    • Month Function
    • Now (Timestamp) Function
    • Second Function
    • Time, Time$ Functions
    • TimeSerial Function
    • TimeValue Function
    • Weekday Function
    • Year Function


All content contained herein, unless otherwise stated, is the sole Copyright © of Coastal Technologies Group, Inc, 2002.
All rights reserved.