concatenat alphanumeric with time

nehapandey · Jun 13, 2007

Hi,

I need to concatenate 2 feilds of the following format;
DAYNAME/A9 AND NEWTIME1/HHI And result should be display as Mon 16:00/Tue 08:00/Mon 09:00 etc.

focwizard · Jun 14, 2007

You can ONLY concatenate ALPHA fields, so you have to first convert the time field (NEWTIME1) to alpha.

This can be done using the subroutine HCNVRT, like this:

Code:

TIMEALPHA/A8 = HCNVRT(NEWTIME1,'(HHI)',8,'A8');

Then, you can concatenate the result like any other alpha field.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

concatenat alphanumeric with time

nehapandey

Programmer

focwizard

Vendor

Similar threads

Part and Inventory Search

Sponsor