6 Replies Latest reply: Feb 3, 2017 7:31 AM by James Hanify RSS

    Delimiting out and storing properly for an applymap

    James Hanify

      Hi all,

       

      I've come into a scenario where I need to try and delimit out data which is on the same line and put them as new lines, i'm assuming some kind of loop is required but any assistance would be great.

       

      My data structure is relatively simple as I use an SQL query to limit the results

       

      Example data:

       

      KeyMessage
      JIGS*SALE*I1234

      on Despatch # D123 D124

      JIGS*SALE*I1235on Despatch # D125 D126 D127
      JIGS*SALE*I1236on Despatch # D128 D130 D131

       

      Turns into:

       

      KeyMessage
      JIGS*SALE*I1234D123
      JIGS*SALE*I1234D124
      JIGS*SALE*I1235D125
      JIGS*SALE*I1235D126
      JIGS*SALE*I1235D127
      JIGS*SALE*I1236D128
      JIGS*SALE*I1236D130
      JIGS*SALE*I1236D131

       

      Many thanks!

       

      James