Hello Sean.

Always yes. I would create files for the data medium exchange procedure dtaus-files (bank transactions) and only some characters are allowed. All possible chars are saved in my table with translation upper and so on. Now I would like to check each character. At the time I have create a stored prozedure with input my string and output the changed one.

for int i =1 to char length
substring ...
select from table
set to new string - add
i++

is it the best way?

Thanks



"Leyne, Sean" <Sean@...> schrieb:

>Olaf,
>
>> Is there an simpler way than this?
>>
>> While count < strlength
>>
>> Character = substring(input from count for 1)
>>
>> Select exchangecharakter from table where inputcharacter = character
>into
>> :newcharacter
>>
>> Newstring = newstring || newcharacter;
>
>Is the character mapping "user definable" (does the mapping need to be
>stored in a table)?
>
>Is the mapping of the characters consistent for all uses?
>
>Do all characters always get mapped for all uses?
>
>
>Sean

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.