Hi, I was given a table that has a long string that consists of "chunks" of items of data separated by a semicolon. For example: [1111-AA-222; 1112-AB-333; 1113-BB-999]. I need to create a table or query that contains one of the other fields (Project number) and then one row for each "chunk" of data in the long string. So the table would look like this:
ProjectNumber / Item
12345 / 1111-AA-222
12345 / 1112-AB-333
12345 / 1113-BB-999
98765 / 2222-ZZ-999
98765 / 2224-YY-888
I have no problem creating the code to parse the Items out of the long string and into an array. The problem is I don't know how to get it into a table (or query) once I do.
Can you help?