Skip to Content
author's profile photo Former Member
Former Member

Special Character

Hi,

Is there any data type which contains all special character like @,#,$,%,^,&,*. I have to remove those records which contains these characters. I can use CA string operator. But is if there any better option then please help me.

Thanks,

Sandeep Garg

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 09:11 AM

    Hi Sandeep,

    There are not special data types to handle these special characters. Its only datatype CHAR that is used.

    Using string operators (CA, CS etc..) is the best option, as you would not miss any of those.

    Best Regards,

    Ram.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 09:15 AM

    Hi,

    There is no datatype which can support the above specified characters.

    If u have to delete those records which contains these characters you can do it as

    if var cs '@,#,$,%,^,&,*'.

    delete it

    end if

    Hope it works out.

    Thanks & Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 09:34 AM

    Function module 'SCP_REPLACE_STRANGE_CHARS' replaces non-standard characters with standard characters.

    INTEXT contains the text to be processed. The parameters passed must be of TYPE C. Blank characters at the end of INTEXT are not processed.

    The result is written in OUTTEXT.

    eg intext can contain special char like 'éñÉÍüúáéíó' then outtext will contain 'enEIuuaeio'.

    if you do not want to replace,try to keep outtext as empty.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 09:41 AM

    Hi,

    I think no other option will serve you better than CA, as all these special characters belong to CHAR data type only.

    By the way are having any problem while using CA??

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.