| Author |
Message
|
| djosyula |
 Posted: Thu Mar 30, 2017 7:11 am Post subject: Removing unicodes in XML file |
 |
|
Newbie
Joined: 30 Mar 2017
Posts: 9
|
Hi Experts ,
Good evening! I'm facing issue unicodes ,I want to remove unicodes from input XML File, below is my input file
<Task>
<Item>
•Adjusble strap with 22-in. drop
•tone are; self-color stitch
•Coated
•Imported
</Item>
</Task>
note: If I get static unicode I can easily remove by using REPLACE ,but here the problem is we don't know which unicode will receive ,It will differ from one input file to another input file.
please help me out of this ,coz Its like bottleneck of remaining data ..  |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Mar 30, 2017 7:19 am Post subject: Re: Removing unicodes in XML file |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| djosyula wrote: |
| Good evening! I'm facing issue unicodes ,I want to remove unicodes from input XML File, below is my input file |
Why? IIB understands Unicode. Your problem is this:
| djosyula wrote: |
| but here the problem is we don't know which unicode will receive ,It will differ from one input file to another input file. |
Now well behaved XML documents have the coding in the declaration. So use that to tell IIB what to use.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| djosyula |
| Posted: Thu Mar 30, 2017 7:49 am Post subject: |
|
|
Newbie
Joined: 30 Mar 2017
Posts: 9
|
Thanks for quick response , In earlier message My unicodes are not properly pasted here ,I'll give you my input ,please find below
<Task>
<Item>
(&)(#)8226;Adjusble strap with 22-in. drop
(&)(#)8226;tone are; self-color stitch
(&)(#)8226;Coated
(&)(#)8226;Imported
</Item>
</Task>
Note: In aforementioned input file there is no brackets() ,just added for proper pasting purpose |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Mar 30, 2017 9:08 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
I stand by my previous response.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| timber |
| Posted: Thu Mar 30, 2017 9:38 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
I agree with Vitor. Most characters are allowed in an XML document. Why do you need to remove them.
To ask the question a different way: what happens when you do not remove these characters? |
|
| Back to top |
|
|
| adubya |
| Posted: Thu Mar 30, 2017 12:26 pm Post subject: |
|
|
Partisan
Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK
|
What does your XML Declaration look like ? Specifically the encoding attribute.
And what CCSID is associated with the message data you're trying to process ?
Edit: I'm making assumptions. Tell us why you want/need to remove these characters ?
_________________
Independent Middleware Consultant
andy@knownentity.com |
|
| Back to top |
|
|
| djosyula |
| Posted: Fri Mar 31, 2017 1:28 am Post subject: |
|
|
Newbie
Joined: 30 Mar 2017
Posts: 9
|
Hi Team,
Good Morning! I'm receiving above mentioned input from vendor same I'm doing map to output fields ,while I'm debugging I'have't seen those unicodes in IIB but when I'm placing same output into queue there I could see unicodes in that data
Thanks for your wonderful support |
|
| Back to top |
|
|
| timber |
| Posted: Fri Mar 31, 2017 2:01 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
Can I point out 2 things please:
1. We are not your team. If you think we are, you are likely to be disappointed because we are not paid to help you.
2. You have not answered the questions that we asked.
Please read carefully everything that we have asked you, and try to answer the questions. |
|
| Back to top |
|
|
| djosyula |
| Posted: Fri Mar 31, 2017 2:32 am Post subject: |
|
|
Newbie
Joined: 30 Mar 2017
Posts: 9
|
My sincere apologies for that
Actually I didn't mean you are in my team ,I don't know who are in online at that moment so mentioned like that ,it's my bad going forward I'll not repeat this .Thanks for understanding |
|
| Back to top |
|
|
| joebuckeye |
| Posted: Fri Mar 31, 2017 4:35 am Post subject: |
|
|
Partisan
Joined: 24 Aug 2007
Posts: 365
Location: Columbus, OH
|
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Mar 31, 2017 4:36 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| djosyula wrote: |
| I'm receiving above mentioned input from vendor same I'm doing map to output fields ,while I'm debugging I'have't seen those unicodes in IIB but when I'm placing same output into queue there I could see unicodes in that data |
I echo the comments of my worthy associate, especially the part about you not answering the questions you're being asked nor explaining why the advice you've been given doesn't resolve your problem.
Repeatedly explaining your problem will not get anyone anywhere. And you're the one who has to get somewhere. We may not be a team, but we're fine and thanks for asking. Our output looks fine.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
