Hi 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(",", 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.