Tab Characters replace and extract e-mail from field

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Tab Characters replace and extract e-mail from field

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Liverpool UK
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have imported an outlook folder into excel in order to attempt to extract the e-mail addresses from within the subject body of the e-mail (they have been bounced due to the wrong addresses).

    I have attempted unsuccessfully (with the help of guys on the board) to extract them.
    My problem is is that within the message body (which forms one excel field) is a garbled mess seperated by what i beleive are tab characters(they appear as squares when the field is highlighted) The e-mail addresses have this 'tab' character either side. I beleive with the previous help I have received I can extract the e-mail addresses if i can make these characters into one recognisable by excel however find replace does not work as the character does not appear within the find character set. Unfortunately If i use the clean function the address becomes part of a string of characters with no consistent deliminaters either side. Any ideas? as I am really struggling with this.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Liverpool UK
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have discovered the tab character is alt 10 however using find and replace will not work, get the message that the character cannot be found. Ay ideas

  3. #3
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I guess this is a continuation of:

    http://www.mrexcel.com/board/viewtop...=11744&forum=2

    Can't quite see the problem - why doesn't text to cols work??

    See the worksheet simulation for the example you gave. It uses text to column with the pipe as the delimiter & "treat consectutive delimiters as one' selected.

    Microsoft Excel - Book2___Running: xl97 : OS = Windows Windows 2000
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp
    =

    A
    B
    C
    D
    E
    F
    1
    |steven||steve@steve.co.uk||vvv|ddd|
    stevensteve@steve.co.ukvvvddd
    2






    3






    4






    5






    Sheet1

    To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

    The above image was automatically generated by [HtmlMaker 2.12] If you want this FREE SOFT, click here to download
    This code was graciously allowed to be modified: by Ivan F Moala All credit to Colo


    so we have the email address separated out - where's the problem??

    Paddy


  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Liverpool UK
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Paddy you are right this is a continuation from my previous post , i have established i can seperate the field out using text to columns using the tab symbol as the deliminator. I dont know why text to columns wont work as I can only get it to fill in the C2 column as per your example, is there something I have missed?

    [ This Message was edited by: steven H on 2002-06-27 02:32 ]

    [ This Message was edited by: steven H on 2002-06-27 02:34 ]

  5. #5
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you're still having a problem, download the html add-in (see link at bottom of screen) & post some of your data.

    Paddy

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Liverpool UK
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Paddy

    Thanx for bearing with me!

    At work, the download site is off limits will get on line over the weekend and post, its driving me nuts cos it should work as your example.

    [ This Message was edited by: steven H on 2002-06-28 00:57 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com