Open Tool Menu: Open tools in new window. Add Prefix/Suffix into Each Text Line Add/Remove Line Breaks ASCII, Binary, Hex, Unicode Converter Baby Name Combination Generator Compare Text Lines Count Characters, Words, Lines Delimited Column Extractor Tool Generate List of Numbers Homepage - Index Letter Case Converter Merge Text (Line by Line) Number Each Text Line Permutation Generator Random Baby Name Generator Random Line Picker Random Number Generator Random String Generator Remove Duplicate Lines Remove Empty Lines Remove Letter Accents Remove Lines of Text Containing ... Reverse Text Generator Sort Text Lines Webpage Color Picker

Delimited Column Extractor Tool

This online tool will extract a specific column of delimited text from each line of your input text.  NOTE: Javascript must be enabled.

Extract column #

Colums are delimited by this text*

*Default of single space is pre-entered.

To use: Enter your input text here. Enter the column number to be extracted such as 1, 2, 3, etc. and what delimiter seperates the columns such as a space, comma, period, colon, letter, number, word, segment of html code, etc. The delimiter can be just about any text. No delimiter will make each of your text's character a column for extraction. A prefix and/or suffix may be added to each extracted item by entering into the appropriate input box. Add a new delimiter (if needed) with the suffix box. Empty boxes will produce no output. Click the "Extract Column" button and the specified cloumn of text will be loaded into the results box below. EXAMPLE: Test extracting each line's first word (cloumn #1, delimited by space) from this default text by clicking the "Extract Column" button now. You will see the first word from each line loaded into the results box below. Change the "Extract column #" box to 2, click the "Extract Column" button again and the second word from each line will appear below. Checking "Append" will continuously merge extracted columns into the end of each other which is useful to rearrange the delimited columns of your input text. e.g. To reverse input's column order, extract input's last column, then extract the next to last column, and so on. Now output's column order will be the reverse of input's. Be sure to add a new delimiter to the suffix box since input's delimiter will not be pass through the column extraction process. This simple tool has far too many complicated uses to elaborate on, so play with it (starting with the test example) and discover all it's uses. WARNING: A large amount of input text will be very slow to process and might cause your computer to become unresponsive. Privacy of Data: This tool is built-with and functions-in Client Side JavaScripting, so only your computer will see or process your data input/output.

Prefix output with

and/or suffix output with

Append new output to end of exisiting output.

Output will display here.

Toolbox: Add Prefix/Suffix into Each Text Line Add/Remove Line Breaks ASCII, Binary, Hex, Unicode Converter Baby Name Combination Generator Compare Text Lines Count Characters, Words, Lines Delimited Column Extractor Tool Generate List of Numbers Homepage - Index Letter Case Converter Merge Text (Line by Line) Number Each Text Line Permutation Generator Random Baby Name Generator Random Line Picker Random Number Generator Random String Generator Remove Duplicate Lines Remove Empty Lines Remove Letter Accents Remove Lines of Text Containing ... Reverse Text Generator Sort Text Lines Webpage Color Picker

The Text Mechanic's toolbox is full of helpful text manipulation tools! Tools provided "as-is" without warranty of any kind and used at your own risk. ©2010 TextMechanic.com