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
