I was parsing through a csv file today and having issues with empty values. The data I’m receiving is in a format the 3rd party cannot update, so my data looked something like this
Dumping the list provides the expected list, but looping through the list it skips over values
<cfoutput> <cfloop list="#list1#" index="i"> #i#<br> </cfloop> </cfoutput>
1 abc 32 gef
After googling this for a bit I gave up and asked my brother. He told me to use the ‘includeemptyfields’ attribute in listtoarray(). I knew I could turn a list into an array, but I wasn’t aware of the third attribute until today, the default is obviously false, so blank values were never included.
The code below produces the desired output. Notice I am now looping through an array instead of a list.
<cfset newlist = listToArray(list1,',',true) /> <cfoutput> <cfloop array="#newlist#" index="i"> #i#<br> </cfloop> </cfoutput> 1 abc 32 gef