Prevent subfield from returning last value

mwscott1 — Mon, 27 Sep 2021 18:44:17 GMT

I am using subfield in the load to separate out each response using “;” as the delimiter. The problem is the data has a “;” at the end which causes it to return a value. Is there a pay to exclude the last “;” in the load?

LOAD [What would further enhance your experience?],
SubField([What would further enhance your experience?],';') as [Experience]

Data Example

What would further enhance your experience?

A better understanding of the compensation structure;More information around resources available;

A defined mentor/resource;More information around resources available;A better understanding of the compensation structure;More opportunities for independent learning;

Re: Prevent subfield from returning last value

mato32188 — Mon, 27 Sep 2021 18:56:54 GMT

Hi @mwscott1,

first try to remove last ";", i.e. use LEFT(YourField,LEN(YourField)-1) and secondly merge with subfield.

SUBFIELD( LEFT (YourField, LEN(YourField)-1), ';').

topic Re: Prevent subfield from returning last value in QlikView

Prevent subfield from returning last value

Re: Prevent subfield from returning last value