Reversing strings (nominal attribute values)

tennenrishin

Is there any way to reverse strings (nominal attribute values) in RM?

Background, if interested:

My process generates a bubble chart, with a nominal color axis.
It so happens that alphabetical proximity of these nominal values has a tendency to correlate with spatial proximity in the bubbles' positions.
In other words, if the nominal (color) values are alphabetically ordered, then bubbles of the same color tend to be cluttered together.

Because of my specific application, it would be much better to be able to distinguish the bubbles by color when they are close to each other. So I need to re-order the color axis.

Ideally, I would like to use alphabetically ordered coloring on the reversed strings.

MariusHelf

Hi, there is no way to reverse strings out of the box. But if it is enough to put the last, let's say, 2 characters to the front, you can use the Replace operator with a regular expression like this:

(.*)(.)(.)

and a replacement string like this:

$3$2$1

Best, Marius