English | Japanese (日本語) | Spanish (español) | Portuguese (Português)
Separate characters with freely specified characters (SPLIT)
The character string is divided at once by the character (delimiter) specified freely. The delimiter can be specified up to 10 bytes. You can split up to 10 columns per row.
[Example 1] Divide by comma (, )
Tokyo, Seoul, Beijing, Shanghai, Taipei
Moscow, Macau, Hong Kong, Bangkok
Moscow, Macau, Hong Kong, Bangkok
Tokyo | Seoul | Beijing | Shanghai | Taipei |
Moscow | Macau | Hong Kong | Bangkok |
[Example 2] It is possible to divide by multiple characters. Example: Divide by "---"
Tokyo---Hawaii---San Francisco---New York
Tokyo---Rio de Janeiro---London---Beijing---Sydney---Athens
Tokyo---Rio de Janeiro---London---Beijing---Sydney---Athens
Tokyo | Hawaii | San Francisco | New York | ||
Tokyo | Rio de Janeiro | London | Beijing | Sydney | Athens |