Is there a way to replace Š with S and š with s in an SQR?
edited Jan 15, 2020 12:00PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered ✓
We have an employee name with š in it and we need to send the name to the mainframe, so I need to replace it with a regular s. For most special characters I can use something like this:
Let $string_in = translate($string_in, CHR(209), 'N') ! Ñ
However, the unicode š and Š are out of range it appears. I have tried SQL in the SQR to get it to work (the native SQL works, running in the SQR it doesn't):
Begin-Select
replace(replace($string_in,'š','s'),'Š','S') &replaceme
FROM DUAL
End-select
Likewise, this doesn't work in the SQR:
0