Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
- 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”