Remove Punctuation Marks
remove_punctuation_marksCleans text cells in Excel files by deleting punctuation marks while keeping letters, numbers, symbols, and spaces; prepare data for NLP, word counting, or text mining by removing punctuation noise.
Instructions
Removes punctuation marks from text cells while preserving alphanumeric characters and other symbols. This function uses Aspose.Cells Cloud API to process an Excel file and delete punctuation marks from text within cells. It removes sentence-ending punctuation (periods, question marks, exclamation points), internal punctuation (commas, semicolons, colons), quotation marks, apostrophes, parentheses, brackets, and other punctuation. However, it preserves letters (A-Z, a-z), numbers (0-9), spaces, and other symbol characters like currency symbols ($, €, £), mathematical operators (+, -, =, *, /), and special symbols (@, #, %, &, etc.). This is useful for text preprocessing in NLP, removing sentence boundaries for analysis, cleaning text for word counting, or preparing data for text mining where punctuation is considered noise.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| _range | No | ||
| file_uuid | Yes | ||
| worksheet | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |