Split a string with specified characters
Splits a given string with specified characters.
URL
https://api.excelapi.org/language/textsplit
Configuration
| Configuration | Required | Description |
|---|---|---|
| text | ✔ | Specify the string to be split |
| delimiter | ✔ | Specify the character to be split |
| line | ✔ | Specifies how many strings to return after splitting, which must be a number greater than or equal to 1. |
Example
B2 (Auto-fill to right side):
=WEBSERVICE("https://api.excelapi.org/language/textsplit?text="&ENCODEURL($A2)&"&delimiter="&ENCODEURL(",")&"&line="&B$1)
B3 (Auto-fill to right side):
=WEBSERVICE("https://api.excelapi.org/language/textsplit?text="&ENCODEURL($A3)&"&delimiter="&ENCODEURL("-")&"&line="&B$1)
B4 (Auto-fill to right side):
=WEBSERVICE("https://api.excelapi.org/language/textsplit?text="&ENCODEURL($A4)&"&delimiter="&ENCODEURL(" ")&"&line="&B$1)
tip
If you can use TEXTSPLIT function,it is recommended to use it.
This function is intended for use with version plans that cannot use the TEXTSPLIT function.