Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Reverse string

   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.

J

1 Solution

Accepted Solutions

Re: Reverse string

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);


talk is cheap, supply exceeds demand
2 Replies

Re: Reverse string

Below discussion might helps

http://community.qlik.com/message/405714

Re: Reverse string

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);


talk is cheap, supply exceeds demand
Community Browser