SQLite and regular expressions

Question

I have a column in SQLite which contains strings such as:

equal_to#1 capable#4 adequate_to#1

I would like to get the following results:

equal_to, capable, adequate_to

I'm trying to get it working with replace but with no luck, perhaps someone might help me with some regex?

Answer 1

Use substr and instr

select substr("equal_to#1", 0, instr("equal_to#1", '#'))

output:

equal_to

Answer 2

Your regex should be something like this:

/#\d+/g

here is an example