Prevent subfield from returning last value

[mwscott1]

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;

[mato32188 · Accepted solution]

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), ';').

BR

M