Date Format

[Shadakshara Rajagskearapp]

I have used the DATECOPYOPT option to turn of the time value. Could some one please advise the procedure to format the date value: from yyyymmdd in to yyyy-mm-dd or yyyy/mm/dd using the translation.

Thanks

Shad

Topic

[Jim Kosloskey]

I am going to make an assumption you are speaking about HL/7 messages.

You will need to use Tcl to do the formatting.

Jim Kosloskey

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Shadakshara Rajagskearapp]

Jim,

Yes, the messages are in HL7 format.  Could you please provide me the sample script?

Thanks

Shad

[Charlie Bursell]

To convert from YYYYMMDD to yyyy-mm-dd

set newDate [clock format [clock scan $oldDate] -format “%Y-%m-%d”]

To convert from YYYYMMDD to yyyy/mm/dd

set newDate [clock format [clock scan $oldDate] -format  “%Y/%m/%d”]

[David Barr]

This is probably a little more efficient than the “clock scan” option:

Code:

regsub {(….)(..)(..)} $oldDate {1-2-3} newDate

[Shadakshara Rajagskearapp]

Thanks for the all responses. I got it working..

Thanks

Shad

[Lee Wilson]

Please share with the rest of us.

[Author]

Replies