BRETT-REID.COM

Working with data in Excel spreadsheets really sucks. What sucks even more is that Excel doesn’t offer “Pipe Delimited” in their Save As options. Luckily there is a way around this. (In Windows) go to Start->Control Panel->Regional and Language Options. In the Regional Options click ‘Customize’ next to the dropdown. On the ‘Numbers’ tab edit the default ‘List Seperator’ value from a comma to a pipe (or any other character). Now if you open your data in Excel and save it as CSV, it will be saved with pipes. Bloody marvelous I say.