Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

divide one column value without delimiter to multiple column values

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

1 Solution

Accepted Solutions
rubenmarin

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

View solution in original post

1 Reply
rubenmarin

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