Function to Reverse String / text

[Anonymous]

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

[YoussefBelloum]

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;

[Anonymous]

yes!! it works!

thanks a lot!

[Anonymous]

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]

you're welcome.

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

Good luck