| Author |
Message
|
| run |
 Posted: Wed Jul 11, 2012 6:40 am Post subject: very urgent!! |
 |
|
Apprentice
Joined: 14 May 2007
Posts: 45
Location: Newyork, USA
|
Below is the xml message I need to work on. I need to delete the repeating data in the <Field name="DuplicateEDRIID> and out data as xml message. for example, XpuhOTOtvDrVQj7 is repeating twice. Could anyone please help me with this.
<ResultBlock iterationNo="1" status="1">
<AdditionalFields>
<Field name="PatientAddressLine1">35 e 72 st V 67</Field>
<Field name="PatientAddressLine2" />
<Field name="PatientCity">ISELIN</Field>
<Field name="PatientState">NJ</Field>
<Field name="PatientZipcode">68869</Field>
<Field name="PatientCounty">89</Field>
<Field name="SNOMEDCode">20047837</Field>
<Field name="ProviderFirstName">mamatha</Field>
<Field name="ProviderLastName">shiva</Field>
<Field name="DuplicateEDRIID">XpuhOTOtvDrVQj7,4yb1Tzp0avOxb9w,XpuhOTOtvDrVQj7,XpuhOTOtvDrVQj6,4yb1Tzp0avOxb9w,4yb1Tzp0avOxb0t</Field>
</AdditionalFields>
</ResultBlock> |
|
| Back to top |
|
 |
| kimbert |
| Posted: Wed Jul 11, 2012 6:44 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| It depends which language you are using. Both ESQL and Java have a wide range of string manipulation functions. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jul 11, 2012 6:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
There's no "simple" trick for this.
You need to develop code that understands the data, understands what pieces are separate from each other, understands when one piece is the same as another, and then produce a set of unique pieces. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 11, 2012 7:10 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Since it seems you are unaware how to do this, and this task is marked "very urgent", you probably should hire a WMB developer to do this for you.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| run |
| Posted: Wed Jul 11, 2012 7:43 am Post subject: |
|
|
Apprentice
Joined: 14 May 2007
Posts: 45
Location: Newyork, USA
|
| Never mind guys. This is what happens when you share your user name/pass with a new bee.. not that I wasn't there once but everybody had to cross the bridge one day..thank for your time in checking out this post.. |
|
| Back to top |
|
|
| inMo |
| Posted: Wed Jul 11, 2012 10:08 am Post subject: |
|
|
Master
Joined: 27 Jun 2009
Posts: 216
Location: NY
|
|
| Back to top |
|
|
|
|
