If your text file data source contains double quotes (""), ignore them when creating transformation rules. The double quotes will be removed by Essbase during the cube deployment process. For example, for a text value "2000-01-01" where double quotes are included, you should use substr(1,4) to derive the year value of 2000.