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