DSXchange

Hi,
I am trying to do 3 conversions on 3 different columns and i am using Modify Stage.
1) trim to 7 characters on CART
2) trim SITE
3) @null on MIN_PRES.

Code:

CART:string(7)=substring[0,7] (Mat)
SITE=string_trim(Plant)
MIN_PRES=make_null()

I get the following errors after the run.

Error:

main_program: Error parsing modify adapter: Error in binding: Expected '=', got: "("
Expected destination field selector, got: ")"; input:
CART:string(7)=substring[0,7] (Mat)
;
SITE=string_trim(Plant)
;
MIN_PRES=make_null()


I am not sure where i am going wrong. kindly advice.

Thanks

Try using "CART:string[7]=substring[0,7] (Mat)"

Square brackets not parentheses. string[7] rather than string(7).

Thanks Arnold and Ray,
I did use [] after posting the topic but it didnt work and coming to other 2 columns, please suggest what is wrong. As i did try converting each columns in a seperate job to see what is wrong but i get the same error message.

Please post the record schema from the input link and from the output link. You can most easily get these from the generated OSH.