Replace all occurences of '

[Former Member]

Hi gurus,

I need to process the format of a number, eliminating the notation for thousands. The notation for thousand for one country is like that 6'120 , I need to convert this number to 6120.

Until now the elimination of the thousand notation was done with the replace function, like:

REPLACE ALL OCCURRENCES OF '.' IN strtemp WITH ''.

now i can't use this sentence, an error is displayed with this kind of sentence:

REPLACE ALL OCCURRENCES OF ''' IN strtemp WITH ''.

I highly appreciate some idea to solve this issue.

Thanks in advance.

[Former Member]

Hi gurus,

I need to process the format of a number, eliminating the notation for thousands. The notation for thousand for one country is like that 6'120 , I need to convert this number to 6120.

Until now the elimination of the thousand notation was done with the replace function, like:

REPLACE ALL OCCURRENCES OF '.' IN strtemp WITH ''.

now i can't use this sentence, an error is displayed with this kind of sentence:

REPLACE ALL OCCURRENCES OF ''' IN strtemp WITH ''.

I highly appreciate some idea to solve this issue.

Thanks in advance.

[Former Member]

Use double single quotes ('') to escape.

REPLACE ALL OCCURRENCES OF '''' IN strtemp WITH ''.

[Former Member]

write this ... '''' <-- should be 4 ' s

REPLACE ALL OCCURRENCES OF '''' IN strtemp WITH ''.

[Former Member]

do this way,

data : v_number(10).

v_number = '6''1''20'.
translate v_number using ''' '.
condense v_number no-gaps.

write : v_number. 

[Former Member]

Hi,

You can do as below:

REPLACE ALL OCCURRENCES OF '''' IN strtemp WITH ''.

Thanks,

Sriram Ponna.