topic Split Text in a field without seperating words in QlikView

Split Text in a field without seperating words

hbuchetmann — Sat, 16 Nov 2024 20:18:29 GMT

Hello Qlikview-Community,

i am looking for a solution to the following problem:

Ich have a text field = Name in a table with up to 80 chars long.

I want to seperate it into two textfields Name1 and Name2, but without sperating words.

Example:

Namefield=This is a text which is much much much longer than 40 chars, but not longer than 80

LEFT(Namefield,40) AS Namefield1 = This is a text which is much much much l

RIGHT(Namefield,40) AS Namefield2 = onger than 40 chars, but not longer than 80

Is there a away to avoid seperating single words dynamically?

Re: Split Text in a field without seperating words

sunny_talwar — Wed, 07 Aug 2019 11:21:41 GMT

In this case, where would you want the longer to show up? First Half or Second half and why?? or does it not matter?

Re: Split Text in a field without seperating words

hbuchetmann — Wed, 07 Aug 2019 11:28:17 GMT

The length of Namefield1 should not exceed 40 chars, so the longer should go completly to Namefield2

Re: Split Text in a field without seperating words

sunny_talwar — Wed, 07 Aug 2019 18:19:31 GMT

Try this

Table: LOAD *, Index(Left(Namefield, 40), ' ', -1) as SpacePos, Left(Namefield, Index(Left(Namefield, 40), ' ', -1)) as Namefield1, Right(Namefield, Len(Namefield) - Index(Left(Namefield, 40), ' ', -1)) as Namefield2; LOAD * INLINE [ Namefield "This is a text which is much much much longer than 40 chars, but not longer than 80" "This is a text which is much much longer than 40 chars, but not longer than 80" "This is a text which is much longer than 40 chars, but not longer than 80" ];

Re: Split Text in a field without seperating words

hbuchetmann — Wed, 07 Aug 2019 18:43:11 GMT

Thank you very much Sunny_talwar,

i just tired it out and it works like a charm!

Best wishes,

Hermann