General Consultant Discussion

 View Only

  • 1.  I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-17-2013 19:52
    I need to save an Excel spreadsheet as a PIPE delimited text file. Is this possible to do or is Access my best alternative?


  • 2.  RE: I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-17-2013 21:46
    You can do this by changing the List Seperator to a pipe in the Windows Control Panel Regional and Lanquage Options dialog.


  • 3.  RE: I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-18-2013 06:45
    @DanBurleson, such a simple solution to something I have fought for years. I always built a formula concatenating all the fields I needed and putting a pipe between each. Yours is a much simpler way. Thanks for the tip.


  • 4.  RE: I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-18-2013 08:04
    OMG. This is good. This really helps with inventory imports where there are lots of inches and commas in the description


  • 5.  RE: I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-18-2013 08:09
    Carefull, this has the odd effect of changing the comma is unexpected places such as the seperator in MS Access query formulas and who knows where else. Definitely only for temporary use.


  • 6.  RE: I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-18-2013 08:12
    Good point Dan. Thanks for the reminder.


  • 7.  RE: I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-18-2013 08:18
    @ShawnSlavin - I can't claim much credit for a Google of: Excel csv pipe.


  • 8.  RE: I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-19-2013 06:45
    @DanBurleson a master magician should never reveals his secrets!


  • 9.  RE: I need to save an Excel spreadsheet as a PIPE deli

    Posted 03-19-2013 07:35
    Good point Dan. Where i have seen issues is in excel formulas. It changes the separator from a comma to a pipe. But this trick is a great one.


Related Content