Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Below discussion might helps

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

Gysbert_Wassenaar

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