I am creating a report for one of the BA’s at work and the system lets you run sql on the database and “export” the data. By export it creates a tab delimited text field which you can use to copy and paste into a different document. So I did that and then needed to make it work nice with excel so he didn’t have any problems with it on his end. Looking at the file in emacs I found that there were to many tabs between the third and the fourth columns of data and it was importing incorrectly into excel. Macros to the rescue. All I had to do was record the manipulation of one line and then use M-u
4/2/2009 ~ 1 min read
