| Excerpt |
|---|
Converts an input base64 value to text. Output type is String. |
- base64 is a method of representing data in a binary format over text protocols. During encoding, text values are converted to binary values 0-63. Each value is stored as an ASCII character based on a conversion chart.
Typically, base64 is used to transmit binary information, such as images, over transfer methods that use text, such as HTTP.
| Info |
|---|
NOTE: base64 is not an effective method of encryption. |
- For more information on base64, see https://en.wikipedia.org/wiki/Base64.
Column reference example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:base64decode(mySource) |
|---|
|
base64decode(mySource) |
Output: Decodes the base64 values from the mySource column into text.
String literal example:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:base64decode('GVsbG8sIFdvcmxkLiA=') |
|---|
|
base64decode('GVsbG8sIFdvcmxkLiA=') |
Output: Decodes the input value to the following text: Hello, World. .
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:base64decode(column_string) |
|---|
|
base64decode(column_string) |
| Argument | Required? | Data Type | Description |
|---|
| column_string | Y | string | Name of the column or string literal to be applied to the function |
column_string
Name of the column or string constant to be converted.
- Missing string or column values generate missing string results.
- String constants must be quoted (
'Hello, World'). - Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal or column reference | myColumn |
Example - base64 encoding and decoding
| Include Page |
|---|
| EXAMPLE - Base64 Encoding Functions |
|---|
| EXAMPLE - Base64 Encoding Functions |
|---|
|
