Moving a character in a string

[Maxence Morlet]

Hi all,

input str12 onetSocCode
"29-1051.00"
"29-1051.00"
"291-051.00"
"291-041.00"
"29-1051.00"

In the data above, I would like to have the "-" always in third position, after the second number, not after the third.

How can I do this in a systematic manner for the whole variable?

Many thanks!

[Nick Cox]

replace onetSocCode = subinstr(onetSocCode, "1-", "-1", 1) if substr(onetSocCode, 3, 2) == "1-"

should work for your data example. Indeed, it's possible that the if qualifier isn't needed.

[Maxence Morlet]

Worked perfectly, thanks!

[Nick Cox]

Please note key edit to #2.