Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    need to remove garbage from eml

    data base points to a email fild that was written in xml that generates ;a lot of garbage. here is a copy of the extraction.

    <CourrielsDataSet xmlns="http://tempuri.org/CourrielsDataSet.xsd">
    <Courriels>
    <AdresseCourriel>pxplx@videotron.ca</AdresseCourriel>
    </Courriels>
    </CourrielsDataSet>

    How can each email address so the case above would give pxplx@videotron.ca

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    Can you post an example in an Excel file?

    zeddy

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    the demo file requested need to clean up xml code

    i should have said removing the crude form xml
    Attached Files Attached Files

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    See attached file.
    I placed a formula in column B which looks for the @ char found in an email address.
    In column C, I then put a formula that extracts the email address.
    (The find formula uses a dummy char which is unlikely to be found in the source)


    zeddy
    Attached Files Attached Files

  5. The Following User Says Thank You to zeddy For This Useful Post:

    r3x3 (2012-05-29)

Tags for this Thread

Posting Permissions

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