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

//A very simple example of transorming data from input to output // //Any text in the input editor is transfered to the variable input when the transform is run //The value of output when the transform finished is transfered to the output editor //In this simple example " some text" is appended to the input data output = input + " some text"; //Add a message to the log print("I've finished");

//An example of transorming data from a json document //An example json input input = '{ "a": 123, "b": 234 }'; //Parse the input data into a json object var json = JSON.parse( input ); //Set the output as the values a and b output = json.a + " , " + json.b + "\n\n"; //Append the json as a pretified string output += JSON.stringify( json, null, 4 ); //Add a message to the log print("I've finished");

//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");

output = input + " some text";

//An example of transorming data from a csv //Comment out or remove this if you have valid a csv file in the input editor input = "a,b,c\n1,2,3\n4,5,6"; //Separate the csv rows var rows = input.split("\n"); var DELIMITER = ","; //Use "\t" for tab separated output = ""; print("Rows:" + rows.length); for(var r in rows) { //Ignore the title row if( r==0 ) continue; //Separate each row into a row of cells var cells = rows[r].split(DELIMITER); //Create a list of cells for(var c in cells) { output += cells[c] + " : "; } } //Add a message to the log print("I've finished");

//Split into lines var lines = input.split("\n"); //Sort alphabetically lines = lines.sort(); //Count repeated lines var unique = {}; for(var l in lines) { if( unique[ lines[l]] ) { unique[ lines[l] ] ++; } else { unique[ lines[l] ] = 1; } } //Display unique lines followed by a count of repeats for(var u in unique) { output += u + " : " + unique[u] + "\n"; } //Add a message to the log print("I've finished");