Results 1 to 4 of 4
  1. #1
    Full Member
    Join Date
    January 18th, 2005
    Posts
    164
    csv to pipe
    Hi guys I get a datafeed file in pipe ( | ) format and open it with excel. I then have to rearrange the columns and save this in pipe format but cant find anyway to do this with excel.

    Can anyone recommened how to acheive this I've been banging my head against the wall for 2 hours. lol..

    Cheers Kili

  2. #2
    Newbie dtrenck's Avatar
    Join Date
    January 18th, 2005
    Posts
    33
    Lookup changing delimiters in Excel help... This is what you'll find.

    Click the Windows Start menu.
    Click Control Panel.
    Open the Regional and Language Options dialog box.
    Click the Regional Options Tab.
    Click Customize.
    Type a new separator in the List separator box.
    Click OK twice.
    Note After you change the list separator character for your machine, all applications will use the new character. You can change the character back to the original character by using the same procedure.

    - Dave

  3. #3
    Full Member
    Join Date
    January 18th, 2005
    Posts
    164
    Many Thanks Dave

    Kili

  4. #4
    Full Member
    Join Date
    January 18th, 2005
    Posts
    164
    I get all sorts of errors when trying to import the data into excel. Anyone know of a script or tool to do this?

    Reagrds
    kili

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Changing Pipe delimited to CSV or tab
    By westgroup in forum Programming / Datafeeds / Tools
    Replies: 13
    Last Post: June 9th, 2005, 02:10 AM
  2. Which datafeed format results in the fewest errors: Tab, CSV, or Pipe?
    By Kadence in forum Commission Junction - CJ
    Replies: 9
    Last Post: April 30th, 2005, 04:17 AM
  3. Pipe delimited to tab
    By bbb in forum Programming / Datafeeds / Tools
    Replies: 10
    Last Post: August 30th, 2004, 06:03 AM
  4. tab or pipe delimited format in a .csv
    By hershey in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: July 17th, 2002, 08:52 AM

Posting Permissions

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