Controlshttps://www.infopathdev.com:443/forums/43.aspx enCommunityServer 2007 SP3 (Build: 31118.962)Re: Applying function in Calculated Fieldhttps://www.infopathdev.com:443/forums/thread/102882.aspxFri, 19 Jun 2015 22:44:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:102882Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/102882.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=102882<p>&nbsp;I think you have the formula backwards - substring-before(field_name, &quot;,&quot;)</p>Applying function in Calculated Fieldhttps://www.infopathdev.com:443/forums/thread/102877.aspxFri, 19 Jun 2015 06:57:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:102877vish_0450https://www.infopathdev.com:443/forums/thread/102877.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=43&PostID=102877Hi Folks, I have a form with a drop-down field. The drop-down fetches value from database. The format of the value is.... SD123,Name. After the form is submiited a view is opened to print the form. In which in the calulated value field SD123,Name is displayed. I want to display only SD123 (i.e crop details after ,) i tried using function substring-before(&quot;,&quot;, field_name) but its not working. I cannot add new fields to do this as the existing form will show blank for the same. Kindly help. Thanks in advance.