Do you mean something like this:
SUBR("-FIELDS", Mv_Dict, " ", 2);
SUBR("-FIELDS", @1, "*", 1);
SUBR("-FIELDS", @1, "*", 2);
SUBR("-FIELDS", @, ".", 1);
OCONVS(@2, "D2/");
OCONVS(@4, "MTH");
SPLICE(@5, " ", @6)
Thanks,
David A. Green
DAG Consulting
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, August 29, 2006 6:53 AM
To: [EMAIL PROTECTED]
Subject: [U2] Convert to date and Time
I need to convert a Multivalue field to Date and Time format in MS Excel.
The Mutivalue filed has the following description and the value next to
that.
Date_Time_Qty: 14121*31190.858
Any suggestion is appreciated.
Thanks.
Krish
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
