Data Transformer - Quick Reference

The data transformer is intended take text from the input and transform it, then place it in the output. No data is shared or sent to our server unless you choose to save it. To do this you will need to have an Electric Llama Company account
To perform a data transformation, you have to do all the hard work, by writing Javascript in the code editor at the bottom of the screen.
The text in the input editor is made available as the variable input and the text in the output can be set by setting the output variable.
A number of useful transformer examples are given below to get you started.
If you have an Electric Llama Company account, you can save any transformers you have written for later use, alternatively each text editor has a download to desktop option.
You can drag and drop files into any of the editors on the transformer page.

Examples

//An example of transorming data from an xml document

//Comment out or remove this if you have valid xml in the input editor
input = "<a><b val=\"123\">345</b></a>";

//Generate an xml parser by reusing the javascript html dom parser
var parser = new DOMParser();

//Javascript is happier using json objects rather than xml
//This method converts an xml document string to a json object
function xmlStringToJson( data ) {
  //parse a string into an xml document object
  var xml = parser.parseFromString(data, "application/xml");
  //convert that object into json
  return xml2json(xml);
}

//Takes an xml document object and converts it into a json object
//It does not include any xml node parameters, so in the example string above
//val="123" will be ignored and only 345 included
function xml2json(xml) {
  try {
    var obj = {};
    if (xml.children.length > 0) {
      for (var i = 0; i < xml.children.length; i++) {
        var item = xml.children.item(i);
        var nodeName = item.nodeName;

if (typeof (obj[nodeName]) == "undefined") {
          obj[nodeName] = xml2json(item);
        } else {
          if (typeof (obj[nodeName].push) == "undefined") {
            var old = obj[nodeName];

obj[nodeName] = [];
            obj[nodeName].push(old);
          }
          obj[nodeName].push(xml2json(item));
        }
      }
    } else {
      obj = xml.textContent;
    }
    return obj;
  } catch (e) {
    console.log(e.message);
  }
}

var xml = xmlStringToJson( input );

output = JSON.stringify( xml, null, 4 );

//Add a message to the log
print("I've finished");

The Data Transformer has a few helper functions to make common actions easier.

These functions are provided by an instance of the DataTransformer or DT for short.

Often input data is based on a record per line.

DT.toLines( data, rowSeparator ) converts the data to an array of lines of text.

Returns a string array
If you don't supply data, it defaults to input
If you don't supply rowSeparator, it defaults to new line

DT.linesToString( lines, separator ) converts an array of lines to a string

lines should be an array of strings
If you don't supply separator, it defaults to new line

DT.forEachLine( fn, data) apply a function to each line of text in the data.

Returns an array of strings
If you don't supply data, it defaults to the input

DT.toTable(data, rowSeparator, cellSeparator);

Returns an array of arrays
If you don't supply rowSeparator, it defaults to new line
If you don't supply cellSeparator, it defaults to tab

DT.tableToString(table, rowSeparator, cellSeparator);

table should be an array or arrays
Returns a string
If you don't supply rowSeparator, it defaults to new line
If you don't supply cellSeparator, it defaults to tab

DT.NL the new line character

DT.TAB the tab character