[MaMister]

Last time I need a solution and was help by these experts here....

http://www.geekstogo...view=getnewpost

Now I may need some help again...

I have a text file full of phone and fax numbers.

I would like to extract only the fax numbers so that I could work it on MS access.

They are differ by Tel: 1234567 and <Fax:> 1234567, some <Fax :> 1234567.

How can I just extract the "<Fax:> 1234567" part?

Edited by MaMister, 23 May 2008 - 05:22 AM.

[Advertisements]

I'm not ax or Z, but if the fax numbers are on separate lines it can be done.
Or if you can edit it to be on different lines.
Using a word processor that will show the line numbers.
Or you may be able to extract lines that start with a particular word or phrase.

http://www.google.co...IC_enUS269US270

[cmpm]

I'm not ax or Z, but if the fax numbers are on separate lines it can be done.
Or if you can edit it to be on different lines.
Using a word processor that will show the line numbers.
Or you may be able to extract lines that start with a particular word or phrase.

http://www.google.co...IC_enUS269US270

[MaMister]

Thanks for the reply.

Part of the content of the text file looks like this:

4 Offset 0x6aa11 - Phone : 6827 2739 <Fax :> 6827 7809 Mobile :
10 Offset 0x7d8a7 - <Fax :> (65) 6223-9120=20
11 Offset 0x7eaf6 - 194800055D) <BR><BR>Tel : (65) 6325-0560 <BR><Fax :> =
12 Offset 0x846d5 - <Fax :> (65) 6580 6031=20
16 Offset 0x11453d - 6325-0721 <BR><Fax :> (65) 6223-9120 <BR>Email : </FONT><A=20
17 Offset 0x115158 - <Fax :> (65) 6223-9120=20
18 Offset 0x182028 - <Fax :> 6266 2557
19 Offset 0x183d52 - Ltd<BR>Tel : 6261 7770 (Ext 217)<BR><Fax :> 6266 2557<BR>HP : 9139 =
20 Offset 0x184505 - Ltd<BR>Tel : 6261 7770 (Ext 217)<BR><Fax :> 6266 2557<BR>HP : 9139 =
21 Offset 0x18511a - <Fax :> 6266 2557
22 Offset 0x1855df - <Fax :> 6266 2557

As I only want the " <Fax:> 1234 5678" part, any idea?

Edited by MaMister, 22 May 2008 - 10:37 PM.

[MaMister]

Hi all,

After some doings I finally come up with this kind of results. But I am happy with it:

62662557<BR>HP : 9139 =
65661433=20
63372488Mobile

Now I would like find a way to clean up the text file by only keep the front 8 numbers.

Any advice?