4 Replies Latest reply on Jun 16, 2013 6:53 AM by Vite DBA

    Breaking a column with multiple pieces of data into separate rows


      So I have a form on a table with a field where users enter multiple order numbers into the order field.  I have another table with information on particular orders that I want to join by order with the other table.  Is there a way to break down the field with multiple order numbers so that each order in the field becomes a new row with the other information duplicated?  I can imagine that this would create a problem that if not formatted correctly, the process either wouldn't work or would add a space at the beginning of the order number, can this be prevented?  I am using Apex 4.1