How To Use String Manipulation Pad

STEP 1. Copy String Data From Your Data Source

You can copy data from Excel, Text Editor, SQL Data Tools, etc.


STEP 2. Paste Data To String Manipulation Pad

Use Ctrl+V (or context menu) to paste your data into String Pad.


STEP 3. Use String Pad Buttons

Use Buttons To Manipulate String Data. Everytime you click manipulation button,
new string manipulation will be applied onto the string data.

At the example below, user clicked #1 button which enclosed each word with
single quotes and then clicked #2 which added comma prefix to each data.


String Manipulation Buttons

Merge to One Line
Merge multiple lines to one line.
Split to Multi-Lines
Split string data by comma, tab, or | character and put them to multiple lines.
Enclose Buttons
String text is enclosed by single quote or double quotes. This can be applied to each word or each line.
For example, if you comma separate data and want to add single quotes to each word, use [Enclose Word with ' '] button.
Prefix Buttons
Prefix comma, tab, or a space character to the begining of the string in each line.
Postfix Buttons
Postfix comma, tab, or a space character to the end of the string in each line.
Trim Buttons
Trim left, right, or both side of the string in each line.
Replace Buttons
Replace tab with comma, or replace comma with tab.
Remove Buttons
Remove all spaces, tabs, or blank lines from the string.
HTML Encoding
Convert string to HTML encoded string.
HTML Decoding
Convert HTML encoded string back to original string.
URL Encoding
Convert string to URL encoded string.
URL Decoding
Convert URL encoded string back to original string.
Clear
Clear all string. This is typically used when you want to restart string manipulation with new data.
Reset
When string is pasted into textbox, it is stored internally. If you click Reset, String Pad will revert all your actions and reset to original string.
Undo
Undo will cancel the last action and revert back to previous string. This is used when you don't like last edit.
Count
Calculate character count, word count, and line count.
Upper
Change all text to uppercase.
Lower
Change all text to lowercase.
Proper
Change text to proper case (title case). First charcter of word will be changed to uppercase and others become lowercase.
Reverse
Reverse string.
Quick SQL Builder: To IN Clause (chars)
Convert input text to SQL IN clause in char/varchar string format. For example, if ABC and DEF are entered in each line, output will be IN ('ABC', 'ABC')
Empty line or any trailing spaces will be automatically removed.
Quick SQL Builder: To IN Clause (nchars)
Convert input text to SQL IN clause in nchar/nvarchar string format. For example, if ABC and DEF are entered in each line, output will be IN (N'ABC', N'ABC')
Empty line or any trailing spaces will be automatically removed.
Quick SQL Builder: To IN Clause (numbers)
Convert input text to SQL IN clause in number format. For example, if 123 and 456 are entered in each line, output will be IN (123, 456)
Empty line or any trailing spaces will be automatically removed.

Goto String Pad