14,954
edits
Split text by symbol: Difference between revisions
Jump to navigation
Jump to search
→Approachs
| Line 3: | Line 3: | ||
== Approachs == | == Approachs == | ||
* Excel: (1) LEFT, RIGHT, FIND, LEN (2) MOD, FIND, LEN | * Excel: (1) LEFT, RIGHT, FIND, LEN (2) MOD, FIND, LEN | ||
* PHP: explode | * PHP: [http://php.net/explode explode] function | ||
* 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] | ||