https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/96697.aspxThu, 27 Mar 2014 08:40:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96697donstephen0https://www.infopathdev.com:443/forums/thread/96697.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=96697<p>Hi roadman1977,</p><p>Welcome to InfopathDev</p><p>I would suggest using a formula such as the one below. What it does is that it returns the last two characters of a string, and from there use a rule which is triggered by a condtion that if the populated field is not equal to numbers, then set a certain field to a value of 0.<br /><br />substring(<strong>field1</strong>, string-length(<strong>field1</strong>) - 1, 2)</p><p>where <strong>field1</strong> is the username field.</p><p>Please let me know if this helps.</p>https://www.infopathdev.com:443/forums/thread/96544.aspxThu, 20 Mar 2014 14:30:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96544roadman19770https://www.infopathdev.com:443/forums/thread/96544.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=96544<p>I have a username field that contains both letters and numbers.&nbsp; I have another field (number type) that extracts the numbers from the username field.&nbsp; The username field contains a variable number of characters.&nbsp; The numbers can be located in any position in the username field.&nbsp; If the last two characters in the username field do not contain numbers I want to make the number type field equal to 0.</p> <p>Is this possible??</p>