5 Replies Latest reply: Oct 2, 2014 7:41 PM by Jonathan Poole RSS

    Subfield Command

    David Young

      My data in my table appears like:


      EventID       EventDate

      1                    9/1/2014 (carriage return)

                            9/2/2014 (carriage return)

                            9/3/2014 (carriage return)


      What I want to end up with is:

      Event ID       EventDate

      1                    9/1/2014

      1                    9/2/2014

      1                    9/3/2014


      Dropping the carriage return and duplicated the EventID.  I would like to do this in the load statement because for each EventID there could be a different number of dates. 


      I have been trying the Subfield function and cant get it to work.  Any help would be great.