Function HHMMSS(A8)

[rummage]

Hi,

I have this question:

I am trying to create a unique ID for the session. For that I am concatenating UserID + Date + Time.
For time, I use HHMMSS(A8).

My code is like the following:

-SET &AJB = GETUSER(A8) || &YMD || HHMMSS(A8);

The problem is that HHMMSS results in a value that contains the character '.'

I would like to remove the '.' from the value. How can I do that. Can I use any string manipulation function for this?

Thanks
Thambaiya

 

[FrankExp]

Use this:

-SET &AJB = GETUSER('A8') || 
            &YMD          || 
            EDIT(HHMMSS('A8'),'99$99$99');

Frank van de Kant

http://www.explicit.nl

 

[rummage]

Thanks Frank van de Kant. I have done the code using the EDIT. It works.

Thambaiya