Mif Posted July 19, 2007 Posted July 19, 2007 I want to replace the last two characters in a field called "goal_score_perAction_textversion" with the value of the field called "score". eg: goal_score_perAction_textversion "g100_s45" score value is "70" I want the result "g100_s70" My current calcualation; Replace ( action_scores::goal_score_perAction_textversion; Right ( action_scores::goal_score_perAction_textversion; 2); 2; action_scores::score) is producing this; "g100_s4570"
sbg2 Posted July 19, 2007 Posted July 19, 2007 Left(action_scores::goal_score _perAction_textversion; Length(action_scores::goal_score _perAction_textversion) - 2) & action_scores::score
Recommended Posts
This topic is 6397 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now