Web Journal!

categories="('" & replace(replace(categories,", ",","),",","','") & "')"

Or the same thing made a little less comprehensible:

categories="('"&replace(replace(categories,", ",","),",","','")&"')"

I recognized it as mine own, and it took me a while to decipher what exactally is going on. Well, all you coders out there, enjoy!

For you non-coders, here is what it does: It takes a string (a bunch of letters, numbers; text) and removes the spaces after all commas, then it puts single quotes (') before and after the commas, and then prepends the string with (' and appends ') to the string. This was used to take a comma separated list and converted it into a form usable for an SQL query; in other words, it would convert:

this, that, another thing,and,any, other words

into:

('this','that','another thing','and','any','other words')