BYJ

Recent Blog Comments By BYJ

• CSVToArray() ColdFusion UDF For Parsing CSV Data / Files

  Posted on Aug 6, 2009 at 10:17 AM

  Hi Ben, I found another bug on the function. I used a different tab delimited file, one of the row is an empty space row: AAAAAAA-tab-BBBB-tab-1234-tab-CCCCCCCC --empty new row--- XXXXXXX-tab-YYYY-tab-5456-tab-ZZZZZZZZ I got this result: array 1 has an array elements AAAAAA, BBBB, etc. but array 2 i... read more »

• CSVToArray() ColdFusion UDF For Parsing CSV Data / Files

  Posted on Aug 6, 2009 at 9:58 AM

  Ben, As far far as my codes, other than this function, I only have CFSET to get the file location as: #FeedPath##FileName# Then I do: <cfset arrData = CSVToArray(File="#FeedPath##FileName#",Delimiter = "#chr(9)#") /> To call the function, and I do cfdump: <cfdump var="#arrData#"> I ne... read more »

• CSVToArray() ColdFusion UDF For Parsing CSV Data / Files

  Posted on Aug 5, 2009 at 2:56 PM

  Ben, To add on my previous comment. I have just finished parsing 375 records(lines) in tab delimited text file. Total Time Avg Time Count --------- -------- ----- 130394 ms 130394 ms 1 131722 ms TOTAL EXECUTION TIME This is just to create the array, I think it took too much time. ... read more »

• CSVToArray() ColdFusion UDF For Parsing CSV Data / Files

  Posted on Aug 5, 2009 at 1:59 PM

  Ben, I experiences 2 things when applying this code to my tab delimited text file. 1. I used your code to parse less than 6000 records and It took me forever to just see the cfdump. Finally I have to stop and killed my browser. When I deleted those records and left only 4 records (lines) to test aga... read more »