diff options
| author | Sébastien Dailly <sebastien@dailly.me> | 2025-01-08 13:14:40 +0100 |
|---|---|---|
| committer | Sébastien Dailly <sebastien@dailly.me> | 2025-01-08 13:14:57 +0100 |
| commit | 413b86050e364db51eb4f1bb095f70b141c02919 (patch) | |
| tree | c46bbbfdb3aeafbd27b487ae051441da2085e876 | |
| parent | 9473b2c009961d2e66a31673c38831b59528b706 (diff) | |
Updated the examples
| -rw-r--r-- | examples/example_csv.toml | 4 | ||||
| -rw-r--r-- | examples/importer.toml | 9 |
2 files changed, 6 insertions, 7 deletions
diff --git a/examples/example_csv.toml b/examples/example_csv.toml index 1374515..5586750 100644 --- a/examples/example_csv.toml +++ b/examples/example_csv.toml @@ -19,13 +19,13 @@ version = 1 [sheet] columns = [ ":A", - "concat(\"-\", :A, :target.E, :B)", + "join('-', :A, :target.E, :B)", ":C", """counter( [:C], [:A])""", ":E", - "match(\"\\(..\\)\", :B)", + "match('(..)', :B)", ":D", "counter([:D] ,[:A])" ] diff --git a/examples/importer.toml b/examples/importer.toml index 4be6618..08e9e25 100644 --- a/examples/importer.toml +++ b/examples/importer.toml @@ -1,5 +1,3 @@ -version = 1 - [source] file = "financial.xlsx" name = "source" @@ -19,12 +17,13 @@ version = 1 [sheet] columns = [ ":target.A ^ '\\''", # Ensure the quote is escaped before sending to the sql engine - "concat('-', :A, :target.E, :B)", + "join('-', :A, :target.E, :B)", ":C", "counter([:C], [:A])", "sum(:F, [:B, :C, :D], [:B])", - "int(1) = counter([:C], [:A])", - ":E", "match('(..)', :B)", + "1 = counter([:C], [:A])", + ":E", + "match('(..)', :B)", ":D", "counter([:D], [:A])", "year(:N)", |