csv to where sublime plugin

custom-commands.sublime-commands

[
	{"caption": "CSV to Where", "command": "format_as_where"}
]

format_as_where.py

import sublime
import sublime_plugin


class FormatAsWhereCommand(sublime_plugin.TextCommand):
	def run(self, edit):
		# return a list with all lines of the current file
		lines = self.view.lines(sublime.Region(0, self.view.size()))
		# join lines as strings with comma and space
		text = "IN ('" + "', '".join([self.view.substr(line) for line in lines]) + "')"
		# replace the content of the current file with the formatted text
		self.view.replace(edit, sublime.Region(0, self.view.size()), text)