Shell Programming and Scripting

How can I remove the numeric (1,2,3,4,5,etc.) in front of each line? The file look like this..

1CREATE OR REPLACE pROD (p_sc_id number,
2 p_snap_id number , p_sid number, p_halt varchar2 default 'N', p_a_nm varchar2 )
3 as
4 v_rtn number;
5
6 v_rtn := dbms_job.send_message(l_a_nm);
7
8 v_rtn := dbms_job.receive_message(p_sid, c_pipe) ;
9
10
11
12
..
..
100000

up to thousand rows and so on..

Any helps would be appreciated.

Code:

sed 's/^\s*[0-9]\+//' FILENAME

Edit that file itself.,

Code:

sed -i 's/^\s*[0-9]\+//' FILENAME

Thanks for repsonding.

But it still doens't quite working. The code to get rid of the number is ..

sed 's/^\s*[0-6]\+//' myfile

but myfile still shows the numbers..

1 create view session_trace_file_name
2 as
3 select lower(d.instance_name || '_ora_' || ltrim
4 from v$process a, v$session b, v$instance d
5 where a.addr = b.paddr
6 and b.audsid = sys_context('userenv','sessionid') ;
from v$process a, v$session b, v$instance d


I'd like the output should be like this


create view session_trace_file_name
as
select lower(d.instance_name || '_ora_' || ltrim
from v$process a, v$session b, v$instance d
where a.addr = b.paddr
and b.audsid = sys_context('userenv','sessionid') ;
from v$process a, v$session b, v$instance d

Code:

sed "s/^[0-9]* *//g" FILENAME

Or if every line starts with a number, simpler is:

Code:

cut -d" " -f2- FILENAME