Search and Replace Tricks

From EditPlus Wiki
Revision as of 00:38, 23 June 2006 by 80.181.144.225 (Talk) (by ElfQrin)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Delete all empty lines

Find: "^\n" (without quotes) Replace: "" (without quotes) RegExp

Truncate last value from a MySQL query

Find: (VALUES \('...', '.+'), .+\); Replace: \1); RegExp

Keep only last value in a MySQL query

Find: (VALUES \(.+,)(.+\);) Replace: VALUES (\2 RegExp