CSV Lists and Empty Last Element
I've ready many posts on how to deal with empty elements that have been ignored
in a list. Generally, the solution is something like this: <cfset someList=
Replace(aList, ",,", ",NULL", "all")>.
While this is great for empty elements that occur within a list, how does one
deal a situation when the last element in a list is empty? I have a CSV file
comprised of 5 columns. The last column has several empty values so the above
code does not work.
How can the above code be reworked to account for this condition?