| edupugantis@hotmail.com 2005-04-22, 5:58 pm |
| Hello,
I am using Hipaa Accelerator 3.0 for BiztalkServer2004.
Having source schema as 837professional_v3_wpc_multiple.xsd.
Inbound X12 file, Service date in 2400 Loop may come in any one of the
format,
DTP*472*D8*200040607~
DTP*472*RD8*20040607-20040608~
In my destination schema I am having two fields as
SERVICE_FROM_DATE
and SERVICE_TO_DATE
To Map Source schema to destination schema I have written script
functiod,
For this script functiod we give two inputs, one as qualifier (D8 or
RD8) other as date (strDate)
I have written a script functiod vb.net and calling from external
assembly in script functiod in MAP,
If (strQualifer = "D8") Then
SERVICE_FROM_DATE = strDate
SERVICE_TO_DATE = strDate
ElseIf (strQualifer = "RD8") Then
Dim nexda As Integer
Dim intPor As Integer
intPor = strDate.IndexOf("-")
nexda = strDate.Length - 1
nexda = nexda - intPor
SERVICE_FROM_DATE = strDate.Substring(0, intPor)
SERVICE_TO_DATE = strDate.Substring(intPor + 1, nexda)
End If
The output from the script functiod of this is having two
parameter's, which parameter to map to the fields in the destination
schema.
(As script functiod will give one output at a time.)
I will appreciate if the solution is posted as early as possible.
Pl suggest if there is any other new approach to send Service date to
two destination fields based on the qualifiers.
Thanks
Sridhar.E
|