Enum TextCleansingMode
The text transformation to apply during a
Worksheet.CleanText operation.
Namespace: DRIT.Spreadsheet.DataCleansing
Assembly: DRIT.Spreadsheet.dll
Syntax
public enum TextCleansingModeFields
| Name | Description |
|---|---|
| Clean | Remove non-printable characters (code points 0–31). Matches Excel's CLEAN function. |
| Lower | Convert to lowercase. |
| Proper | Capitalise the first letter of each word and lowercase the rest. Matches Excel's PROPER function. |
| RemoveExtraSpaces | Collapse internal runs of spaces and tabs to a single space and trim leading and trailing whitespace. Matches Excel's TRIM function. |
| Trim | Remove leading and trailing whitespace. |
| TrimLeading | Remove leading whitespace only. |
| TrimTrailing | Remove trailing whitespace only. |
| Upper | Convert to uppercase. |