Character to Number

[rsunny]

Hi ,

Can any one tell me how to convert Character to Decimal Value . For example if i have A , it should convert to 65 . and if i have Aa it should convert to 6597.

Any help is really appreciated

Thanks in advance

[leomauer]

Use Seq function for each character in string:
Seq(<strig>[1,1]):Seq(<strig>[2,1]):Seq(<strig>[3,1]) and so on.

[rsunny]

Use Seq function for each character in string:
Seq(<strig>[1,1]):Seq(<strig>[2,1]):Seq(<strig>[3,1]) and so on.

Hi ,

Thanks for your quick reply , but the logic above is for each character and i want for multiple characters. I mean , i dont know the input , the input might be abc for 1 row and sdfge for 2nd , so if that is the case how do i consider . So if i consider the above logic that u said ,after all the characters are converted to decimal do i need to trim all zeroes since "" is converted to zero r8?


thanks in advance

[DSguru2B]

Right a small routine to cycle through the string and return the decimal value all concatenated.

[leomauer]

I see you are using DataStage Server edition. Then write BASIC routine looping thriugh the string character by character and concatenating the results until you reach the end of the string.
As for trimming zeroes. in the string absence of character is not converted to anything.

[rsunny]

Hi ,

Thanks all for the reply . As i dont have any experience in writing Routines , Can anyone guide me how to write a routine to solve this issue.

Any help is really appreciated

Thanks in advance

[ray.wurlod]

You've been using DataStage for quite a while now (based on your DSXchange profile) and really should be acquiring these skills.

Code: Select all

FUNCTION RSunny(aTheString)

    vLenString = Len(aTheString)
    Ans = ""

    For vChPos = 1 To vLenString
        Ans := Seq(aTheString[vChPos,1])
    Next vChPos

RETURN(Ans)

If you have Unicode data, then use Uniseq() rather than Seq() function.