Replace characters with Ascii numbers in a string

    Hi,

     

    The below code helps in replacing characters with ASCII codes in a string in Load script

     

    For example

     

    ABC is converted to 656667- since ASCII code of A is 65, B is 66 and C is 67.

     

    CharMap:

    Mapping LOAD

    Chr(RecNo() - 1) AS Char,

    RecNo() - 1 AS Asciicode

    AutoGenerate 256;

     

    Data:

    LOAD

    Text,

    MapSubString('CharMap', Text) as formattedText

    FROM DataSource;

     

    Hope this helps.

     

    Regards,

    Jagan.