This discussion is archived
4 Replies Latest reply: Jun 15, 2013 11:53 PM by Vite DBA RSS

Breaking a column with multiple pieces of data into separate rows

switbeck Newbie
Currently Being Moderated

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