Split Column function

[goalnightx]

Hello. I am looking to break out the following data into separate fields either via query update or VBA so that each has it's own column in my database:


Looking for results like this (example of first two rows of attached screenshot):

Primary1 Primary2 Primary3
actor soundtrack none


actor soundtrack music_department

Thank you in advance. It is much appreciated! G

There would be no more than four new fields and always separated by the comma delimiter

[Welshgasman]

Look at the split() function. However split not available in query, so you would need a wrapper function for it in a query.

[Micron]

Probably lots more Google results than this one, which ought to get you going. Just adapt for comma separated values rather than spaces as shown.

https://probiztechnology.com/blog/20...st-last-names/

[June7]

Is that really a comma separated value and not a multi-value field?

What if you eventually want to associate more than 4 professions? What you want is not a normalized structure. That would call for one field in a related dependent table where each profession would be a record.

However, it's a balancing act between normalization and ease of data entry/output. What you want might be satisfactory for your situation or it might be a headache.