Skip to content

Wishlist : import percent or currency formatted data #1147

Open
@Pascal-ascii

Description

@Pascal-ascii

As for dateformat, it would be nice to be able to define currency or percent format and to import columns directly as float values instead of strings.

For example
if specified currency="$", "$100" would import as 100
if specified currency="€", "90€"' would import as 90
if specified percent="%", "50 %" would import as 50

An alternative could be to just be able to ignore characters or substrings:

For example;
if specified ignore="CHF", a column containing "70.00 CHF" would be considered as 70.00 and imported as Float 70.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions