divide one column value without delimiter to multiple column values

MauriceLudo — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have one value field without delimiter

I want to divide the value into three middle left and right values.

Could anyone help me

Best regards

Maurice

Re: divide one column value without delimiter to multiple column values

rubenmarin — Wed, 13 May 2020 15:55:48 GMT

Hi, which characters are used to create the blank spaces? spaces or tabs?

Having some values on the right without anything before, and having some values in the middle one with like looks that there are more than one separator I only see the option the define wich star character will **bleep** as the middle and wich one would count data as right.

Using a mix of Trim(), Subfield(), Mid() and Index() I think it may be done, the most tricky is the firsts ones that only have all empty spaces and data on the right

topic divide one column value without delimiter to multiple column values in QlikView

divide one column value without delimiter to multiple column values

Re: divide one column value without delimiter to multiple column values