14,954
edits
Split text by symbol: Difference between revisions
Jump to navigation
Jump to search
m
→Approaches
m (→Approaches) |
|||
| Line 3: | Line 3: | ||
== Approaches == | == Approaches == | ||
list of equivalent approaches to split text by symbol | list of equivalent approaches to split text by symbol | ||
* MySQL: [http://www.w3resource.com/mysql/string-functions/mysql-substring_index-function.php MySQL SUBSTRING_INDEX() function - w3resource] | * MySQL: [http://www.w3resource.com/mysql/string-functions/mysql-substring_index-function.php MySQL SUBSTRING_INDEX() function - w3resource] | ||
* Excel: (1) [https://support.microsoft.com/en-us/kb/214261 parse data] ([https://support.microsoft.com/zh-tw/kb/214261 資料剖析]) {{exclaim}} only allowed one character used as separator! (2) LEFT, RIGHT, FIND, LEN (3) MOD, FIND, LEN | * Excel: (1) [https://support.microsoft.com/en-us/kb/214261 parse data] ([https://support.microsoft.com/zh-tw/kb/214261 資料剖析]) {{exclaim}} only allowed one character used as separator! (2) LEFT, RIGHT, FIND, LEN (3) MOD, FIND, LEN | ||
* PHP: [http://php.net/explode explode] function | |||
== Example == | == Example == | ||