One thing that might help, with split, is to use the third arg to limit the number of columns it extracts. This will be especially helpful if there are a lot of columns to the right of the one that you want.
--Dave
Comment on Re: What is the fastest way to extract data from a delimited string?