Skip to main content

Appendix B: Supported Functions

Build-in Functions by Category​

At present, DPL Studio provides altogether 166 built-in funtions in 20 different categories for use in creating queries. To locate more information on existing functions, locate the desired category of functions, then select the desired function to obtain information on its usage and syntax.

Files And Directories functions (3)​

1.GetFileList

2.LoadBinaryData

3.LoadTextData

Mathematical functions (21)​

  1. Abs

  2. ACos

  3. ASin

  4. ATan

  5. ATan2

  6. Ceiling

  7. Cos

  8. Cot

  9. Counter

  10. Exp

  11. Floor

  12. Ln

  13. Log

  14. Log10

  15. PI

  16. Power

  17. Round

  18. Sin

  19. Sqrt

  20. Square

  21. Tan

Statistical functions (12)​

  1. Average

  2. CAverage

  3. Count

  4. Guid

  5. Max

  6. Min

  7. Pearson

  8. PrecisionSum

  9. Rand

  10. StDevP

  11. Sum

  12. VarP

Logical functions (12)​

  1. Between

  2. In

  3. IsDate

  4. IsFloat

  5. IsInt

  6. Like

  7. IsNull

  8. IsEmpty

  9. IsNullOrEmpty

  10. Switch

  11. IsEven

  12. IsOdd

String functions (26)​

  1. Char

  2. CharIndex

  3. Delimited Text

  4. Left

  5. Len

  6. Lower

  7. LTrim

  8. Mid

  9. Proper

  10. RegexFind

  11. RegexParse

  12. RegexReplace

  13. Replace

  14. Rept

  15. Reverse

  16. Right

  17. RTrim

  18. Space

  19. Split

  20. Substitute

  21. Trim

  22. TrimTable

  23. Upper

  24. Concat

  25. Encrypt

  26. Decrypt

Data Profiling functions (6)​

  1. DbTableMetadata

  2. FixSMTPAddress

  3. FindDuplicateRows

  4. RemoveDuplicateRows

  5. TableMetadata

  6. TextSearch

Format functions (3)​

  1. CultureFormat

  2. Format

  3. SysCultureFormat

Date and Time functions (10)​

  1. Date

  2. Day

  3. DateAndTime

  4. Hour

  5. Minute

  6. Month

  7. Second

  8. Time

  9. Weekday

  10. Year

Conversion functions (24)​

  1. Complement9

  2. DateValue

  3. DecodeBytes

  4. EncodeBytes

  5. FromEbcdic

  6. FromIBMSigned

  7. FromPackedDecimal

  8. LocalToUtc

  9. ParseCurrency

  10. ToDate

  11. ToBytes

  12. ToDecimal

  13. ToDouble

  14. ToEbcdic

  15. ToFloat

  16. ToGregorianDate

  17. ToInt

  18. ToIBMSigned

  19. ToJulianDate

  20. ToLong

  21. ToPackedDecimal

  22. ToShort

  23. ToString

  24. UtcToLocal

Approximate String Matching functions (2)​

  1. DoubleMetaphone

  2. Soundex

Transform functions (24)​

  1. AddColumn

  2. AddLookupColumn

  3. AddRow

  4. Filter

  5. InmemoryLookup

  6. InMemoryTable

  7. LoadFile

  8. LookUp

  9. Next

  10. Previous

  11. Rank

  12. Select

  13. SelectRange

  14. SelectRow

  15. SelectValue

  16. Sort

  17. Transpose

  18. AppendTable

  19. AppendTableOnNames

  20. Unique

  21. MissingValues

  22. RunSQL

  23. SplitTextInColumns

Financial functions (5)​

  1. FV

  2. NPV

  3. PMT

  4. PV

  5. SLN

Environmental functions (3)​

  1. Expand

  2. Now

  3. Today

Phone Number Quality Functions (1)​

  1. PhoneCanonical

SAP Business One Functions (2)​

  1. SBOUserDefinedFields

  2. SBOSplitAddress

Table Comparision Functions (3)​

  1. FindChangedRecords

  2. FindNewRecords

  3. FindChangedFields

Identifier Management (1)​

  1. GetUniqueIdentifier

XML Functions (1)​

  1. XslTransform

Persistent Storage Functions (2)​

  1. PersistentStore

  2. PersistentRetrieve