Export or Save Excel Files with Pipe (or Other) Delimiters Instead of Commas. If you’re working with some awful corporate system that should have been retired in the dark ages, you might have had to produce a file from Excel with some weird delimiters other than comma or tab- delimited to import into the system. Here’s the trick on how to do it. Naturally, this isn’t the type of article that most people will need to use, hopefully ever—but if you do need to know how to do it, the solution isn’t really obvious at first. Exporting Excel Files as Pipe Delimited. For the purposes of this example, we’ll use this silly little Excel file. To save the file as Delimited, you’ll need to click the Office button and choose Save As –> Other Formats. Then select CSV (Comma delimited)(*. Now here’s where the interesting part happens.
Convert Excel files to a tab-delimited version by clicking on 'File' and then 'Save as.' In the drop-down list of file types choose 'text (tab-delimited).' Step 5 Change the file extension on any of the above results if it is not already 'tab' to this ending.But i still not convert from tab delimited to pipe delimited. Because i'm amatuer for batch and coding. I need to convert a worksheet created in Excel 2007 to a pipe delimited ascii text file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2016
Categories |