topic Re: manipulate strings in QlikView

manipulate strings

Thu, 25 Jul 2013 18:58:06 GMT

how can i manipulate strings on qlikview?

have i make the code in the script field or in the expression field?

rustyfishbones — Thu, 25 Jul 2013 19:00:48 GMT

You can do it in both

However there are functions that cannot be used in the script and vice versa

Better to try do most of it in the script as its less maintenance

Thu, 25 Jul 2013 19:28:38 GMT

thanks alan

in my case, i want to "break" a string. Take a part of it that i don't wanna to cross data better.

do you now some function on qlikview that i can do this?

thank you for your help and sorry any english mistake

MayilVahanan — Thu, 25 Jul 2013 20:03:24 GMT

Try with

Textbetween() , subfield(), left(), right(), mid() and so far for get the string as you like from original string

rustyfishbones — Thu, 25 Jul 2013 23:06:44 GMT

You can also use PURGECHAR ()

KEEPCHAR ()

REPLACE ()

MID () INDEX ()

I have lots of videos on youtube that will show you some examples

My channel is Rustyfishbones

I hope that helps