nfp's Introduction

NFP (Number Format Parser)

Using NFP (Number Format Parser) you can get an Abstract Syntax Tree (AST) from Excel number format expression.

Installation

go get github.com/xuri/nfp

Example

package main

import "github.com/xuri/nfp"

func main() {
    ps := nfp.NumberFormatParser()
    tokens := ps.Parse("_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(@_)")
    println(p.PrettyPrint())
}

Get AST

<Positive>
      <RepeatsChar>
    # <HashPlaceHolder>
    <ThousandsSeparator>
    ## <HashPlaceHolder>
    0 <ZeroPlaceHolder>
    . <DecimalPoint>
    00 <ZeroPlaceHolder>
<Negative>
      <RepeatsChar>
    ( <Literal>
    # <HashPlaceHolder>
    , <ThousandsSeparator>
    ## <HashPlaceHolder>
    0 <ZeroPlaceHolder>
    . <DecimalPoint>
    00 <ZeroPlaceHolder>
    ) <Literal>
<Zero>
      <RepeatsChar>
    - <Literal>
    ?? <DigitalPlaceHolder>
<Text>
    @ <TextPlaceHolder>

Contributing

Contributions are welcome! Open a pull request to fix a bug, or open an issue to discuss a new feature or change.

Licenses

This program is under the terms of the BSD 3-Clause License. See https://opensource.org/licenses/BSD-3-Clause.

nfp's People

Stargazers

Watchers

nfp's Issues

Slow number parsing due to conversion from `string` to `[]rune`

Description

Number parsing is slow because of unnecessary conversions from string to array of runes. The code treat them as if those are free, but due to Golang strings being immutable, that is not the case.

Steps to reproduce the issue:
All uses of the library are affected.

Support date formats with dot separator such as DD.MM.YYYY

Is your feature request related to a problem? Please describe.
When using excelize to read an Excel workbook with dates formatted as DD.MM.YYYY it results in ..YYYY, e.g. 18.11.2023 is parsed as ..2023.

Describe the solution you'd like
Once the parser sees the dot ., it interprets this as a TokenTypeDecimal and discards the preceding datetime values, e.g. parsing MM. results in a . token.
I want to see an MM token of TokenTypeDatetime and a . of type TokenTypeLiteral being added to the tokens list.

Describe alternatives you've considered

Additional context

Recommend Projects

xuri / nfp Goto Github PK

nfp's Introduction

NFP (Number Format Parser)

Installation

Example

Contributing

Licenses

nfp's People

Stargazers

Watchers

Forkers

nfp's Issues

Slow number parsing due to conversion from `string` to `[]rune`

Support date formats with dot separator such as DD.MM.YYYY

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent