On 1/5/2008 9:21 AM, wong_powah@[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.
|
