Field data not displayed

[kmattern]

I have a CSV table that lists the following fields:

date, time, location, received, authorized

It looks like this

12/9/2010,3:00:00,NewYork,5,5 
12/9/2010,3:00:00,NewJersey,11,11 
12/9/2010,3:00:00,Maine,11,11 
12/9/2010,3:00:00,Colorado,11,11 
12/9/2010,3:00:00,Virginia,7,7 
12/9/2010,3:00:00,Pennsylvania,0,11 
12/9/2010,3:00:00,Wyoming,15,15 
12/9/2010,3:00:00,Washington,12,12 
12/9/2010,3:00:00,California,11,11 
12/9/2010,3:00:00,NewMexico,4,14 
12/9/2010,3:00:00,Alabama,6,6 
12/9/2010,3:00:00,Florida,11,11 
12/9/2010,3:00:00,Ohio,3,3 
12/9/2010,3:00:00,Vermont,11,11 

I have tried both of these transforms

[RecAuthz] 
REGEX = ([0-9]+/[0-9]+/[0-9]+)\s([0-9|:]+)\s(\S+)\s(\d+)\s(\d+) 
FORMAT = date::$1 time::$2 account::$3 received::$4 authorized::$5 

[RecAuthz] 
DELIMS = " "
FIELDS ="date","time","account","received","authorized" 

In either case I get the received value but authorized is always blank, not zero but NULL or empty.

Any idea why?

Thanks

[hulahoop]

I'm not sure how both transforms are partially working. In the first transform, REGEX should use "," not "\s" as the separator. In the 2nd transform, DELIMS should be ",".