Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc

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.

D s lang vs sql

D s
snippetBasic

Column reference example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:base64decode(mySource)

base64decode(mySource)

Output: Decodes the base64 values from the mySource column into text. 

String literal example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:base64decode('GVsbG8sIFdvcmxkLiA=')

base64decode('GVsbG8sIFdvcmxkLiA=')

Output: Decodes the input value to the following text: Hello, World.

D s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:base64decode(column_string)

base64decode(column_string)


ArgumentRequired?Data TypeDescription
column_stringYstringName of the column or string literal to be applied to the function

D s lang notes

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.

D s
snippetusage

Required?Data TypeExample Value
YesString literal or column referencemyColumn


D s
snippetExamples

Example - base64 encoding and decoding

Include Page
EXAMPLE - Base64 Encoding Functions
EXAMPLE - Base64 Encoding Functions

D s also
labelstring