# CSV Import - Decimal point error **URL:** \ **Category:** Uncategorized\ **Created:** [June 28, 2018, 5:13pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388 "2018-06-28T17:13:18Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Colacino](https://avatars.discourse-cdn.com/v4/letter/c/6a8cbe/32.png) [@Colacino](https://community.dremio.com/u/Colacino)\ **Post date:** [June 28, 2018, 5:13pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/1 "2018-06-28T17:13:18Z")
When I import CSV file the Integer and Float fields are not reconized. I can´t convert to INT or FLOAT inside Dremio too. I try to replace “.” with “,”. The same result. Something related to char encoding? ![dremio](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/eb44bbcc77d509cb168981f9d6a76caa85a8c8b0.png) ---
**Author:** ![Colacino](https://avatars.discourse-cdn.com/v4/letter/c/6a8cbe/32.png) [@Colacino](https://community.dremio.com/u/Colacino)\ **Post date:** [June 28, 2018, 5:30pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/2 "2018-06-28T17:30:57Z")
Ok. I founded the problem. The SAP BW export INT and FLOAT + " " (blank space) before the separator “;” ---
**Author:** ![doron](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/doron/32/294_2.png) [@doron](https://community.dremio.com/u/doron)\ **Post date:** [June 28, 2018, 6:10pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/3 "2018-06-28T18:10:32Z")
If I understand correctly, your field had a whitespace character at the start of each value in the column? We show certain hidden characters in the preview (such as newline chars) but we are not treating whitespace at the start/end as hidden. I have opened an internal ticket for that as that can be quite frustrating. ---
**Author:** ![bisware](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/bisware/32/4125_2.png) [@bisware](https://community.dremio.com/u/bisware)\ **Post date:** [May 3, 2022, 3:24pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/4 "2022-05-03T15:24:13Z")
I have the same problem. Can I specify any Localization setting for import/transformation file? ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [May 5, 2022, 5:26pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/5 "2022-05-05T17:26:52Z")
@bisware What is your file format? CSV? ---
**Author:** ![bisware](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/bisware/32/4125_2.png) [@bisware](https://community.dremio.com/u/bisware)\ **Post date:** [May 5, 2022, 6:47pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/6 "2022-05-05T18:47:06Z")
Yes, CSV in Italian format ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [May 9, 2022, 10:30pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/7 "2022-05-09T22:30:59Z")
@bisware Is the data confidential, any chance you can share a sample CSV? ---
**Author:** ![bisware](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/bisware/32/4125_2.png) [@bisware](https://community.dremio.com/u/bisware)\ **Post date:** [May 10, 2022, 12:34pm UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/8 "2022-05-10T12:34:37Z")
Sure, here is the flat file. [Piano.zip](https://community.dremio.com/uploads/short-url/clP2eN3rhX3IiSGr11UhCf5YK3N.zip) (4,1 KB) ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [May 13, 2022, 5:37am UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/9 "2022-05-13T05:37:17Z")
@bisware I am able to convert column ““Numero rata”” to FLOAT using CAST but not the columns like `TotaleRata`, is it possible to try without the comma in the values? Like use `5085425179` instead of `508,5425179` ---
**Author:** ![bisware](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/bisware/32/4125_2.png) [@bisware](https://community.dremio.com/u/bisware)\ **Post date:** [May 13, 2022, 9:19am UTC](https://community.dremio.com/t/csv-import-decimal-point-error/1388/10 "2022-05-13T09:19:27Z")
Maybe no, because the Italian format use “point” for thousands separator and “comma” for decimal separator.