Wednesday, November 23, 2011

Coldfusion - Using ListFind and Split to get empty elements in a list

I am working with a lot of data import modules in ColdFusion and there are a lot of issues to handle while doing the import process. The data uploaded will be of different format, different delimiters, empty or null values etc. etc.
Here, I am describing a problem where the delimiter is tab and the first element is null. I had to check whether the first element is null. I tried using ListGetAt(stringVariable,1,Chr(9)). Now, what this returned was the first non-empty element and not possible to check whether the first element was null.