I have :
953-UL_CPLX_7th-CRL_PD_GPON_O as string:
In mysql:
SPLIT_STR('953-UL_CPLX_7th-CRL_PD_GPON_O', '-', 1)
So I need to split (-) to return 953 in sqlite
Asked
Active
Viewed 1,940 times
-2
-
Do you want only the part before the 1st `-` of the string? – forpas Dec 30 '21 at 16:25
-
There is no SPLIT_STR() in MySql. Where did you see it? – forpas Dec 30 '21 at 16:32
-
Does this answer your question? [Split a string into rows using pure SQLite](https://stackoverflow.com/questions/34659643/split-a-string-into-rows-using-pure-sqlite) – Mark Benningfield Dec 31 '21 at 07:11
1 Answers
1
This is how I would do it in SQLite:
SELECT SUBSTR('953-UL_CPLX_7th-CRL_PD_GPON_O',1, INSTR('953-UL_CPLX_7th-CRL_PD_GPON_O', '-')-1)
This will return any number of characters before the first "-" character.
Dharman
- 30,962
- 25
- 85
- 135