topic Re: quotation remove from field value? in Application Development and Automation Discussions

quotation remove from field value?

Former Member — Fri, 14 Dec 2007 19:52:45 GMT

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 — Fri, 14 Dec 2007 20:08:21 GMT

YOu can use the REPLACE.

Like:

DATA: L_VALUE(10)

REPLACE '"' INTO L_VALUE  WITH ' '.

Regards,

Naimesh Patel

Former Member — Fri, 14 Dec 2007 20:17:11 GMT

Another way.

TRANSLATE V_STRING using '" '.

Regards,

Ravi Kanth Talagana

Former Member — Fri, 14 Dec 2007 20:23:04 GMT

If you don't want spaces:

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

Rob