Data Transformer - Quick Reference

DataTransformer Quick Reference

Transform text and data using JavaScript with visual editor

Key Features

Input/Output text editors
JavaScript transformation scripts
Helper functions for common operations
Live transformation execution
Example transformations included
No server-side data sharing

Helper Functions: // Convert data to lines var lines = DT.toLines(data, rowSeparator); // defaults: input, "\n" // Lines to string var str = DT.linesToString(lines, separator); // default separator: "\n" // Apply function to each line var result = DT.forEachLine(function(line) { return line.toUpperCase(); }, data); // Convert to table (2D array) var table = DT.toTable(data, rowSeparator, cellSeparator); // defaults: "\n", "\t" // Table to string var str = DT.tableToString(table, rowSeparator, cellSeparator); // Constants DT.NL // newline character DT.TAB // tab character Transformation Script: // Input text available as 'input' variable // Set 'output' variable with transformed result output = input.toUpperCase(); // Simple example The data transformer takes text from the input and transforms it using JavaScript, then places it in the output. No data is shared or sent to our server unless you choose to save it. 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");