So I recently discovered the FLOAT function trying to figure out how to get rid of dollar symbols and commas in my CSV exports. I’m curious if there’s a simpler, more efficient way of doing this. Presently I have to create a view, and then use the expression (FLOAT(table.column)) for every single field that is a CURRENCY data type. Without doing that, the exported CSV text file displays the dollar symbols in addition to placing the value within quotes… as though it were a string. If there were some way I could just say… export this and convert all currency data types into real or double data types… that would be pretty sweet.
Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 505-627-4415
