ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Removing unicodes in XML file

Post new topic  Reply to topic
 Removing unicodes in XML file « View previous topic :: View next topic » 
Author Message
djosyula
PostPosted: Thu Mar 30, 2017 7:11 am    Post subject: Removing unicodes in XML file Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Thu Mar 30, 2017 7:19 am    Post subject: Re: Removing unicodes in XML file Reply with quote

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
View user's profile Send private message
djosyula
PostPosted: Thu Mar 30, 2017 7:49 am    Post subject: Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Thu Mar 30, 2017 9:08 am    Post subject: Reply with quote

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
View user's profile Send private message
timber
PostPosted: Thu Mar 30, 2017 9:38 am    Post subject: Reply with quote

Grand Master

Joined: 25 Aug 2015
Posts: 1280

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
View user's profile Send private message
adubya
PostPosted: Thu Mar 30, 2017 12:26 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
djosyula
PostPosted: Fri Mar 31, 2017 1:28 am    Post subject: Reply with quote

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
View user's profile Send private message
timber
PostPosted: Fri Mar 31, 2017 2:01 am    Post subject: Reply with quote

Grand Master

Joined: 25 Aug 2015
Posts: 1280

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
View user's profile Send private message
djosyula
PostPosted: Fri Mar 31, 2017 2:32 am    Post subject: Reply with quote

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
View user's profile Send private message
joebuckeye
PostPosted: Fri Mar 31, 2017 4:35 am    Post subject: Reply with quote

Partisan

Joined: 24 Aug 2007
Posts: 364
Location: Columbus, OH

You should probably stop referring to your "problem" characters as unicodes. Unicode is a character set, like ASCII or EBCDIC.

I think Timber has posted this link in the past - https://www.joelonsoftware.com/2003/10/08/the-absolute-minimum-every-software-developer-absolutely-positively-must-know-about-unicode-and-character-sets-no-excuses/

You may also want to look into CCSID values and what your flow should be outputting. Or what the people receiving your output think they should be getting.
Back to top
View user's profile Send private message
Vitor
PostPosted: Fri Mar 31, 2017 4:36 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Removing unicodes in XML file
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.