Subfield - can't split by ; alone

lukegilligan — Wed, 09 May 2018 06:33:01 GMT

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

Re: Subfield - can't split by ; alone

tresB — Wed, 09 May 2018 06:35:53 GMT

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

topic Re: Subfield - can't split by ; alone in QlikView

Subfield - can't split by ; alone

Re: Subfield - can't split by ; alone