How to Encode Column Data as Base64

HowTo
#1

What You Want to Do

I want to encode the string data in a column as Base64.

Solution

For example, to encode string data in a “name” column as Base64 in Exploratory, follow these steps:

  1. Add a Create Calculation step.
  2. Enter the following code in the Calculation Editor:
    sapply(name, function(x) base64enc::base64encode(charToRaw(x)))
  3. Run the calculation and check the encoded results.

By following these steps, you can successfully encode the string data in a specified column as Base64.