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]
- Posts: 4
- Joined: Thu Feb 18, 2016 9:16 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!
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
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.
Lead Solutions Consultant
Return to “Community Forum”