topic Split Column by Varying Delimiters in Data Movement & Streaming

Split Column by Varying Delimiters

lenangake — Wed, 19 Mar 2025 23:02:17 GMT

The goal is to split a column by varying delimiters. All of the items to split have different character lengths. How would you go about this in the script editor? Please see below (Current Example Column vs. Expected Output).

Re: Split Column by Varying Delimiters

Mark_Little — Mon, 10 Jul 2023 14:54:35 GMT

Hi,

I think you are missing your examples.

But i would Start by looking at the Subfield function.

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/StringFunctions/SubField.htm