973-584-9100 contactus@bardess.com

If you are like me, you probably use SubField a lot. I had used it for years before I stumbled across one of its most powerful features in someone else’s code. If you do not provide the position parameter, it will expand a record for each delimited value.

I’ve worked with a few older databases that liked to store arrays within a single column. This is a perfect example of where it comes in handy.



Which results in: