Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
Below discussion might helps
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);