Page 1 of 1

Reading Scientific Notation from CSV

Posted: Wed Nov 23, 2016 9:22 am
by jbeekman
I'm having trouble reading scientific notation from a CSV. I am trying to convert to DECIMAL using the Read CSV task using different patterns, but I can't get past this error:
Column data '3.2e+06' is not valid for its data type 'DECIMAL'

I've tried using various patterns with 'E' such as 'E##' etc., but I'm not even sure I'm on the right track.

I would really appreciate help with this. Thank you in advance!

Re: Reading Scientific Notation from CSV

Posted: Mon Nov 28, 2016 1:26 pm
by Support_Rick
Currently, there isn't an internal function in GAMFT that will allow this conversion directly.

Reading the field should be character, not numeric (decimal) -- due to the + or - signs included in the value.

You can read the value as Character, then utilize an SQL function to convert to Decimal as an option.