Skip to content

CSV - looking for import option to define decimal separator #1347

Open

Description

@zwrmueller

Hi,

in the import dialog for csv data files I miss the choice to define the decimal separator as well as the separator for the 1000-notation.

I guess it could be usefull to define field type by column, so that the decimal separator definition could be applied to numeric fields only.

Regards
Ralf

Useful extra information

I'm opening this issue because:

  • DB4S is crashing
  • DB4S has a bug
  • [x ] DB4S needs a feature
  • DB4S has another problem

I'm using DB4S on:

  • [ x] Windows: ( version: 7_ )
  • Linux: ( distro: ___ )
  • Mac OS: ( version: ___ )
  • Other: ___

I'm using DB4S version:

  • 3.10.1
  • 3.10.0
  • 3.9.1
  • [x ] Other: 3.10.99_

I have also:

Activity

  1. justinclift commented on Mar 14, 2018

    @justinclift
    Member

    Sounds like a good idea to me. 😄

  2. zwrmueller commented on Mar 16, 2018

    @zwrmueller
    Author

    well, well, you're my man ;-)

  3. mgrojo commented on Dec 19, 2020

    @mgrojo
    Member

    @zwrmueller This has finally been implemented. There is a new option in the Import CSV as table dialog, under Advanced: Use local number conventions. If your locale is Spanish (Spain) or German (Germany), for example, it will use , as decimal separator and . as thousands separator. Could you confirm that is working well for you using the next nightly build?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions