Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
how can i manipulate strings on qlikview?
have i make the code in the script field or in the expression field?
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
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
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
Hi
Try with
Textbetween() , subfield(), left(), right(), mid() and so far for get the string as you like from original string
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