The problem with the scalar option and split is that the number of fields is returned not the number of delimeters. The delimeter I was testing for was a pipe (|). Some of my records end with |||||| and some end with |fred|blogs. This produces a different result even if there are the same number of pipes.