Subfield - can't split by ; alone

[lukegilligan]

I have a string of data contained within a field that has semi colons (;) as the delimiter, this would normally be easy to split out using subfield([field],';',1) however in this circumstance there are also semi colons through out the text in the field resulting in splits in the data where I do no want it to split.

Within the data after a correct delimitation, there is a date that I am hoping to use in conjunction with the semi colon to be able to split the data.

I attempted to use a code like this, however it didn't work:

SUBFIELD([field],

   (LIKE '; 0' OR

     LIKE '; 1' OR

     LIKE '; 2' OR

     LIKE '; 3' OR

     LIKE '; 4' OR

     LIKE '; 5' OR

     LIKE '; 6' OR

     LIKE '; 7' OR

     LIKE '; 8' OR

     LIKE '; 9' OR

     ),1)

Any suggestions on how I can do this?

Thanks

Luke

[tresesco]

Could you share a sample data set and expected output against that?