On Jan 5, 11:01 am, Ed Morton <mor...@[EMAIL PROTECTED]
> wrote:
> On 1/5/2008 9:21 AM, wong_po...@[EMAIL PROTECTED]
wrote:
>
>
>
> > How to remove the extra numeric field in a text file?
> > e.g. for the following text file, I want to remove $2,299.11 from the
> > first line, $2,292.86 from the second line, $2,170.08 from the fourth
> > line and $2,286.08 from the last line.
>
> > Oct. 01, 2007 CITY OF
> > VANCOUVER $456.48 $2,299.11
> > Property taxes
> > Oct. 02, 2007 TD GEN INS
> > $66.25 $2,292.86 Car insurance
> > Oct. 09, 2007 BELAIR HABITAT. BELAIR INS/ASS.
> > $40.95 Home insurance
> > Oct. 09, 2007 ENBRIDGE ENBRIDGE
> > $45.91 $2,170.08 Home heating
> > Nov. 05, 2007 CANADIAN TIRE #
> > $22.74 Home general maintenance
> > Dec. 10, 2007 CANADIAN TIRE #
> > $44.21 Home general maintenance
> > Dec. 19, 2007 CANADIAN TIRE #
> > $71.48 $2,286.08 Home general maintenance
>
> Were the above lines wrapped by your posting (i.e. does each line really
start
> with a date)? Are all of the spaces above the same or are some of them
tabs to
> separate fields?
>
> Ed.
The above lines were wrapped by my posting (i.e. each line really
start with a date).
There are tabs and spaces.
Thank you all for your solutions!
|
