quotation remove from field value?

[Former Member]

hi,

i have one field with value like 'ven"ki'.

I want to remove that quatation from that field value. How to remove it.

please help..

[Former Member]

hi,

i have one field with value like 'ven"ki'.

I want to remove that quatation from that field value. How to remove it.

please help..

[naimesh_patel]

YOu can use the REPLACE.

Like:

DATA: L_VALUE(10)

REPLACE '"' INTO L_VALUE  WITH ' '.

Regards,

Naimesh Patel

[Former Member]

Another way.

TRANSLATE V_STRING using '" '.

Regards,

Ravi Kanth Talagana

[Former Member]

If you don't want spaces:

DATA: f1(10) VALUE 'ven"ki'.
REPLACE ALL OCCURRENCES OF '"' IN f1 WITH ''.

Rob