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
... View more