Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Ax238, Ztruker please help.


  • Please log in to reply

#1
MaMister

MaMister

    Member

  • Member
  • PipPip
  • 96 posts
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.

  • 0

Advertisements


#2
cmpm

cmpm

    Member

  • Member
  • PipPipPip
  • 561 posts
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
  • 0

#3
MaMister

MaMister

    Member

  • Topic Starter
  • Member
  • PipPip
  • 96 posts
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.

  • 0

#4
MaMister

MaMister

    Member

  • Topic Starter
  • Member
  • PipPip
  • 96 posts
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?
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP