Reading Scientific Notation from CSV

If you have a new question you’d like our support staff to post a response to, please visit our customer community, GoAnywhere Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at https://insiders.goanywhere.com.

If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
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