Data Trimmermdi-hammer-wrenchToolboxColumn Data ComparisonData TrimmerDelimiter SeparatorExtra New Line RemoverJSON Formatter and ConverterOnline HTML EditorPrefix and Suffix ModifierURL Decoder and EncoderXML File Data ExtractorXSD File Data Extractormdi-menu-downmdi-informationAboutmdi-phone-classicContactToolboxColumn Data ComparisonData TrimmerDelimiter SeparatorExtra New Line RemoverJSON Formatter and ConverterOnline HTML EditorPrefix and Suffix ModifierURL Decoder and EncoderXML File Data ExtractorXSD File Data Extractormdi-facebookmdi-youtubemdi-redditmdi-twitter
Trims data by removing unwanted characters such as letters, numbers, spaces or symbols.
It can also be used to extract specific data from a set of data.
Usage
Input field for the left value of Range Slider.
Input field for the right value of Range Slider.
Range Slider is used for adjusting what data to remove or extract.
Menu for showing:
Strip Whitespace - Strip or remove the leading and trailing spaces.
Inverse - reverse the data display. The selected area will be removed and the rest will be merged and displayed.
Button for trimming the data.
Button to clear all the content in the left panel area.
Button to select all the content in the right panel area.
Button to clear all the content in the right panel area.
Left panel area for data input.
Right panel area for processed data.
How to trim a data
Copy and paste data on left panel(9) as shown on the screenshot.
Use the Range Slider(3) and adjust to specifc range by moving the left and right points.
The dropdown menu(4) allows to remove leading and trailing spaces or reverse the result.
Click the Trim button(5).
Check the right panel(10) for generated result.
See how it works
Friendly Reminder: Before any database changes especially in production, please make a backup copy.
If you have a feedback or would like to request a new feature, please visit our Contact page.