7 Replies Latest reply: Nov 26, 2013 9:58 AM by Stefan Wühl RSS

    Using SUBFIELD for Comma seperated values

    Alan Farrell

      Hi All,

       

      I have a field containing data like

       

      AL , R , 267593 ,

       

       

      I can use the SUBFIELD Function to seperate the data with a result of

       

      AL

      R

      267593

       

      But I also get a blank field because of the last comma, how can I remove these blank fields?

       

      All the data in the field ends with a , (comma)