Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sandrapinto
Contributor III
Contributor III

Function to Reverse String / text

Hi

I am getting revered string from my system. For Example Item ABCD is loaded as DCBA.

Is there a function I can use to reverse the string, in the script itself?

Here is the script:

LIB CONNECT TO 'Sandra-Lavi (lavi_sandra)';

Parts:

LOAD

    Text(PARTNAME) as Parts.PARTNAME ;

SQL SELECT

PARTNAME,

....

FROM lavi.dbo.PART;

Thanks !!

Sandra

13 Replies
YoussefBelloum
Champion
Champion

I modified my script and I removed the last line, it was a mistake, I paste it on the wrong place.

so remove this (last line) and reload:

load Text(PARTNAME), iterno() as row, mid(Text(PARTNAME),IterNo(),1) As Letter;


sandrapinto
Contributor III
Contributor III
Author

yes!! it works!

thanks a lot!

sandrapinto
Contributor III
Contributor III
Author

I agree. I simply would prefer to learn how to do this in qlik.

but you are correct. it is much easier in MS Sql.

thanks!

YoussefBelloum
Champion
Champion

you're welcome.

I've just redirected you to the right link. you should thank gwassenaar

Good luck