ETL: Base64DecodeToString

Decode a Base64-encoded string directly into readable text with a specified character encoding. Use for text decoding in ETL data pipelines.

Description

Decodes a Base64 string into a string with specified encoding.

Syntax

Base64DecodeToString(string[, charset_expression])

Arguments

string - string_expression

charset_expression - string_expression indicating the encoding. The default is UTF-8. See the list of available character sets in https://docs.oracle.com/javase/7/docs/api/java/nio/charset/Charset.html.

Examples

Base64DecodeToString('aGVsbG8gd29ybGQ=','UTF-8') returns ‘hello world’

Notes

If the input expression is not a valid Base64 string, it will be ignored and an empty string will be returned.

Return value datatype

String

Impact of null value

If input is null, returns null.