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