Reading Scientific Notation from CSV

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
2 posts Page 1 of 1

jbeekman

Posts: 4
Joined: Thu Feb 18, 2016 9:16 am

Post by jbeekman » Wed Nov 23, 2016 9:22 am
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!

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Mon Nov 28, 2016 1:26 pm
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.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1