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