Benetl, a free ETL tool for files working with postgreSQL and MySQL
Benetl is a free ETL tool
an ETL to easily manage csv/txt/xls/json files
Benetl, a free ETL tool for files working with postgreSQL and MySQL, is forteen years old! 88704
downloads

Home page > Documentation > 19. Interesting example

19. Interesting example


Interesting example

In this example we are using two extra fields, a regular expression and a if condition (brought by Benetl version 3.5).

The aim is: if the field value1 contains the substring "asa" then we retrieve the value of this field except asa (value1 value without "asa").

Otherwise (if value1 doesn’t contain "asa" we give the value "rien" (nothing in french)).

The datasource file "test3.txt" is:

entity;date;value1;value2
guillaume;16/04/2009;diasafi;sipo
ben;15/03/2009;olasaps;iksipo
thom;16/02/2009;pifo;ospo

It has 4 columns, the two last columns contain the values.

You can download the whole example at: test3.zip


Site Map -  Contact: benoit@benetl.net
Benoît Carpentier - Benetl a free ETL tool - Copyright (c) 2007 - 2024


Search Engine Optimization and SEO Tools