Alex Poole

Pragmatic PHP, MySQL, Marketing & Technology

Alex Poole header image 2

De-dupe, clean and manipulate data columns quickly for 10 day cash secret or SEO

March 12th, 2008 by alex

I just read that some people who’d bought 10daycashsecret were having problems manipulating the data feeds. There are many ways to skin a cat, but people who want a simple tool for a simple job may find my De-Duplifier handy - it allows you to de-dupe, clean and manipulate columns of data easily.

I’d imagine, besides cleaning and munging data feeds for things like 10 day cash secret, it would be useful for preparing keyword lists for SEO / SEM. I’m sure there are other uses. 

Currently if offers the following:

  • De-duplicate rows
  • Remove blank rows
  • Make words lower case
  • Make words UPPER CASE
  • Make words Title Case
  • Trim whitespace left & right
  • Remove commas

Adding other similar features is pretty quick, so let me know what you’d find useful.

In the meantime I hope the tool is handy for you :)

Tags: 1 Comment

Leave a Comment

1 response so far ↓

  • I just added “prepend” and “append” fields, useful for adding commas (for building big SQL IN() clauses out of Excel columns, which is exactly why I just added it, come to think of it,) quote marks etc..