Transformation functions

2024

Accumulate Strings

2023

If Null
If Null Or Empty String
IP Location
URL Location
Subtract
Get Excel Cell Value
Get Excel Cell Value Dynamic
Replace Characters
Decode JSON Array
Decode JSON Object
Decode JSON Pair
Decode JSON String
Encode JSON Array
Encode JSON Object
Encode JSON Pair
Encode JSON String
If Algerian Post Code
If Andorran IBAN
If Andorran Post Code
If Argentinian Post Code
If Australian Mobile Number
If Australian Phone Number
If Australian Post Code
If Austrian Mobile Phone Number
If Azerbaijani Post Code
If Bahraini Post Code
If Bangladeshi Post Code
If Belarusian Post Code
If Belgian Post Code
If Belgian VAT Number
If Brunei Post Code
If Canadian Branch-Transit/ Bank code
If Canadian Provincial Code
If Canadian Social Insurance Number
If Canadian Zip Code
If Chilean Post Code
If Credit Card
If Croatian Post Code
If Cyprus Post Code
If Cyprus VAT Number
If Czech Republic IBAN
If Czech Republic VAT Number
If Danish Civil Registration Number
If Danish Phone Number
If Danish Post Code
If Danish VAT Number
If Dutch Car Number Plate
If Dutch Phone Number
If Dutch Post Code
If Egyptian Post Code
If Email
If Estonian Post Code
If Estonian VAT Number
If Ethiopian Post Code
If Faroe Islands Post Code
If File Name
If Finnish VAT Number
If French Phone Number
If French Polynesia Post Code
If French Post Code
If French VAT Number
If German Car License Plate
If German IBAN
If German Post Code
If German VAT Number
If Greek VAT Number
If Guadeloupe Post Code
If Guinea-Bissau Post Code
If Guinean Post Code
If Hungarian VAT Number
If Indian Mobile Number
If Indian Phone Number
If Indian Post Code
If Indian Vehicle Registration Number
If IP Address V4
If IP Address V6
If Irish VAT Number
If ISBN 10
If ISBN 13
If Israeli Mobile Phone Number
If Israeli Phone Number
If Italian IBAN
If Italian Mobile Number
If Italian Phone Number
If Italian Post Code
If Italian VAT Number
If Latvian VAT Number
If Lithuanian VAT Number
If Luxembourg VAT Number
If Maltese VAT Number
If Matches Regular Expression
If Netherlands VAT Number
If Peru Cellular Number
If Peru Phone Number
If Polish IBAN
If Polish VAT Number
If Portuguese VAT Number
If Russian Phone Number
If Russian Post Code
If Slovakian IBAN
If Slovakian VAT Number
If Slovenian VAT Number
If South African Company Number
If South African Mobile Number
If South African Phone Number
If South African VAT Number
If Spanish IBAN
If Spanish Phone Number
If Spanish Post Code
If Spanish VAT Number
If Swedish IBAN
If Swedish Person Number
If Swedish Phone Number
If Swedish Post Code
If Swedish VAT Number
If Swiss Mobile Number
If Swiss Phone Number
If Swiss Post code
If UK Bank Sort Code
If UK Driver License
If UK Mobile Number
If UK National Insurance Number
If UK Phone Number
If UK Post Code
If UK Vat Number
If UK Vehicle Registration Number
If UNC
If URL
If US or CA Zip code
If US Phone Number
If US Social Security Number
If US State
If US Zip Code
Replace RegX
Split RegX Dynamic
Split RegX Static

2022

Abs
Add
After
Before
Calculation
Case Transformation
Checksum
Command Line Parameter
Compare Values
Concatenate
Current Date
Decode Base 64
Decode HTML
Decode HTTP
Decode XML Attribute
Decode XML Element
Decode XML String
Delete
Delete Characters
Delete Leading Characters
Delete Spaces
Delete Trailing Characters
Directory Name
Divide
Encode Base 64
Encode HTML
Encode HTTP
Encode XML Element
Encode XML String
Ensure No Prefix
Ensure No Suffix
Ensure Prefix
Ensure Suffix
Epoch to Date
Escape String
Field Value
File Name
First Up
Get File Content
Get File Content Dinamic
Get Line
Get Package Variable
Get Variable
GUID
HTTP Get
HTTP Post
If 1st Quarter, If 2nd Quarter, Is 3rd Quarter, Is 4th Quarter, Is Current Quarter, Is Last Quarter, Is Next Quarter
If Alpha
If Alpha Numeric
If AM
If Contains
If Current Week, If Last Week, If Next Week
If Date
If Date Between
If Date Less Than
If Date More Than
If Empty String
If Ends With
If Equal To
If Hex
If Hour 12
If Hour 24
If Integer
If January, If February, If March, If April, If May, If June, If July, If August, Is September, If October, If November, If December, If Current Month, If Last Month, If Next Month
If Leap Year, If Current Year, If Last Year, If Next Year
If Minute
If Monday, If Tuesday, If Wednesday, If Thursday, If Friday, If Saturday, If Sunday, If Today, If Yesterday, If Tomorrow, If Weekend, If Weekday
If Negative
If Number
If Number Between
If Number Less
If Number More Than
If PM
If Positive
If Second
If Starts With
If Time
If Time Between
If Time Less Than
If Time More Than
If Valid XML
If Value in the database
If Within Past Minutes, If Within Past Hours, If Within Past Days, If Within Past Weeks, If Within Past Months
In Place Replace
Keep Characters
Keep Value
Left
Left Delete
Left Pad
Left Trim
Length
Literal
Lower Case
Metadata
Multiply
Previous Value
Proper Case
Random Number
Replace
Right
Right Delete
Right Pad
Right Trim
Round
Running Total
Sequence
Set Package Variable
Set Variable
Sign
Split
Sub String
Sub Transformation
Trim
UnEscape String
Upper Case
User
XML XSLT Transformation
Lookup
Lookup Replace
Range Lookup
SQL Lookup
Change Date
Change Date Dynamic
Date Diff
Date Format
Date part
Date to Epoch
Local Date to UTC
Reformat Date
UTC to Local Date
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License