regarding removing special characters

[rakesh_mandal]

can anyone tell me the code to remove special characters but not spaces from fields in a report program

[Former Member]

Hi Rakesh,

Data : lv_field type string value 'ABC123a$'.

Replace REGEX '[A-Za-z0-9]'  in lv_field with ''.

lv_field contains $'.

The above statement replaces letters A,B...Z or a,b,..z or numbers 0,1,..9 with Space.

To remove speacial characters include backslash character before special character, like to remove / symbol precede it with \/.

Regards,

Ravikiran.K

[rakesh_mandal]

Hi ravi,

thanks for ur reply.but my question is like a field value is-Ravi@48,7Kiran.i want to remove special characters so the desire output should be-Ravi 48 7Kiran.

[Former Member]

Hi Rakesh,

Data : lv_field type string value 'Ravi@48,7Kiran'.

OVERLAY lv_field WITH 'Ravi 48 7kiran' ONLY '@,'.

WRITE lv_field.

Regards,

Ravikiran.K

[rakesh_mandal]

Hi Ravi,

thanks ravi for the reply.but here you are working on a single value.i am working on 100 diff values so its not possible to use overlay here.

Regards,

Rakesh

[Former Member]

Hi Rakesh,

I didnt undestand what is single value, 100 ?

[rakesh_mandal]

Hi ravi,

one more question suppose the value is Ravi#@* Kiran.

the output should be Ravi Kiran.means i dont want to replace special characters with spaces.

Regards,

Rakesh

[Former Member]

HI.

Data : lv_field type string value ' Ravi#@* Kiran'.

REPLACE REGEX '[#]' IN lv_field WITH ''.

REPLACE REGEX '[@]' IN lv_field WITH ''.

REPLACE REGEX '[*]' IN lv_field WITH ''.

WRITE lv_field.

[rakesh_mandal]

Hi Ravi,

the above code is helpful but this will replace the special characters with space.the space present in the field should be there but  special characters should not be replaced with spaces.

Regards,

rakesh

[Former Member]

Hi Rakesh,

Please be specific what exactly you want..

Above post is according to your desired output.

[rakesh_mandal]

Hi Ravi,

actually m new in sap-abap.so its difficult to understand a few things.eg Ravi@#$  kiran.

output-Ravi  Kiran.here @#$ should not be replaced by space.but there are two spaces, those two spaces should be kept as it is.

Regards,

Rakesh

[Former Member]

Hi Rakesh,

In your output  what happened to @#$. where did they go?

[rakesh_mandal]

Hi Ravi,

those are replaced with spaces.

[Former Member]

regarding removing special characters

rakesh mandal Feb 3, 2014 7:42 AM (in response to Ravi Kiran K)

Hi Ravi,

actually m new in sap-abap.so its difficult to understand a few things.eg Ravi@#$  kiran.

output-Ravi  Kiran.here @#$ should not be replaced by space.but there are two spaces, those two spaces should be kept as it is.

Regards,

Rakesh

you say should not replaced by space.Again you say replaced by space. please dont waste time.

[rakesh_mandal]

Hi Ravi,

sorry ravi,actually here these fields are getting replaced by space in the code u mentioned but i dont want that to happen.

[rakesh_mandal]

Hi ravi,

Thanks.the code is working fine.and sorry

Regards,

Rakesh

[Former Member]

Hi Rakesh,

Mark the answers as correct and helpful, so that it will be helpful for others who look into the post.

Regards,

Ravikiran.K

[Former Member]

Hi Rakesh,

Please mark answer as Helpful or correct .

Regards,

Ravikiran.K

[Former Member]

Ravi, this is a discussion 'Correct Answer' option can't be there..

[Former Member]

Hi Chandra,

Asking for marking Helpful answer. Some times you will have correct answer.

Regards,

Ravikiran.K

[Former Member]

If the Question is 'Marked as a Question' then only correct answer option will come otherwise no. And this question is not marked as 'Question'. 

[Former Member]

ok got it chandra..