SQL Editor? Reg Expressions

#1 · 2024-06-17, 4:30 pm

I was really excited to see the scripts to tackled Newspapers.com in the sources, since I suffer from the same issue.

I am using DB Browser to run code - but it doesn't seem to support regular expressions.

I don't know what to do. Is there a preferred editor?

#2 · 2024-06-17, 9:05 pm

Are you referring to the scripts under Sources - Newspapers.com - Cleaner Footnotes and Simpler Bibliography?

If so, then you will note the statement in the preamble of the script:

Developed and tested on SQLiteSpy v1.9.16 Win64.

A further reference on regular expressions with sqlite is:

https://sqlitetoolsforrootsmagic.com/forum/topic/regular-expressions-in-sql-select-update-for-sqlite/

You will see that the required REGEXP_REPLACE() function is an extension to the core sqlite so it is not necessarily available in a sqlite manager out-of-the-box. However, your manager might be able to load an extension to add the function.

Tricia Aanderud has reacted to this post.

#3 · 2024-06-18, 5:19 am

Thanks Tom.

I'm more familiar with MySQL. Your post cleared up some misconceptions I had.

Are there any other extensions (outside of the one for the RMNOCase) that I should seek?

#4 · 2024-06-18, 7:32 am

Have a look at In Praise of SQLite and follow the link to sqlean for a selection of extensions, some of which might be useful to you.