Originally posted by: shelly1

Hello team ,

can any body suggest how to reverse the input without using reverse function

the solution must be generic should be successful for any input  for example 

input "BOOK"

output "KOOB" inverted commas (" ") are part of data .

Thanks in advance

Originally posted by: paul.brett

Here is one such solution.

I have written out my temporary cards, so you can see the different stages.

Input:

"BOOK"

Temp1:

1|"
2|B
3|O
4|O
5|K
6|"

Temp2:

6|"
5|K
4|O
3|O
2|B
1|"

Output:

"KOOB"

There are probably better ways.  See what you can come up with.

Thank-you.

Paul

Follow me on Twitter

Attachment(s)

Reverse.zip   3 KB 1 version

Originally posted by: Ejay

Hello ,

This is the solution i found on my side :

Your text input is "BOOK"

First we need to change the text orientation from left to right .

Then we need to change the visual order to do so i'll use the following functions :

= SETVISUALORDER(SETORIENTATIONRTL(In1 , "TRUE"),"TRUE")

Will have as result : "KOOB" .

Hope This Help

Emmanuel

Originally posted by: Laurent(Satisco)

Hi,

not sure why you don't want the REVERSE function. However, here's another one

Attachment(s)

ReverseString.zip   4 KB 1 version