This example demonstrates how to convert an input string to a base64-encoded value and back to ASCII text strings.
Functions:
| Item | Description |
|---|---|
| BASE64ENCODE Function |
Converts an input value to base64 encoding with optional padding with an equals sign (=). Input can be of any type. Output type is String.
|
| BASE64DECODE Function | Converts an input base64 value to text. Output type is String. |
Source:
The following example contains three columns of different data types:
| IntegerField | StringField | ssn |
|---|---|---|
| -2082863942 | This is a test string. | 987654321 |
| 2012994989 | "Hello, world." | 987654322 |
| -1637187918 | "Hello, world. Hello, world. Hello, world." | 987654323 |
| -1144194035 | fyi | 987654324 |
| -971872543 | 987654325 | |
| 353977583 | This is a test string. | 987-65-4321 |
| -366583667 | "Hello, world." | 987-65-4322 |
| -573117553 | "Hello, world. Hello, world. Hello, world." | 987-65-4323 |
| 2051041970 | fyi | 987-65-4324 |
| 522691086 | 987-65-4325 |
Transformation - encode:
You can use the following transformation to encode all of the columns in your dataset:
| Transformation Name | Edit column with formula |
|---|---|
| Parameter: Columns | All |
| Parameter: Formula | base64encode($col, true) |
Results - encode:
The transformed dataset now looks like the following. Note the padding (equals signs) at the end of some of the values. Padding is added by default.
| IntegerField | StringField | ssn |
|---|---|---|
| LTIwODI4NjM5NDI= | VGhpcyBpcyBhIHRlc3Qgc3RyaW5nLg== | OTg3NjU0MzIx |
| MjAxMjk5NDk4OQ== | IkhlbGxvLCB3b3JsZC4i | OTg3NjU0MzIy |
| LTE2MzcxODc5MTg= | IkhlbGxvLCB3b3JsZC4gSGVsbG8sIHdvcmxkLiBIZWxsbywgd29ybGQuIg== | OTg3NjU0MzIz |
| LTExNDQxOTQwMzU= | Znlp | OTg3NjU0MzI0 |
| LTk3MTg3MjU0Mw== | OTg3NjU0MzI1 | |
| MzUzOTc3NTgz | VGhpcyBpcyBhIHRlc3Qgc3RyaW5nLg== | OTg3LTY1LTQzMjE= |
| LTM2NjU4MzY2Nw== | IkhlbGxvLCB3b3JsZC4i | OTg3LTY1LTQzMjI= |
| LTU3MzExNzU1Mw== | IkhlbGxvLCB3b3JsZC4gSGVsbG8sIHdvcmxkLiBIZWxsbywgd29ybGQuIg== | OTg3LTY1LTQzMjM= |
| MjA1MTA0MTk3MA== | Znlp | OTg3LTY1LTQzMjQ= |
| NTIyNjkxMDg2 | OTg3LTY1LTQzMjU= |
Transformation - decode:
The following transformation can be used to decode all of the columns:
| Transformation Name | Edit column with formula |
|---|---|
| Parameter: Columns | All |
| Parameter: Formula | base64decode($col) |
Results - decode:
| IntegerField | StringField | ssn |
|---|---|---|
| -2082863942 | This is a test string. | 987654321 |
| 2012994989 | "Hello, world." | 987654322 |
| -1637187918 | "Hello, world. Hello, world. Hello, world." | 987654323 |
| -1144194035 | fyi | 987654324 |
| -971872543 | 987654325 | |
| 353977583 | This is a test string. | 987-65-4321 |
| -366583667 | "Hello, world." | 987-65-4322 |
| -573117553 | "Hello, world. Hello, world. Hello, world." | 987-65-4323 |
| 2051041970 | fyi | 987-65-4324 |
| 522691086 | 987-65-4325 |
This page has no comments.