Home » Forums » Open Source Learning Center » Question and Answer

need to parse out a field with multiple items in field

Submitted by rdecae on 22 July, 2014 - 18:39

I have a download from our ERP system. It contains 11 fields. the 11th field, is a note/memo field that can contain up to XX number of unique order identifiers. In this field each unique identifier is separated by a space.

I need to parse each unique identifier into it's own ROW. I have attached a file as an example. Any suggestions?

AttachmentSize
file example for excel question on parsing out a multiple value field.xlsx11.21 KB
‹ French Version Excel VBA Code help ›
»