topic Re: Reverse string in QlikView

Reverse string

Tue, 15 Oct 2013 13:08:44 GMT

Hi,

the strings at my DB are appear reversed (i.e. 'TAC' instead of 'CAT')

does anybody knows if i can reversed the string without using loops at my script.

Thanks.

CELAMBARASAN — Tue, 15 Oct 2013 13:30:57 GMT

Below discussion might helps

Gysbert_Wassenaar — Tue, 15 Oct 2013 18:05:08 GMT

Or something like this:

Reversing:

load MyText, concat(Letter,'',-row) as Reversed Group by MyText;

load MyText, iterno() as row, mid(MyText,IterNo(),1) As Letter

Inline [

MyText

Testmystring

SecondTest

AnotherString

] While IterNo() <= len(MyText);