AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
#Power
 View Only
Back to discussions
Expand all | Collapse all

how to delete special character in ESQL

  • 1.  how to delete special character in ESQL

    Posted Fri January 19, 2007 03:08 AM

    Originally posted by: SystemAdmin


    Dear all,

    Now I occurrd a new problem.
    In ESQL, a Character variable contain some "carriage return characters" like "\k", and I want to delete or replace it.Could you tell me how to do it?

    sample:
    TEMP:variable contains "carriage return characters"

    Way1. Replay(failed)
    SET TEMP=REPLACE(TEMP, '\n', '');

    Way2. LENTH
    CECLARE TEMP INT;
    SET TEMP=LENGTH(TEMP);
    from above, I know "carriage return characters" is 1 char length.

    Please help me to work it out, and thank you very much.
    #AIX-Forum


Related Content