Mif Posted July 19, 2007 Share 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" Link to comment Share on other sites More sharing options...
sbg2 Posted July 19, 2007 Share Posted July 19, 2007 Left(action_scores::goal_score _perAction_textversion; Length(action_scores::goal_score _perAction_textversion) - 2) & action_scores::score Link to comment Share on other sites More sharing options...
Mif Posted July 19, 2007 Author Share Posted July 19, 2007 Thank you very much! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6126 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