Data Magic

gibney.org : Technology : Javascript : Tools : Data Magic

(Entry Nr. 60, by user 1 | edit)

<br>
<style>
 .part
 {
  border: 1px solid #808080;
  width : 100%;
  height: 80%;
 }
</style>

function getDataAsString()
{
 return document.getElementById("data").value;
}

function getData()
{
 var Part1 =document.getElementById("data").value;
 var Lines=Part1.split("\n");
 var Data=new Array();
 for (i=0;i<Lines.length;i++)
 {
  Start=Lines[i].indexOf("\t");
  Key  =Lines[i].substr(0,Start);
  Value=Lines[i].substr(Start+1);
  Data[Key]=Value; 
 }
 return Data;
}

function getDataAs2dArray()
{
 var Data=getDataAsNrKeyString();

var r=new Array();
 for (y in Data)
 {
  var Fields=Data[y]["value"].split("\t");
  if (!r[y]) r[y]=new Array();
  r[y][0]=Data[y]["key"];
  for (x=0;x<Fields.length;x++)
  {
   r[y][x+1]=Fields[x];
  }
 }
 return r;
}

function setData(Data)
{
 var Output=document.getElementById("data");
 Output.value=Data;
}

function setDataFromKeyValue(Data)
{
 r="";
 for (key in Data) r+=key+"\t"+Data[key]+"\n";
 var Output=document.getElementById("data");
 Output.value=r;
}

function setDataFromKeyValues(Data2d)
{
 Data="";
 for (y in Data2d)
 {
  Data+=y+"\t";
  for (x=0;x<Data2d[y].length;x++)
  {
   Data+=Data2d[y][x]+"\t";
  }
  Data+="\n";
 }
 setData(Data);
}

</script>

combine by key Apply Padd later unknown keys

sum by key Apply

Interprets the first column as key and the following columns as numeric values. Then calculates the sums of the columns for each key.

URLdecode Apply

Wrap Characters: Apply

URLencode Apply

Javascript Execute

Create a new entry at this position