Best way to remove special characters xslt 1.0
We received xml files from England but now also from France. In those France files there are a lot of special characters in different nodes. Special the ' gives problems when we in the end of the process the data want to upload with an insert query in a database.
It is possible to replace the nodes with translate function, but there are a lot of nodes.
I understand it should also possible to do this with the (apply)template function, but I don’t know how.
We need to replace for example the ' with &rsquo. Can someone give an example?
templates xslt-1.0
asked Nov 21 '18 at 18:46
MarkMark
33
add a comment |
We received xml files from England but now also from France. In those France files there are a lot of special characters in different nodes. Special the ' gives problems when we in the end of the process the data want to upload with an insert query in a database.
It is possible to replace the nodes with translate function, but there are a lot of nodes.
I understand it should also possible to do this with the (apply)template function, but I don’t know how.
We need to replace for example the ' with &rsquo. Can someone give an example?
templates xslt-1.0
asked Nov 21 '18 at 18:46
MarkMark
33
Iftranslate()works for you, why don't you apply it to all nodes? It shouldn't matter how many nodes there are, the stylesheet can process them all recursively. Note thattranslate()works on individual characters only, not on codes like’.
– michael.hor257k
Nov 21 '18 at 18:54
We have this issue on multiple places in multiple processes. It will be a lot of work and also the readability will not be better.
– Mark
Nov 21 '18 at 19:04
I am not sure what you describe - you show us no code. In general, you only need one template matchingtext()to process all text nodes in the entire document.
– michael.hor257k
Nov 21 '18 at 19:08
Sorry I write down the name of an other example I found (&rsquo). An example what I receive: <name>O'Brien<name> I need this to replace, including the nodes, with <name>O’Brien<name>. This other quote is not an issue in SQL.
– Mark
Nov 21 '18 at 20:11
add a comment |
We received xml files from England but now also from France. In those France files there are a lot of special characters in different nodes. Special the ' gives problems when we in the end of the process the data want to upload with an insert query in a database.
It is possible to replace the nodes with translate function, but there are a lot of nodes.
I understand it should also possible to do this with the (apply)template function, but I don’t know how.
We need to replace for example the ' with &rsquo. Can someone give an example?
templates xslt-1.0
asked Nov 21 '18 at 18:46
MarkMark
33
We received xml files from England but now also from France. In those France files there are a lot of special characters in different nodes. Special the ' gives problems when we in the end of the process the data want to upload with an insert query in a database.
It is possible to replace the nodes with translate function, but there are a lot of nodes.
I understand it should also possible to do this with the (apply)template function, but I don’t know how.
We need to replace for example the ' with &rsquo. Can someone give an example?
templates xslt-1.0
templates xslt-1.0
asked Nov 21 '18 at 18:46
MarkMark
33
asked Nov 21 '18 at 18:46
MarkMark
33
asked Nov 21 '18 at 18:46
MarkMark
33
asked Nov 21 '18 at 18:46
MarkMark
33
asked Nov 21 '18 at 18:46
MarkMark
33
33
Iftranslate()works for you, why don't you apply it to all nodes? It shouldn't matter how many nodes there are, the stylesheet can process them all recursively. Note thattranslate()works on individual characters only, not on codes like’.
– michael.hor257k
Nov 21 '18 at 18:54
We have this issue on multiple places in multiple processes. It will be a lot of work and also the readability will not be better.
– Mark
Nov 21 '18 at 19:04
I am not sure what you describe - you show us no code. In general, you only need one template matchingtext()to process all text nodes in the entire document.
– michael.hor257k
Nov 21 '18 at 19:08
Sorry I write down the name of an other example I found (&rsquo). An example what I receive: <name>O'Brien<name> I need this to replace, including the nodes, with <name>O’Brien<name>. This other quote is not an issue in SQL.
– Mark
Nov 21 '18 at 20:11
add a comment |
Iftranslate()works for you, why don't you apply it to all nodes? It shouldn't matter how many nodes there are, the stylesheet can process them all recursively. Note thattranslate()works on individual characters only, not on codes like’.
– michael.hor257k
Nov 21 '18 at 18:54
We have this issue on multiple places in multiple processes. It will be a lot of work and also the readability will not be better.
– Mark
Nov 21 '18 at 19:04
I am not sure what you describe - you show us no code. In general, you only need one template matchingtext()to process all text nodes in the entire document.
– michael.hor257k
Nov 21 '18 at 19:08
Sorry I write down the name of an other example I found (&rsquo). An example what I receive: <name>O'Brien<name> I need this to replace, including the nodes, with <name>O’Brien<name>. This other quote is not an issue in SQL.
– Mark
Nov 21 '18 at 20:11
If
translate() works for you, why don't you apply it to all nodes? It shouldn't matter how many nodes there are, the stylesheet can process them all recursively. Note that translate() works on individual characters only, not on codes like ’.– michael.hor257k
Nov 21 '18 at 18:54
If
translate() works for you, why don't you apply it to all nodes? It shouldn't matter how many nodes there are, the stylesheet can process them all recursively. Note that translate() works on individual characters only, not on codes like ’.– michael.hor257k
Nov 21 '18 at 18:54
We have this issue on multiple places in multiple processes. It will be a lot of work and also the readability will not be better.
– Mark
Nov 21 '18 at 19:04
We have this issue on multiple places in multiple processes. It will be a lot of work and also the readability will not be better.
– Mark
Nov 21 '18 at 19:04
I am not sure what you describe - you show us no code. In general, you only need one template matching
text() to process all text nodes in the entire document.– michael.hor257k
Nov 21 '18 at 19:08
I am not sure what you describe - you show us no code. In general, you only need one template matching
text() to process all text nodes in the entire document.– michael.hor257k
Nov 21 '18 at 19:08
Sorry I write down the name of an other example I found (&rsquo). An example what I receive: <name>O'Brien<name> I need this to replace, including the nodes, with <name>O’Brien<name>. This other quote is not an issue in SQL.
– Mark
Nov 21 '18 at 20:11
Sorry I write down the name of an other example I found (&rsquo). An example what I receive: <name>O'Brien<name> I need this to replace, including the nodes, with <name>O’Brien<name>. This other quote is not an issue in SQL.
– Mark
Nov 21 '18 at 20:11
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53418701%2fbest-way-to-remove-special-characters-xslt-1-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53418701%2fbest-way-to-remove-special-characters-xslt-1-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If
translate()works for you, why don't you apply it to all nodes? It shouldn't matter how many nodes there are, the stylesheet can process them all recursively. Note thattranslate()works on individual characters only, not on codes like’.– michael.hor257k
Nov 21 '18 at 18:54
We have this issue on multiple places in multiple processes. It will be a lot of work and also the readability will not be better.
– Mark
Nov 21 '18 at 19:04
I am not sure what you describe - you show us no code. In general, you only need one template matching
text()to process all text nodes in the entire document.– michael.hor257k
Nov 21 '18 at 19:08
Sorry I write down the name of an other example I found (&rsquo). An example what I receive: <name>O'Brien<name> I need this to replace, including the nodes, with <name>O’Brien<name>. This other quote is not an issue in SQL.
– Mark
Nov 21 '18 at 20:11