2 Replies Latest reply: Oct 11, 2013 7:01 AM by Ralph Graham RSS

    Concat numerous fields in script

      Hello,

       

      I have a table which has 8 fields with Boolean values and am wanting to concat the positive values into one field at the script level (see below example)

       

      00
      IDFieldMovementDeclineForwardSubmitEtcEtc2Etc3Etc4
      1000110
      211110001
      310011100

       

       

      Obviously if there were 2 or 3 Boolean value fields I could do an if statement in the script but because there are 8 there would be too many combinations. Does anyone have a straightforward suggestions as to how I could combine all positive values into one field? Using IDField1 as an example the new field would be 'Etc1; Etc2; Etc3'

       

      Thanks,


      Ralph