convert decimal values to a ascii character

[Richard D. Williams]

I don't think xlate can search and replace a hexadecimal value.

I worked it out using a loop over the entire string looking for a 
combination of hex 266, 228, 153/156/157, and
replaced those three characters with the respective ascii value of 
apostrophe or quote.

I was just looking for a more elegant way to perform this task.

Thanks,

Richard


On 9/10/2018 1:55 PM, Bruce Easton via Filepro-list wrote:
> Perhaps a series of xlate commands  - one for each character you need 
> to change.
>
> --Bruce
>
> On 9/10/18 2:27 PM, Richard D. Williams via Filepro-list wrote:
>> I have a situation where users are copying and pasting into a web 
>> page from another application and I am receiving UTF-8 characters 
>> into my filepro field.
>>
>> My research has found these decimal values;
>> 226 128 153 - apostrophe
>> 226 128 156 - open quote
>> 226 128 157 - close quote
>>
>> I can review the text for these decimal codes and replace hem using a 
>> mid command, but I was wondering is there a better way?
>>
>> Any thoughts?
>>
>> Richard D. Williams
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com