parsing piped data for ICASA codes

[chporter]

I want to use concatenated "ICASA Code" | "Text description" in pull-down boxes in the Excel spreadsheet data entry templates to make it easy for people to choose the correct ICASA code. So the csv input file would have the piped data, but we only need to keep the ICASA code in the JSON. Let's brainstorm on this a little. Here's a sample fertilizer event with this implemented:

1,Event,Fertilizer,fedate,2012-06-12,FECD,FE010|Urea ammonium nitrate solution,FEACD,AP005|Applied in irrigation water,FEDEP,15,FEAMN,98