onyxfish/README.md

## README.md

      
    Raw
  

              README.md
            
          
    This script for Google Spreadsheets allows you to generate slugs for your data such as might be used for creating unique urls.
Use it like this!


#
A
B
C


1
a
b
slug


2
foo
baz bing
=slugify(A2:B4)


3
bar
BAZ


4
FOO
baz-bing


And you get this!


#
A
B
C


1
a
b
slug


2
foo
baz bing
foo-baz-bing


3
bar
BAZ
bar-baz


4
FOO
baz-bing
foo-baz-bing-2


## slugify.js
function slugify(values) {
  /*
   * Convert the the vs in a range of cells into slugs.
   */
  slugs = [];

  for (var row = 0; row < values.length; row++) {
    var bits = [];

    for (var column = 0; column < values[row].length; column++) {
      var value = values[row][column];

      value = value.toLowerCase();
      value = value.replace(/[^\w\s-]/g, '');
      value = value.replace(/\s+/g, '-');

      bits.push(value);
    }

    var base = bits.join('-');

    var i = 1;
    var slug = base;

    while (slugs.indexOf(slug) >= 0) {
      i++;
      slug = base + '-' + i;
    }

    slugs.push(slug);
  }

  output = [];

  for (var s = 0; s < slugs.length; s++) {
    output.push([slugs[s]]);
  }

  return output;
}

function test() {
  /*
   * Test the slugify function.
   */
  var TESTS = [
    ['foo', 'baz bing'],
    ['bar', 'BAZ'],
    ['FOO', 'baz-bing']
  ];

  var RESULTS = [
    'foo-baz-bing',
    'bar-baz',
    'foo-baz-bing-2'
  ];

  var output = slugify(TESTS);

  for (var t = 0; t < TESTS.length; t++) {
    var test = TESTS[t];
    var result = RESULTS[t];

    Logger.log("[" + test + "] == " + result);
    Logger.log((output[t][0] == result) + " ... " + output[t][0]);
  }
}
#	A	B	C
1	a	b	slug
2	foo	baz bing	foo-baz-bing
3	bar	BAZ	bar-baz
4	FOO	baz-bing	foo-baz-bing-2
	function slugify(values) {
	/*
	* Convert the the vs in a range of cells into slugs.
	*/
	slugs = [];

	for (var row = 0; row < values.length; row++) {
	var bits = [];

	for (var column = 0; column < values[row].length; column++) {
	var value = values[row][column];

	value = value.toLowerCase();
	value = value.replace(/[^\w\s-]/g, '');
	value = value.replace(/\s+/g, '-');

	bits.push(value);
	}

	var base = bits.join('-');

	var i = 1;
	var slug = base;

	while (slugs.indexOf(slug) >= 0) {
	i++;
	slug = base + '-' + i;
	}

	slugs.push(slug);
	}

	output = [];

	for (var s = 0; s < slugs.length; s++) {
	output.push([slugs[s]]);
	}

	return output;
	}

	function test() {
	/*
	* Test the slugify function.
	*/
	var TESTS = [
	['foo', 'baz bing'],
	['bar', 'BAZ'],
	['FOO', 'baz-bing']
	];

	var RESULTS = [
	'foo-baz-bing',
	'bar-baz',
	'foo-baz-bing-2'
	];

	var output = slugify(TESTS);

	for (var t = 0; t < TESTS.length; t++) {
	var test = TESTS[t];
	var result = RESULTS[t];

	Logger.log("[" + test + "] == " + result);
	Logger.log((output[t][0] == result) + " ... " + output[t][0]);
	}
	}