Results 1 to 17 of 17
  1. #1
    Affiliate Summit Guy Shawn Collins's Avatar
    Join Date
    January 18th, 2005
    Location
    Austin, TX
    Posts
    1,157
    I am working on creating a data feed from scratch, and I was wondering if anybody knows how I could convert an Excel sheet to pop delimited?

    I see options for saving a file as comma delimited or tab delimited, but not pipe delimited.

    <font size="2" color="#0000ff" face="verdana"><b>Shawn Collins</b></font>
    <font size="1" color="#000000" face="verdana"><i><a href="http://www.ShawnCollinsConsulting.com" target="_blank">www.ShawnCollinsConsulting.com</a> - scollins@affiliatemanager.net - 908-522-0056</i>
    outsourced affiliate program management</font>

  2. #2
    Newbie
    Join Date
    January 18th, 2005
    Posts
    49
    I know there is an easier way, but I don't know what it is. I get rid of all the commas, save the file as a csv and then open the file in microsoft word and do an edit and replace with commas for pipes.

  3. #3
    Member
    Join Date
    January 18th, 2005
    Posts
    95
    You can import the excel file to Access, then export the table a a text file - you will be given choices for delimited/fixed-width. Choose delimited, and you then have a choice as to what delimiter to use - choose other and enter '|'....

    http://www.diyautoparts.com

  4. #4
    Action Jackson - King of the World
    Join Date
    January 18th, 2005
    Posts
    2,201
    ok what if I want to change pipe to tab lol. Is there a way to do a search replace somehow?

    Jack Mitchell
    http://kattskozykorner.com
    http://clothing-to-go.com
    http://sports-to-go.com

  5. #5
    ABW Ambassador Mike O's Avatar
    Join Date
    January 18th, 2005
    Location
    Los Angeles area
    Posts
    843
    While you're in Excel the delimiters are hidden from you. You need to save the file in some format and work on it outside of Excel.

    I use NotePad or WordPad to do search-and-replace to swap tabs with pipes or whatever.

    "Men travel faster now, but I do not know if they go to better things."
    -- Willa Cather

  6. #6
    Action Jackson - King of the World
    Join Date
    January 18th, 2005
    Posts
    2,201
    How would I go about changing pipes to tab? Is there a keystroke used to illustrate a tab?

    search for: |
    replace: ???

    Jack Mitchell
    http://kattskozykorner.com
    http://clothing-to-go.com
    http://sports-to-go.com

  7. #7
    Member
    Join Date
    January 18th, 2005
    Posts
    95
    In Excel, File --> Save As

    There is an option to save as Text(tab-delimited)

    http://www.diyautoparts.com

  8. #8
    Affiliate Summit Guy Shawn Collins's Avatar
    Join Date
    January 18th, 2005
    Location
    Austin, TX
    Posts
    1,157
    Thanks to everybody for their help!

    <font size="2" color="#0000ff" face="verdana"><b>Shawn Collins</b></font>
    <font size="1" color="#000000" face="verdana"><i><a href="http://www.ShawnCollinsConsulting.com" target="_blank">www.ShawnCollinsConsulting.com</a> - scollins@affiliatemanager.net - 908-522-0056</i>
    outsourced affiliate program management</font>

  9. #9
    ABW Ambassador Mike O's Avatar
    Join Date
    January 18th, 2005
    Location
    Los Angeles area
    Posts
    843
    As far as changing a pipe to a tab, I get my "tab" character by either:

    A) Using a "tab" character in a NotePad file (type a letter then press the Tab key, then another letter). Then copy the "space between the letters" to the clipboard and paste it into the "replace with" box.

    B) If using Windows, hold down the ALT key and press these four keys: 0 0 0 9 on the numeric keypad (NOT above the letter keys) and then release the ALT key. That will generate a "tab" character. If you do that when the cursor is in the "replace with" box you should get your "tab" character that way.

    "Men travel faster now, but I do not know if they go to better things."
    -- Willa Cather

  10. #10
    Action Jackson - King of the World
    Join Date
    January 18th, 2005
    Posts
    2,201
    Thx Mike that was exactly what I was lookig for. I knew there had to be a keyboard shortcut

    Jack Mitchell
    http://kattskozykorner.com
    http://clothing-to-go.com
    http://sports-to-go.com

  11. #11
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    Wow, I have been trying to use the "copy the space between the characters" to do search and replace for tabs in WordPad for a long time and NEVER had any success, will go try the keyboard method! I have a Links program that needs pipe delimited files to import, and this will be REALLY cool if it works!!!

    Thanks for sharing

    Deborah Carney
    Link up!
    Submit your sites, if you fit the criteria
    http://coolcraftsites.com/directory
    http://coolpetsites.com/petlinks

  12. #12
    ABW Ambassador darkstar7's Avatar
    Join Date
    January 18th, 2005
    Location
    Maryland
    Posts
    536
    Here is a macro you can install in Excel to convert any spreadsheet to a pipe Delimited text file go to: http://www.lwebco.com/pipe_delimited.txt

    Copy and paste this macro as a new macro in Excel. Then when you want to convert go to Tools / Macro / Run in Excel and hit go.
    Luke
    Have you promoted your brand name today?

  13. #13
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    Thanks Luke...

    Fred

  14. #14
    ABW Ambassador Mike O's Avatar
    Join Date
    January 18th, 2005
    Location
    Los Angeles area
    Posts
    843
    Thanks from me, too! That's something I can definitely use.

    -- Mike
    A joy shared is a joy doubled.
    A burden shared is a burden lightened.

  15. #15
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    Thanks from here too, but I have a probably stupid question, I see a way to Record a Macro but not a way to paste the info into a Macro, how do I save the text to make it into a Macro and where should I put it?
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  16. #16
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    Well, I don't think I could replicate the process LOL, but I managed to install this and it is WONDERFUL!!!!! It works perfectly and is allowing me to load lots of links that I was having problems with!!!!
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  17. #17
    ABW Ambassador darkstar7's Avatar
    Join Date
    January 18th, 2005
    Location
    Maryland
    Posts
    536
    I'm glad it helped.
    Luke
    Have you promoted your brand name today?

  18. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Pipe Delimited to Comma Separated
    By knight01 in forum Programming / Datafeeds / Tools
    Replies: 12
    Last Post: March 30th, 2014, 01:57 AM
  2. Pipe delimited Datafeed To MySQL
    By nick_mayhem in forum Programming / Datafeeds / Tools
    Replies: 7
    Last Post: September 18th, 2006, 09:56 AM
  3. javascript for PIPE DELIMITED (|) database
    By davon in forum ShareASale - SAS
    Replies: 0
    Last Post: December 29th, 2005, 06:33 PM
  4. Pipe delimited to tab
    By bbb in forum Programming / Datafeeds / Tools
    Replies: 10
    Last Post: August 30th, 2004, 06:03 AM
  5. Using an Affiliate Feed with Exel (Pipe Delimited)
    By jdsguam in forum Programming / Datafeeds / Tools
    Replies: 3
    Last Post: April 22nd, 2004, 09:57 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
  •