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






      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)