Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2006
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tab Delimited text - separators (Excel XP)

    Hi. I am using Excel to create a tab delimited text file so that it can be uploaded into another program.
    If any of the columns in the text file contain a carriage return, pipe character (ascii code 124) etc.. then the upload program sees these as a new column.
    I want to strip out all the separator type characters so that only the tabs delimit the text columns.
    I was wondering if anyone has a complete list of all the different types of tab separator like characters that generally cause this type of a problem?

    So far, I have found the following characters in the text cause the columns to be misaligned:
    - tabs (ASCII code = 9)
    - paragraph marks (ASCII code = 10, 13)
    - pipe characters (ASCII code = 124)

  2. #2
    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

    Re: Tab Delimited text - separators (Excel XP)

    Depending on how it is saved and opened some other problems may come from:

    Space (ascii 32)
    Dbl-Quote (Ascii 34)
    Comma (AscII 44)
    Semi-Colon (ascii 59)

    Some of the problems can be worked around by enclosing text strings with these items within dbl-quotes

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Tab Delimited text - separators (Excel XP)

    Tabs are also famous for mis-aligning text due to more than one tab between the text. Often the text file needs two or three tabs to properly align text of different lengths. In this event, there is no need to remove the extra tabs, but simply to use the option called "Treat consecutive delimiters as one" in the text import wizard.
    Regards,
    Rudi

Posting Permissions

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