Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at the jQuery Conference 2011 (Cambridge, MA) with:

Gene Miller

Member since Nov 16, 2010

Recent Blog Comments By Gene Miller

  • UPDATE: Parsing CSV Data Files In ColdFusion With csvToArray()

    Posted on Nov 19, 2010 at 12:56 PM

    Ben, Your comment on listToArray()'s ability to handle empty values is right on. I have to confess I was still running CF7 on my workstation when I tried this some time ago with no luck. I upgraded now and tried it. I think it will solve my problem without using any regEx. Thanks for your advice!... read more »

  • UPDATE: Parsing CSV Data Files In ColdFusion With csvToArray()

    Posted on Nov 18, 2010 at 12:48 PM

    Ben, I had decided to cfloop over the file so I am dealing with just one row at a time. I do have many empty cell though. Wouldn't I loose the empty cells with your suggestion? I just finished a discussion with a friend that suggested I look at CFHTTP and converting to a query instead. His thoug... read more »

  • UPDATE: Parsing CSV Data Files In ColdFusion With csvToArray()

    Posted on Nov 18, 2010 at 12:11 PM

    Ben, My CSV file is tabbed and no, it doesn't double quote anything. I suspect I am working with an unusual circumstance and wouldn't suggest including it in the UDF. I planned on dropping the test for double quoted fields to simplify it for my situation and then adjust the regEx to catch the examp... read more »

  • UPDATE: Parsing CSV Data Files In ColdFusion With csvToArray()

    Posted on Nov 18, 2010 at 10:58 AM

    Stacey, I'm using CF8 and got the same error initially. I commented the line out with no apparent issues. There were a couple other spots I needed to modify for CF8 also, but I didn't document them. My version is working for me, except for the change I am working on for the regEx noted in my prev... read more »

  • UPDATE: Parsing CSV Data Files In ColdFusion With csvToArray()

    Posted on Nov 16, 2010 at 7:09 PM

    Thanks Brian. I tried it with no success. The output array has no more content (or cells) when it hits this field and the input record has several more fields. I'm thinking the regEx that's trying to evaluate it is failing.... read more »

  • UPDATE: Parsing CSV Data Files In ColdFusion With csvToArray()

    Posted on Nov 16, 2010 at 1:47 PM

    I am trying to parse RETS realty listings for a site I'm building. This is exactly what I needed. Works great until I found a record with a field that contained a room dimension as 7'10" x 10'8". Most of the records didn't use single and double quotes like this. Your code stopped on th... read more »