Search and Replace Tricks

From EditPlus Wiki
Revision as of 00:42, 23 June 2006 by 80.181.144.225 (Talk) (BReak lines)

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