From 413b86050e364db51eb4f1bb095f70b141c02919 Mon Sep 17 00:00:00 2001 From: Sébastien Dailly Date: Wed, 8 Jan 2025 13:14:40 +0100 Subject: Updated the examples --- examples/example_csv.toml | 4 ++-- 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)", -- cgit v1.2.3