Key Facts
- Category
- Text Processing
- Input Types
- textarea, select, text, checkbox
- Output Type
- text
- Sample Coverage
- 4
- API Ready
- Yes
Overview
This utility allows you to efficiently strip specific suffixes from the end of every word in your text, helping you clean datasets, normalize variable names, or standardize lists in seconds.
When to Use
- •Cleaning raw data exports that contain repetitive suffixes like '_id', '_raw', or '_v1'.
- •Standardizing lists of words by removing common grammatical endings such as '-ing' or '-ed'.
- •Preparing text for programming or database imports by stripping unwanted numeric or alphabetic tags.
How It Works
- •Paste your text into the input area.
- •Select the type of suffix you wish to remove from the dropdown menu.
- •Configure optional settings like case sensitivity or custom suffix definitions.
- •Click the process button to instantly generate your cleaned text.
Use Cases
Examples
1. Cleaning Database Variable Names
Data Analyst- Background
- A database export contains column names like 'user_id', 'order_id', and 'status_id'.
- Problem
- The '_id' suffix is redundant for the current report and needs to be removed from all entries.
- How to Use
- Paste the list of column names, select 'Custom Suffix', and enter '_id'.
- Example Config
-
removeType: custom, customSuffix: _id - Outcome
- The list is converted to 'user', 'order', and 'status' instantly.
2. Standardizing Word Lists
Content Editor- Background
- A list of keywords includes various forms like 'running', 'jumping', and 'walking'.
- Problem
- Need to extract the base root of these words by removing the '-ing' suffix.
- How to Use
- Paste the words, select 'Common Suffixes', and process the text.
- Example Config
-
removeType: common - Outcome
- The list is reduced to the base forms 'run', 'jump', and 'walk'.
Try with Samples
video, textRelated Hubs
FAQ
Can I remove custom suffixes?
Yes, select 'Custom Suffix' from the Remove Type menu and enter your specific string in the Custom Suffix field.
Is the tool case-sensitive?
Yes, you can enable the 'Case Sensitive' checkbox to ensure only suffixes matching your exact casing are removed.
Does it handle multiple occurrences of a suffix?
Yes, enable the 'Remove Multiple Occurrences' option to strip the suffix even if it appears repeatedly at the end of a word.
What types of suffixes are supported by default?
The tool supports common grammatical suffixes, numeric suffixes, short alphabetic suffixes, and all non-alphanumeric endings.
Will this affect the middle of the words?
No, the tool is designed to only target characters located at the very end of each word.