Strings Transformation Functions - Page 1

String transformation functions in Advanced ETL Processor allow you to clean, extract, modify, format, and manipulate text values during data transformation. Use these functions to split and combine strings, remove or replace characters, work with prefixes and suffixes, extract values, clean unwanted spaces, and perform other common text processing operations.

Download Advanced ETL Processor

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

After

This function returns string after value

Before

This function returns string before value

Count Delimited Values

This function Counts delimited values within the string

Count String

This function Count String occurrences within the string

Deduplicate Delimited Values

This function Deduplicates delimited values within the string

Delete

This function deletes part of a string

Delete Characters

This function Deletes specified characters from the string

Delete Leading Characters

This function Deletes specified leading characters from the string

Delete Spaces

This function makes sure that there is only one space between words

Delete Trailing Characters

This function deletes specified trailing characters from the string

Ensure No Prefix

Check string for prefix and if it is present removes it

Ensure No Suffix

Check string for suffix and if it is present removes it

Ensure Prefix

Check string for prefix and if it is missing adds it

Ensure Suffix

Checks string for suffix and if it is missing adds it

Escape String

This function replaces special characters such as TAB, CR, LF,NULL,BEL,BS,ESC,HT,FF,VT with there C-Style escape equivalents

www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License