Excel Position‑Based Character Remover – Delete Text at Specific Locations – Online Shortcode

Delete characters from Excel cells by position: remove first/last N characters, or delete text before/after specified markers. Precise text cleaning with Aspose.Cells Cloud Web API.

Introduction: Remove Unwanted Characters by Position

Position modes

  • theFirstNCharacters – remove N characters from the start
  • theLastNCharacters – remove N characters from the end
  • allCharactersBeforeText – delete everything before the first occurrence of the supplied substring
  • allCharactersAfterText – delete everything after the first occurrence
  • BetweenValues – strip the substring (and optionally the delimiters themselves) between two user‑defined values

Options

  • caseSensitive – determines whether searches for BeforeText, AfterText, and BetweenValues are case‑sensitive

RemoveCharactersByPosition API

API Endpoint

PUT http://api.aspose.cloud/v4.0/cells/content/remove/characters

The request parameters of RemoveCharactersByPosition API are

Parameter Name Type Path/Query String/HTTPBody Description
Spreadsheet File FormData The spreadsheet file to be processed. Supported formats include XLSX, XLS, ODS, CSV, etc.
theFirstNCharacters Integer Query Number of characters to remove from the beginning of the text in each selected cell (e.g., 3 removes the first 3 characters).
theLastNCharacters Integer Query Number of characters to remove from the end of the text in each selected cell (e.g., 2 removes the last 2 characters).
allCharactersBeforeText String Query Removes all characters that appear before the specified text string in each cell. If the text appears multiple times, removal is based on the first occurrence.
allCharactersAfterText String Query Removes all characters that appear after the specified text string in each cell. If the text appears multiple times, removal is based on the first occurrence.
worksheet String Query (Optional) The name of the worksheet where character removal will be applied. If omitted, the operation applies to the first worksheet.
range String Query (Optional) The cell range where character removal will be applied (e.g., "A1:C10"). If omitted, the operation applies to all used cells in the specified worksheet.
outPath String Query (Optional) The cloud storage folder path where the processed workbook will be saved. If omitted, the file is saved in the source folder.
outStorageName String Query The name of the cloud storage where the output file will be stored.
region String Query (Optional) Sets the locale for text handling, particularly relevant for language‑specific character positions and encoding (e.g., "en-US", "zh-CN").
password String Query (Optional) If the uploaded spreadsheet is password‑protected, provide the password to open and process the file.

Response

{
  "File": "..."
}

Refine Your Text: Remove Unwanted Characters with Precision

Error Codes

  • 400 Bad Request: Invalid Aspose.Cells Cloud API URI.
  • 401 Unauthorized: Invalid access token or invalid client ID and secret.
  • 404 Not Found: The spreadsheet file is not accessible.
  • 500 Server Error: The spreadsheet encountered an anomaly while obtaining calculation data.

Where should we use the Remove Characters by Position API?

  • Data Standardization: Clean product codes (remove leading zeros or suffixes), phone numbers (strip country codes)
  • Text Extraction: Extract key information from log files (remove timestamps or prefixes)
  • File Processing: Organize filenames (remove uniform prefixes or date suffixes)
  • Data Parsing: Process structured text (extract content between brackets or specific markers)
  • Database Management: Clean imported data (remove fixed‑format header/trailer characters)

Why should you use the Remove Characters by Position API?

  • Precise & Efficient: Direct positional deletion eliminates the need for complex regular expressions.
  • Flexible Configuration: Five positioning modes plus a case‑sensitivity option cover diverse scenarios.
  • Batch Processing: Clean entire columns with a single call, boosting efficiency by up to 10×.
  • Smart Parsing: Easily handle content extraction between two delimiters.
  • Developer‑Friendly: Aspose.Cells Cloud provides SDKs for multiple languages, accelerating development and offering comprehensive documentation. Compared with building custom text‑processing logic, this significantly reduces development workload.
  • Cost‑Effective: Characters can be removed without first uploading the workbook, saving storage space and reducing costs.

OpenAPI Specification

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

Use Aspose.Cells Cloud SDKs

Using the SDK is the best way to accelerate development. The SDK handles the underlying details, allowing you to simply implement remove‑characters‑by‑position for cells with minimal code.
Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples illustrate how to make calls to Aspose.Cells web services using various SDKs: