transformation throwing compilation error
Posted: Wed May 08, 2013 6:45 pm
i have this requiremennt, if input field is "abc123456" then output should be "abc123456," if input is "ab123456" then output should be "ab 123456"(1 space), if input is a123456 output should be "a 123456" (2 spaces), all the time output is 9 varchar, all the time input right(6) will be numbers, i have tried this using 2 stage variables as below
svGrpPolicynumber:
svvariable2:
its throwing big compilation error, how to do this?
svGrpPolicynumber:
Code: Select all
If Len(Trim(A5_I1_I2_Lnk.GroupPolicyNumber_DL))<9 Then Str(' ',9-Len(TrimA5_I1_I2_Lnk.GroupPolicyNumber_DL))):A5_I1_I2_Lnk.GroupPolicyNumber_DL Else A5_I1_I2_Lnk.GroupPolicyNumber_DL
svvariable2:
Code: Select all
Trim(Left(svGrpPolicynumber,3)):Space(9-Len(Trim(A5_I1_I2_Lnk.GroupPolicyNumber_DL))): Right(svGrpPolicynumber,6)
its throwing big compilation error, how to do this?