This is the kind of thing that seems to cry out for use of the split command, if your data is reliably separated by a unique string that doesn't appear inside the column values. Once you've got an array, that is when I would apply a (comparatively more expensive and detailed) regex to the array elements I cared about, if it was still necessary.