Convert a single column list into an SQL IN statement, or alternatively a pipe-separated list which can be used with grep.

listmaker.sh

#!/bin/bash

export SEP_CHAR=""
export QUOTE_CHAR=""

test "$1" == "--grep" && export SEP_CHAR="|"
( test "$1" == "--sql" || test -z "$1" ) && export SEP_CHAR="," && export QUOTE_CHAR="'"

new_list=$( pbpaste | perl -e 'chomp(@lines = <STDIN>); print q{(} . join( $ENV{SEP_CHAR} => map { $ENV{QUOTE_CHAR} . $_ . $ENV{QUOTE_CHAR} } @lines ) . q{)}' )
echo $new_list | pbcopy
echo "$new_list"