Tuesday, January 3, 2017

regex tool

http://www.regexr.com/v1/desktop/

download desktop version

replace 1 with 2016

I have a database with year value 1=>2016, 2=> 2017, 3=>2015

use Pentaho data integration transformation

^.{0,1}[1]$ is used to match 1 with length 1
^.{0,1}[2]$ is used to match 2 with length 1
....




No comments:

Post a Comment