Enable lexical formatting for number type

[Stephen-Gates]

Desired Behaviour

Support lexical formatting for number type with these additional properties:

• decimalChar
• groupChar
• bareNumber

[Stephen-Gates]

example of why this is needed https://discuss.okfn.org/t/the-csv-standard-need-a-decimal-separator-parameter/6395

Open Knowledge Forums

The CSV standard need a decimal-separator parameter?

This is a question, perhaps a suggestion for Frictionlessdata specs/CSV dialect … or perhaps only an opportunity to say “hello I am in the CSV hell of the decimal-separator interpretation”. Typical problem On my country we use comma as decimal separator, but we accept as human-readable, in data-interchange standards like JSON and CSV, the point as decimal separator. Imagining… I have an originalSpreadsheet with my dataset. I published my dataset as originalSpreadsheet.csv, saving it as CSV w...

[Stephen-Gates]

User interface thoughts:

If type is number, allow entry of:

decimalChar: A string whose value is used to represent a decimal point within the number. The default value is "."

decimal character: Allow for input of a single character - default "."

groupChar: A string whose value is used to group digits within the number. The default value is null. A common value is "," e.g. "100,000"

group character: Allow for input of a single character

bareNumber: a boolean field with a default of true. If true the physical contents of this field must follow the formatting constraints already set out. If false the contents of this field may contain leading and/or trailing non-numeric characters (which implementors MUST therefore strip). The purpose of bareNumber is to allow publishers to publish numeric data that contains trailing characters such as percentages e.g. 95% or leading characters such as currencies e.g. €95 or EUR 95. Note that it is entirely up to implementors what, if anything, they do with stripped text

bare number: checkbox - default checked

Tooltip support on all labels:

• decimal character: Character used to represent a decimal point within the number
• group character: Character used to group digits within the number
• bare number: Ignore leading and trailing non-numeric characters

[Stephen-Gates]

Note the -£1000.00 edge case

frictionlessdata/tableschema-js#144

Ensure it is addressed or write about the limitation on the forum

[Stephen-Gates]

@mattRedBox would it help if I split this into 3 issues:

• decimal character: Character used to represent a decimal point within the number
• group character: Character used to group digits within the number
• bare number: Ignore leading and trailing non-numeric characters

[Stephen-Gates]

Split into #745, #746, #747