In the automotive aftermarket community the exchange of electronic parts data when not in ACES or PIES XML is usually in a Pipe delimited format.
The most common desktop application to manipulate data is Microsoft Excel. Unfortunately Excel does not have a native way to specify a delimiter. You have .CSV, Tab and a few others none of which are Pipe.
This neat trick will show you how to create Pipe delimited files using MS Excel.
Be sure to watch in HD!
Like and share! Use the comments…