+ Reply to Thread
Results 1 to 6 of 6

Save as a pipe delimited text file

  1. #1
    Registered User
    Join Date
    05-30-2004
    Posts
    53

    Save as a pipe delimited text file

    I have a csv file which I have opened in Excel 2008 on my mac.

    How do I export it as a pipe delimited text file.

    I can only see an option to save it as a tab delimited text file.

    If I cant save as a pipe delimited text file,
    Is there a way to convert from a tab delimited text file to a pipe delimited text file?
    Using Excel for Mac

  2. #2
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Save as a pipe delimited text file

    You could always open the tab delimited file in a text editor (word, wordpad, notepad), replace all tabs with pipes, and save as txt?

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Save as a pipe delimited text file

    maybe if you save as tab delimited
    open with word
    find/replace ^t with pipe character
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Save as a pipe delimited text file

    very strange board behavior today double posting and all!!!
    Last edited by martindwilson; 07-01-2010 at 04:46 AM.

  5. #5
    Valued Forum Contributor
    Join Date
    10-06-2008
    Location
    Norway
    MS-Off Ver
    2010
    Posts
    365

    Re: Save as a pipe delimited text file

    Instant QA:-D

  6. #6
    Registered User
    Join Date
    05-30-2004
    Posts
    53

    Re: Save as a pipe delimited text file


    You could always open the tab delimited file in a text editor (word, wordpad, notepad), replace all tabs with pipes, and save as txt?

    maybe if you save as tab delimited
    open with word
    find/replace ^t with pipe character
    Tried these 2 but did not work.

    Anyhow, I had to do a windows hack with regional settings and then it worked.

    JH

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1