14,954
edits
Split text by symbol: Difference between revisions
Jump to navigation
Jump to search
→MySQL Approach
m (→Approaches) |
|||
| Line 17: | Line 17: | ||
# to get the first string ( 25.040215 ): {{code | code=SELECT TRIM(SUBSTRING_INDEX('25.040215, 121.512532' ,',', <span style="color:red">1</span>))}} | # to get the first string ( 25.040215 ): {{code | code=SELECT TRIM(SUBSTRING_INDEX('25.040215, 121.512532' ,',', <span style="color:red">1</span>))}} | ||
# to get the second string ( 121.512532 ): {{code | code=SELECT TRIM(SUBSTRING_INDEX('25.040215, 121.512532' ,',', <span style="color:red">-1</span>))}} | # to get the second string ( 121.512532 ): {{code | code=SELECT TRIM(SUBSTRING_INDEX('25.040215, 121.512532' ,',', <span style="color:red">-1</span>))}} | ||
[http://sqlfiddle.com/#!9/482e1/1/0 Live demo on SQL Fiddle] | |||
<pre> | |||
CREATE TABLE tbl(str varchar(50)); | |||
INSERT INTO tbl VALUES('25.040215, 121.512532'); | |||
SELECT TRIM(SUBSTRING_INDEX(str ,',', 1)), TRIM(SUBSTRING_INDEX(str ,',', -1)) FROM tbl; | |||
</pre> | |||
=== Excel Approach === | === Excel Approach === | ||