Notepad++ snippets
How to find spaces into field names in Notepad++
Let say you have the following query:

SELECT [Name],[Population],[Area km3]
FROM cities
WHERE Area='EU'
and you want to find if any of the field names contain any space.

To do this in Notepad++, you can just hit CTRL + F for Find window and the select the following:

- Find what: “(?<=\[)(\w+) "
- Flag Regular expression
- Do not flag . matches new lines
Nicola Simboli Senior Analytics Engineer
15+ years across SaaS, enterprise and consulting. Focused on scalable data platforms, metric reliability and analytics systems that teams actually use.