Being relatively new to this, I'll dive straight into the problem I need help with:
I need to transform this: "cat@dog%arm@hand%tree@apple...
"
into something like this:
cat | dog
arm | hand
tree| apple
..etc
While isolating the strings is not an issue, manipulating them into a 2D array or two columns in a spreadsheet has proven to be challenging.
Here's one approach that I've tried: `
function key_abb(input) {
if(input.map) {
return input.map(key_abb);
}else {
var temp = input.toString();
temp = temp.replace("abbreviated-name=", "");
temp = temp.replace("name=", "");
return temp;
}
}`
input represents data formatted in the following way:
|abbreviated-name="cat" name="dog" |
|abbreviated-name="arm" name="hand" |...
Despite attempting this solution, I'm still only getting both strings within the same column. The only achievement so far is removing the extra text. I'm unsure how to create the desired output array. Appreciate any assistance on this matter!