topic Re: Reverse string character order in QlikView

Reverse string character order

Mon, 13 Apr 2015 07:49:17 GMT

Hello,

I would like to know if there any direct function that I can use on a text object to reverse the order of the characters of a string.

For example, I have "Hello World" and I would like to have "dlroW olleH".

Any ideas?

Thank you in advance!

Ivo

MK_QSL — Mon, 13 Apr 2015 08:10:55 GMT

Temp:

Load

MyText,

Concat(Letter,'',-row) as Reversed

Group By MyText;

Load

MyText,

IterNo() as row,

Mid(MyText,IterNo(),1) As Letter

Inline

[

MyText

Hello World

This is a Test Document

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

jagan — Mon, 13 Apr 2015 08:19:22 GMT

Hi,

Create a macro code in script and call that macro function in script, refer below links for reference

You can use below macro for string reverse

Data:

LOAD

StrRev(Str1) AS StrRev

INLINE [

Str1, Str2

China, Chinna

abc, abc

];

Macro:

Function StrRev(str)

StrRev = StrReverse(str)

End Function

Regards,

Jagan.