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!
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.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: Reading Scientific Notation from CSV
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.
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696