sanjujosh / string-quotter

Quote the strings for Oracle SQL automatically

String-Quotter

String-Quotter is a handy stand-alone tool to add quotes to SQL queries. Simply paste the string and hit the button. Processed output is copied to clipboard, ready to paste.

• Add quotes and comma around strings
• Option to prefix with zero
• Support varchar and numbers
• Automatically copy to clipboard, ready to paste.
• Output in one line or many lines.
• Stand-alone - no installation required.

Installation

Download the String-Quotter and run. No need to install it, it's portable software. Probably added it to the PATH for quick access.

What you get

Input Varchar:

one
two
three

Output:

(
 'one', 
 'two', 
 'three'
 )

Input Number:

1999
2999
3999

Output:

(
 1999, 
 2999, 
 3999
 )

Development

I have created this atrocity using Visual Studio 2010. Import the project to any version of VS with support for c#. This was created when I was drunk and depressed, be wary of potential bugs.

Update Nov 22

Minor improvements added based on my needs. Also rebuilt the software using Microsoft Visual Studio Community 2022 (64-bit)

License

MIT

string-quotter's Issues

Stop using Visual Studio 2010. It's too old! :p

Seriously bro?