Enum TextToColumnsDelimiter
TextToColumnsDelimiter
An enumeration of the types of preset delimiters that can split a column of text into multiple
columns.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.TextToColumnsDelimiter.COMMA.
Properties
| Property | Type | Description |
COMMA | Enum | "," delimiter. |
SEMICOLON | Enum | ";" delimiter. |
PERIOD | Enum | "." delimiter. |
SPACE | Enum | " " delimiter. |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[null,null,["Last updated 2024-12-02 UTC."],[[["`TextToColumnsDelimiter` is used to define the type of delimiter for splitting text within a spreadsheet column into multiple columns."],["Delimiter options include comma (`,`), semicolon (`;`), period (`.`), and space (` `)."],["To use a delimiter, call it using `SpreadsheetApp.TextToColumnsDelimiter` followed by the specific delimiter property, for example, `SpreadsheetApp.TextToColumnsDelimiter.COMMA`."]]],[]]
