Remove Line numbers from Notepad++ file

Question

I have received a very long file. It has 1000+ lines of SQL code. Each line start with line number.

14      PROCEDURE sp_processRuleset(pop_id IN NUMBER);
15  
16       -- clear procedure for preview mode to clean crom_population_member_temp table and global variables
17       PROCEDURE sp_commit; -- 28-Oct-09 J.Luo
18  
19       -- The rule Set string for the Derived Population Member Preview
20       -- The preview mode will set gv_context_ruleSet by setContext_ruleSet,
21       -- sp_processRuleset uses gv_context_ruleSet to build derived population instead of getting rules from crom_rule_set table
22       gv_context_ruleSet VARCHAR2(32767) := NULL;  -- 27-Oct-09 J.Luo
23          -- The population Role Id for the Derived Population Member Preview

I want to remove only line numbers using NotePad++ Find+Replace functionality. Is there any regex available to get this done ?

Answer 1

This using regex is the easiest way.

Other handy way (scrolling a 1K lines is not much IMO) could be :

Block Selection using ALT key and dragging your mouse, like following: