We are to trying to find some solution around parsing the content of a file dynamically.
Here is the scenario,
We have few healthcare members who send data with their own metadata(record delimiter, field delimiter, header lines, field count, end of file). Please see variations below. We want to be able to dynamically parse the message with the member specific rules. Please let me know how we can do this in WTX.
For healthcare member 1:
FieldOrder: MemberName PatientMRN encounterNumber Location Phone
MemberName PatientMRN encounterNumber Location Phone
For healthcare member 2:
FieldOrder: PatientMRN MemberName encounterNumber Phone Location
Date sent at 12-05-2012 13:12:56
Total records 3459
For healthcare member 3:
FieldOrder: PatientMRN EncounterNumber MemberName Location Phone
In WTX, there is an option of using "variable" in each input element and assign to the syntax element which will have all possible values for FieldDelimiter, RecordDelimiter, EnOfFile, HeaderLine but the problem is it is always picking up the value as soon as it finds one of the FieldDemlimiters in the message. But the input field may contain one of the other possible values in the message.
Syntax element has possible values as below for FieldDelimiter -
Data for memeber 2: (rule for FieldDelimiter is |)
St, Joseph hospital|9877787|868822|GA|404-765-4567@Birla member|9877787|868822|GA|404-765-4567@
Here, it finds comma(,) as soon as it reads, it assigns the field delimiter as comma and so not getting the actual one we pass to it.
How do we possibly make it assign the value that we pass to it.?
Pinned topic Parsing messages dynamically in WTX
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-10T15:52:34Z at 2012-12-10T15:52:34Z by SystemAdmin
SystemAdmin 110000D4XK6184 Posts
Re: Parsing messages dynamically in WTX2012-12-10T15:52:34ZThis is the accepted answer. This is the accepted answer.Hi
Whenever you use the syntax variable you have a property Find.
When it is set to default value No - then WTX will behave as you described (as soon as the value is assigned to the variable it will be used).
But when you set the property to Yes - then the value of syntax variable will be determined each time.
This can help you a bit, however when you use the syntax variable this way you must be careful as you can validate the message with three different delimiters.
for example : field1:field2|field3@field4