Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts
    I have a sql database having xml fields for phone numbers, when I transfer the field to excel i get a lot of unwanted xml code

    here is an example
    <TelephonesDataSet xmlns="http://xxx.org/TelephonesDataSet.xsd">
    <Telephones>
    <CodeTypeTelephone>1</CodeTypeTelephone>
    <CodeTypeTelephoneLibele>Travail</CodeTypeTelephoneLibele>
    <NumeroTelephone>450-430-2000 </NumeroTelephone>
    </Teleph

    How can I remove everthing but the 10 didgit phone number or just extract into another cell the 10 didgit 0r 12 character phone number.

    Richard


  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts
    I found a way using the find and subtring function, but i need to find three distinct area codes 514 ou 450 or 819

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You can do a 3 finds (grouped with an OR) for "514-", "450-" , and "819-"

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •