Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

quotation remove from field value?

Go to solution
Former Member

‎2007 Dec 14 7:52 PM

0 Likes
579

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..

1 ACCEPTED SOLUTION
Read only

Go to solution
naimesh_patel
Active Contributor

‎2007 Dec 14 8:08 PM

0 Likes
545

YOu can use the REPLACE.

Like:

DATA: L_VALUE(10)

REPLACE '"' INTO L_VALUE  WITH ' '.

Regards,

Naimesh Patel

3 REPLIES 3
Read only

Go to solution
naimesh_patel
Active Contributor

‎2007 Dec 14 8:08 PM

0 Likes
546

YOu can use the REPLACE.

Like:

DATA: L_VALUE(10)

REPLACE '"' INTO L_VALUE  WITH ' '.

Regards,

Naimesh Patel

Read only

Go to solution
Former Member

‎2007 Dec 14 8:17 PM

0 Likes
545

Another way.

TRANSLATE V_STRING using '" '.

Regards,

Ravi Kanth Talagana

Read only

Go to solution
Former Member

‎2007 Dec 14 8:23 PM

0 Likes
545

If you don't want spaces:

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

Rob