Replace Function

maretix

Member
Hi to all.
I have some problems to replace a character in a field of a table.
I use Progress v.10.2.b
In that field there is a \ character at the end of the field (CHR(134))
I need to replace \ character with a blank character.
I was able to do that only quoting the string , but this is not real scenario.

My test code:

DEF VAR w-despromo as char init ' "pipa\" '.
ASSIGN w-despromo = REPLACE(TRIM(w-despromo)," 'CHR(134)' ", ' '). /* character / is CHR(134) */
DISP w-despromo.

Result is "pipa" so REPLACE Function replaced \ successfully but i do not have this real scenario ....
In my Progress Table i have a field that contains only ... pipa\ ... that is NOT QUOTED ...

How can i do ???

I tried in several modes but i receive always syntax errors
I think \ character is a special character ????

Thanks in advance.

Ha ve a good day.
 
Top