Convert split_string to SQLite query

Asked Mar 10 '22 at 07:51

Active Mar 10 '22 at 09:23

Viewed 216 times

I have been trying to convert split_string syntax to SQLite from SQL Server. I couldn't find any alternative to do that. can anyone please help me to do that.

SELECT row_number () over (order by (select 0)) rn, value
FROM string_split(Nav_Path,''/'')

This is the SQL query that needs to write in SQLite. There is syntax error saying

Transaction ERROR: sqlite3_prepare_v2 failure: no such table: string_split

Thank you

edited Mar 10 '22 at 09:23

LukStorms

28,916
5
31
45

asked Mar 10 '22 at 07:51

Sandaru Eranjana

sqlite didn't suppot `string_split` function. – D-Shih Mar 10 '22 at 07:54
Does [this](https://stackoverflow.com/questions/24258878/how-to-split-comma-separated-value-in-sqlite) helps ? – Squirrel Mar 10 '22 at 07:59
I have tried that but i have no idea where to apply that – Sandaru Eranjana Mar 10 '22 at 08:01
*db<>fiddle [here](https://dbfiddle.uk/?rdbms=sqlite_3.27&fiddle=106be7ebde6e18b5d4abeaac0e2e2625)* – LukStorms Mar 10 '22 at 09:25

Convert split_string to SQLite query

0 Answers0