XML to XML Using XSLT
I need to transform one xml document into a second xml document. They
both have many nodes so xslt works fine, but there is one node I have
not figure out how to transform.
Here it is:
Node in Input File.
<FullAddress>JOHN SMITH@19495 BISCAYNE
The Result should be:
<Address>19495 BISCAYNE BLVD</Address>
It seems to me I have to "Split" or "Par...Excel to XML #2
'Is there a converter for Microsoft Excel 2000 files that
will save the files as .xml'.
File, Save As
the file extension is still .htm or .html
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"MS" <firstname.lastname@example.org> wrote in message news:email@example.com...
> 'Is there a converter for Microsoft Excel 2000 files that
> will save the files as .xml'.
...Help text for fields...
how can I create a help text for a field in a crmform?
| fieldname1 [Textbox1] description |
| fieldname2 [Textbox2] of the value |
| fieldname3 [Textbox3] in the box |
I need descriptions for each value in a picklist or a textbox.
But how can I create "HTML Text"? Did you know a other way to describe this?
You could use an iframe to show a custom html page and design the custom page
to look like par...Excel 2000 XML
Crazy question: does anyone have any documentation on the XML spreadsheet
schema for Excel 2000? The links to it on the Microsoft support site are
bad, and it changed in version 2002. (Here's a link to the 2002 version:
...Why is message text deleted in some replies?
Since starting using Outlook two days ago, and sending several messages and
receiving replies, two of the replies to messages showed only my original
message without the text of the reply. By phone I got one of the recipients
to re-send several times while I (a) turned off the junk mail filter (b)
turned off the firewall (c) turned off antivirus, all to no avail -- I still
only see my original message and not their reply.
> Since starting using Outlook two days ago, and sending several messages and
> receiving replies, two of the replies to messages ...Compress and secure XML?
This is a situation who can happen often and I would like to know if
I try to create an application who use XML as a native database. The problem
that I don't want that the user can play in the XML. I would like to
compress the file
and encrypt so to block the user. The goal is to have a class that can read
the file (compressed and encrypted) as a normal XML document and can not be
in an editor.
I know that it's possible to do that seperatly but the performance is
Sometime it has company or people who has done it as super performant ...How do you insert a title above 2 columns of text?
I need to center a title above 2 columns of text . It will only center above
the first column. Help.
The quickest and easiest imo is to use a text box. Then you can put the
heading where ever you would like and it won't interfere with the formatting
on the page.
Or you can use the header section of the document.
hope this helps.
> I need to center a title above 2 columns of text . It will only center above
> the first column. Help.
Select the entire paragraph containing the title, go to the Columns dialog,
and choose one column....xml resource cleanup?
I have the following code:
// code start
XmlTextReader xtReader = new XmlTextReader(dataXml, XmlNodeType.Element,
XPathDocument xpDoc = new XPathDocument(xtReader);
XPathNodeIterator iterator = xpDoc.CreateNavigator().Select("//result");
resultValue = iterator.Current.Value;
// code end
Is there something that I can do to help clean up any resources right away
or do I just wait for the GC?
Jiho Han wrote:
> I have the following code:
> // code start
> string resultValue;
I developed an VC++/MFC application that creates
an XML file. It creates the file correctly, but
the file is one long text string (no CR/LF, no indentation,...).
Can anyone recommend some source code (hopefully FREE,
but will pay for the source code) that can take the XML file an
"pretty" format the data?
I might be dense, but why don't you format the XML yourself, when you save
it to file?
Abstrakt Mekanik AB
"Jacques Cooper" <firstname.lastname@example.org> a �crit dans le message de
news:%23FOkiWTwDHA.1908@TK2MSFTNG...Advanced XML Creation using Helper class created by XSD.EXE from a schema
I'm going to paste the section of the helper class below. What I
can't figure out is really what is required or how to set the value
for the item - Identification which is of type PharmacyID. Language
Here's my code attempt and where I'm stuck:
PharmacyIDType ID = new PharmacyIDType();
ItemsChoiceType it = new ItemsChoiceType();
// it. in the editor doesn't give me any options to set a
value - only a name
// ID. offers an ItemsElementName which I will set to "it"
and is of ItemsCho...save as a text file
I've got a weird one here! When attempting to save an email (or
multiple emails) to a text file, 2 computers in my office will save the
to, from and subject lines as well as the email body but 2 others will
only save the to, from and subject lines! I need all computers to save
files with the email body! All computers are using Outlook 2003. I can
not find any reason why these machines will not save the body. Can
someone please help me?!
The ones not working are either at a lower service pack level or are using
an ANSI pst (old format).
Diane Poremsky [MVP - Outlook]
thanks a lot buddy.Bye.
...Should I seriize xml or I should just leave it as text? thanks
Last time, I asked a question about if a XPathDocument could be serialized.
Actually what I really want to know is how should I do in this case:
I have a class that will be serialized. In the class, I need call another
class, which will read setting from database. I want to load the xml once
and use it in the following calls. So it need to be serialized. But
XPathDocument doesn't support it. What should I do here? make the class
serializable? or put the xml in a string and create XPathDocument in every
call, or othe way?
So I should not use the XPathDocument, how should I stor...Importing external data in plain text row format
I have data in the following format:
-------------------Begin Sample Data----------------------
Fernando E. Amuchastegui
Office of the County Attorney
115 S. Andrews Avenue
Fort Lauderdale 33301
Ronald J. Anania
Law Offices of Ronald J. Anania
10910 S W 10th Court
Eric J. Anders
Haley Sinagra Paul & Toland, P.A.
100 SE 3 Avenue
Fort Lauderdale 33394
Hal B. Anderson
Billing Cochran H...floating comments or text boxes
is there a way to keep a comment or a graphic that "floats" above th
spreadsheet, so when you scroll down the box(or image) stays there, an
the sheet scrolls down? (kind of like how the ofice assistant is, onl
i have a company logo that i want visible at all times.
Message posted from http://www.ExcelForum.com
You can put your logo at the top of the sheet, split the window and se
to "freeze" the top rows (and/or columns)
Message posted from http://www.ExcelForum.com
I have some XML doc loaded in a C# Web Service.
XmlDocument doc = new XmlDocument();
Code Missing to manipulate header (I would like to replace or manupulate all
Any idea on how to access and manipulate data within the doc header?
> I have some XML doc loaded in a C# Web Service.
> XmlDocument doc = new XmlDocument();
> Code Missing to manipulate header ...Read XHTML into XML
I need to read/parse XHTML aspx pages and look for certain tokens and
content. How can I use a XmlTextReader for this? If not, any other ideas?
Thanks in advance,
Jose Antonio Reyes wrote:
> I need to read/parse XHTML aspx pages and look for certain tokens and
> content. How can I use a XmlTextReader for this? If not, any other ideas?
If the pages are well-formed XHTML then it is possible to use XmlReader
(in .NET 2.0/3.0) or XmlTextReader (in .NET 1.x) to parse the XHTML
documents. You can also use the other XML APIs .NET provides so using
XPathNavigator and/o...How to invoke the xml editor?
I installed vs2005 on a new xp pro machine, and installed everything
except C++. When I click on a file with a ".xml" extension it is
opened with IE. When I click file/Edit with XML Editor, it opens it
with Notepad. If I click File/Open With and select XML Editor, it
opens it with IE. So, where is the xml editor?
Can it be invoked from withing VS? Where?
* email@example.com wrote in microsoft.public.dotnet.xml:
>I installed vs2005 on a new xp pro machine, and installed everything
>except C++. When I click on a file with a ".xml" extension it is
>opened ...how do i hyphenate text in excel
how do I edit narrative entries in an excel spreadsheet format? I.e. how do
I get words to hyphenate automatically in cells?
XL isn't a word processor - there's no built-in functionality for
automatic hyphenation. XL knows nothing about words, punctuation, etc.
In theory it could be done with event macros, but if you're looking for
hyphenation at syllabic borders, they would have to be rather
In article <259E5311-F66B-4DDD-BAE5-87E40D39A625@microsoft.com>,
cjol in WA <cjol in WA@discussions.microsoft.com> wrote:
> how do I edit narrative ent...show XML schema and values
I have an XML document that looks like the following:
What I'm aiming to do is to show the data in a report as in the following
The "Field1-3"-elements can have any name, so I'm trying to get a table that
has in one result column the element name, and in the second colum...Offline synch using XML web-services
This is a bit long-winded. Can somebody read thru these 2 use cases, and
tell me if it is feasible ? :-
Use Case : Replication before Offline Synch
Scenario 1 : Oracle Server , MSDE client
1. User clicks on 'Go Offline'. System creates a MSDE SQL database in
laptop (client), gets the schemas of the tables in Oracle, creates
corresponding tables in client's MSDE SQL (mapping Oracle datatypes to SQL
2. Offline replication program reads in the tables of the server into a
typed datasets, converts the typed datasets into XML, and stores the XML in
the client. (XML serial...Text formatting ?
this is kind of embarrassing but one of the directors here at the
company, the only person using Outlook 2003 actually, has a problem with
composing text in Outlook. up until recently whenevber he typed :) it would
change into a smiley face but it no longer does this (as of a week ago) so I
chacked the email format and it is HTML... changed it to RTF and Plain text
but still no joy. Can anyone assist me in resolving this problem.
Thanks in advance,
Is he still using Word as his email editor? I think that only works when
you're using Word
"VegaLA"...Text Formula Question
In COL A, I have a list of 2 and 3 digit charactors. I would like to
seperate each string into the three adjacent columns.
KQ K Q
AJs A J s
TT T T
89s 8 9 s
I know that I can use the Left function for the first col, but cant
figure out how to get just the middle or third letters.
Thanks in advance,
Check your last post!
Please keep all correspondence within the NewsGroup, so all may benefit !
------------------------------------------------...How do I set up a formula to insert text in excel?
Hi, I have a questionnaire that is administered on an excel sheet with
respondents typing their answers (i.e 1,2,3) into specific cells. Is there
any way that I can create a formula (or something??) that inserts response
relevant text into another sheet in the workbook, to create a report?
You can use formulas for this type of thing if you want this done only
once. But if this is a repeating task I would suggest an event macro. If
you want to use an event macro you will have to decide when you want this
copying to take place. IOW, what event do you want t...XML Serialization ... how to truncate <?xml...
While xml serializing object how can I truncate <?xml ...?> this line alone?
I need to send the serialized xml data to a web method ... since SOAP
already have <?xml tag there was some confusion
Any help would be greatly appreciated
> While xml serializing object how can I truncate <?xml ...?> this line alone?
Serialize to an XmlWriter created with XmlWriterSettings where you set
OmitXmlDeclaration to true.
Martin Honnen --- MVP XML