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
Modify Stage Conversions.
Moderators: chulett, rschirm, roy
Modify Stage Conversions.
Every person you meet knows something you don't, Learn from them.
-- H. Jackson Brown
-- H. Jackson Brown
Try using "CART:string[7]=substring[0,7] (Mat)"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Every person you meet knows something you don't, Learn from them.
-- H. Jackson Brown
-- H. Jackson Brown
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: