http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/15384.aspxMon, 07 Jan 2013 17:58:33 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:15384Method_Adam0http://forums.method.me/cs/forums/thread/15384.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=15384<p><span id="mce_0_start" style="overflow:hidden;">Annette,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>You can use the Character function to get the length of the value first, then use a basic math calculation&nbsp;to trim 9 from the length<span id="mce_12_start" style="overflow:hidden;"> value</span>. &nbsp;<span id="mce_2_start" style="overflow:hidden;"></span><span id="mce_4_start" style="overflow:hidden;"><span id="mce_16_start" style="overflow:hidden;">You can then use&nbsp;</span></span>Get right as you would know the length after the colon.<span id="mce_11_start" style="overflow:hidden;"></span></p> <p>- Adam<span id="mce_6_start" style="overflow:hidden;"><span id="mce_13_start" style="overflow:hidden;"><span id="mce_14_start" style="overflow:hidden;"></span></span></span></p>http://forums.method.me/cs/forums/thread/15382.aspxMon, 07 Jan 2013 16:49:45 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:15382VARC_Annette0http://forums.method.me/cs/forums/thread/15382.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=15382<p>Hi,</p> <p>Can someone please point ne in the right direction on this? I am trying to use &quot;Enter Value into Field on Screen&quot; but I want to trim the first 9 characters. (It is either Billable: or Overhead:)</p> <p>I have been through all the functions and have tried different combinations of them - but not working yet.</p> <p>I see join with space, comma, etc. But is ther<span id="mce_0_start" style="overflow:hidden;">e</span> somehow to split it?</p> <p>Get right doesn&#39;t work because the information after the colon is various lengths.&nbsp;</p> <p>Get left doesn&#39;t work because it just gives me Billable: or Overhead: which I want to remove.<span id="mce_1_start" style="overflow:hidden;"></span></p> <p><span style="overflow:hidden;">Thank you,</span></p> <p><span style="overflow:hidden;">Annette</span></p> <p></p>