<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Newbie Questions</title><link>https://www.infopathdev.com:443/forums/39.aspx</link><description>New to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Excel Cell validation formula conversion into InfoPath validation formula</title><link>https://www.infopathdev.com:443/forums/thread/102527.aspx</link><pubDate>Thu, 14 May 2015 20:58:37 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:102527</guid><dc:creator>Bre Huston</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/102527.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=102527</wfw:commentRss><description>&lt;p&gt;Hi Jari,&lt;/p&gt;
&lt;p&gt;What you&amp;#39;ll want to do is use&amp;nbsp; validation rule on the text box. There are default patterns, and you can also create your own. You can set a pattern to be compared to an entry, and also give the user an error if they enter data that does not match the pattern.&lt;/p&gt;
&lt;p&gt;In this case, you could use the custom pattern: \d\d\d\d\d\d\-\d\d\d\d&lt;/p&gt;
&lt;p&gt;The condition would be, if FieldWithValue does not match pattern \d\d\d\d\d\d\-\d\d\d\d&lt;/p&gt;
&lt;p&gt;Hope that helps!&lt;br /&gt;Bre&lt;/p&gt;</description></item><item><title>Excel Cell validation formula conversion into InfoPath validation formula</title><link>https://www.infopathdev.com:443/forums/thread/102463.aspx</link><pubDate>Fri, 08 May 2015 12:57:16 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:102463</guid><dc:creator>Jari Kopakkala</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/102463.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&amp;PostID=102463</wfw:commentRss><description>&lt;p&gt;Hi,&lt;/p&gt;&lt;p&gt;&amp;nbsp;I have a following formula in my Excel Form:&lt;/p&gt;&lt;p&gt;=IF(RIGHT(A1;1)=MID(&amp;quot;0123456789ABCDEFHJKLMNPRSTUVWXY&amp;quot;;MOD(LEFT(A1;6)&amp;amp;LEFT(RIGHT(A1;4);3);31)+1;1);&amp;quot;ok&amp;quot;;&amp;quot;Error&amp;quot;)&lt;/p&gt;&lt;p&gt;&amp;nbsp;It validates the value in a cell A1.&amp;nbsp; Data to be validated is Finnish social security number, like: 120365-5312 (fictional but valid)&lt;/p&gt;&lt;p&gt;&amp;nbsp;How to build a similar validation formula in a InfoPath Text Box Control?&lt;/p&gt;&lt;p&gt;&amp;nbsp;Cheers,&lt;/p&gt;&lt;p&gt;&amp;nbsp;Jari &lt;br /&gt;&lt;/p&gt;</description></item></channel></rss>