Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
hi - I am using Import CSV to Database smart service and facing issues with some of the rows/records in the CSV.
For one of the records it give NumberFormatExceptions e.g "VALE SA-SP ADRCLIENT REF 41807091" .
Plug-in is not able to read entire string instead it gives me java.lang.NumberFormatException: For input string: "CLIENT REF 41807091"" . In DB(MySQL) I am capturing this field as VARCHAR (35) .
Is there any limitation in terms of data/text which should be in CSV file ?
Please suggest !