remove_punctuation_marks
Removes punctuation from Excel text cells, preserving letters, numbers, and symbols. Ideal for NLP preprocessing and cleaning text for analysis.
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 | ||
| worksheet | No | ||
| file_token | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |