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 CFUNITED 2010 (Landsdown, VA) with:

Troy

Member since Dec 11, 2008

Recent Blog Comments By Troy

  • 19.0 Must Be Within Range: ( 1 : 12 )

    Posted on Nov 3, 2009 at 2:43 PM

    I recently had a similar ColdFusion error with no line number information to help: 11.0 must be within range: ( 1 : 7 ) The date in my Form variable was "11/11/2009" and I was doing this: DayOfWeekAsString(Day(Form.menu_dt) After finding this blog entry, I quickly discovered I was out of the ran... read more »

  • cf.Objective() Photo Raffle With Me (Ben Nadel)

    Posted on May 21, 2009 at 11:48 AM

    so who won the prize?... read more »

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

    Posted on Oct 13, 2007 at 8:37 PM

    I found a dumb mistake in my code and now my TAB parsing works with Chr(9). I would like the final blank line to be ignored if it's a simple tweak Ben can make. But not a showstopper, and I'm grateful to Ben for all his help, good stuff!... read more »

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

    Posted on Oct 12, 2007 at 1:07 PM

    That's what I noted I tried in the first comment I made "Chr(9)". Maybe you need to translate that inside the UDF to "\t" in the places needed in your regex lines of code?... read more »

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

    Posted on Oct 12, 2007 at 12:07 PM

    I was using the double hash to escape them. I thought you wanted the single hashes passed into the UDF. Using your way, CF throws this error: Variable CHAR is undefined.... read more »

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

    Posted on Oct 12, 2007 at 11:40 AM

    Ok, I see there is a carraige return at the end of the final row of data in my CSV files and then a final line that is blank. After I removed the blank line, all was well. However, your old UDF seemed to account for this case and handled it gracefully, not putting the blank line into the array of a... read more »

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

    Posted on Oct 12, 2007 at 11:04 AM

    In the previous UDF, I would pass in "Chr(9)" for a TAB. This is not working now, nor is passing in "\t". What is needed in this new regex UDF to represent TAB? It looks like the example you show for overriding TAB delimiter just has a space " ". Also, I'm seeing an extra array element which is e... read more »

  • Steven Levithan Rocks Hardcore (Regular Expression Optimization Case Study)

    Posted on Oct 11, 2007 at 3:20 PM

    Thanks Ben, looking forward to the new and improved UDF. The speed is incredibly faster and is going to make my client very happy. And if you can make it support the TAB delimiter, all the better. In the old UDF, a 184KB CSV file with 1000 rows took 35.59 sec to parse. in the new UDF, the same fil... read more »

  • Steven Levithan Rocks Hardcore (Regular Expression Optimization Case Study)

    Posted on Oct 11, 2007 at 1:41 PM

    How would you go about this if the delimeter were a TAB character. I tried adding "|\t" in the line where you have "\G(,|\r?\n|\r|^)", but this didn't seem to work. Also, can you incorporate this into a function like you did in your original blog post, so the data, delimiter, file, and qualifier c... read more »