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
F for Find window and the select the following:
- Find what: “(?<=\[)(\w+) "
- Flag Regular expression
- Do not flag . matches new lines