How to update a string with values from other fields?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
0
I have a table containing a column with a string value, and 3 other columns with data. How do I replace parts of the string, with the value of the other 3 columns? I need to be able to iterate this over various entries as well.
Data sample:
DocNum | DMS | DMSDatabase | DocumentID
---------------------------------------------------------------------------------------------------
38213097 | DMS-OLD | DB2 | !nrtdms:0:!session:DMS-OLD:!database:DB1:!document:373108696,1:
What I need the DocumentID column to be replaced with:
!nrtdms:0:!session:DMS-NEW:!database:DB2:!document:38213097,1:
sql mssql
asked Mar 27 at 20:55
WR7500WR7500
414
add a comment |
0
I have a table containing a column with a string value, and 3 other columns with data. How do I replace parts of the string, with the value of the other 3 columns? I need to be able to iterate this over various entries as well.
Data sample:
DocNum | DMS | DMSDatabase | DocumentID
---------------------------------------------------------------------------------------------------
38213097 | DMS-OLD | DB2 | !nrtdms:0:!session:DMS-OLD:!database:DB1:!document:373108696,1:
What I need the DocumentID column to be replaced with:
!nrtdms:0:!session:DMS-NEW:!database:DB2:!document:38213097,1:
sql mssql
asked Mar 27 at 20:55
WR7500WR7500
414
Do your fields really have all that whitespace padding, or is that just visual formatting?
– steeldriver
Mar 27 at 21:11
@steeldriver visual formatting
– WR7500
Mar 28 at 1:55
Please edit the question to show the actual format of the data. Also where doesDMS-NEWcome from? is that just a fixed string?
– steeldriver
Mar 28 at 2:06
add a comment |
0
0
0
I have a table containing a column with a string value, and 3 other columns with data. How do I replace parts of the string, with the value of the other 3 columns? I need to be able to iterate this over various entries as well.
Data sample:
DocNum | DMS | DMSDatabase | DocumentID
---------------------------------------------------------------------------------------------------
38213097 | DMS-OLD | DB2 | !nrtdms:0:!session:DMS-OLD:!database:DB1:!document:373108696,1:
What I need the DocumentID column to be replaced with:
!nrtdms:0:!session:DMS-NEW:!database:DB2:!document:38213097,1:
sql mssql
asked Mar 27 at 20:55
WR7500WR7500
414
I have a table containing a column with a string value, and 3 other columns with data. How do I replace parts of the string, with the value of the other 3 columns? I need to be able to iterate this over various entries as well.
Data sample:
DocNum | DMS | DMSDatabase | DocumentID
---------------------------------------------------------------------------------------------------
38213097 | DMS-OLD | DB2 | !nrtdms:0:!session:DMS-OLD:!database:DB1:!document:373108696,1:
What I need the DocumentID column to be replaced with:
!nrtdms:0:!session:DMS-NEW:!database:DB2:!document:38213097,1:
sql mssql
sql mssql
asked Mar 27 at 20:55
WR7500WR7500
414
asked Mar 27 at 20:55
WR7500WR7500
414
asked Mar 27 at 20:55
WR7500WR7500
414
asked Mar 27 at 20:55
WR7500WR7500
414
asked Mar 27 at 20:55
WR7500WR7500
414
414
Do your fields really have all that whitespace padding, or is that just visual formatting?
– steeldriver
Mar 27 at 21:11
@steeldriver visual formatting
– WR7500
Mar 28 at 1:55
Please edit the question to show the actual format of the data. Also where doesDMS-NEWcome from? is that just a fixed string?
– steeldriver
Mar 28 at 2:06
add a comment |
Do your fields really have all that whitespace padding, or is that just visual formatting?
– steeldriver
Mar 27 at 21:11
@steeldriver visual formatting
– WR7500
Mar 28 at 1:55
Please edit the question to show the actual format of the data. Also where doesDMS-NEWcome from? is that just a fixed string?
– steeldriver
Mar 28 at 2:06
Do your fields really have all that whitespace padding, or is that just visual formatting?
– steeldriver
Mar 27 at 21:11
Do your fields really have all that whitespace padding, or is that just visual formatting?
– steeldriver
Mar 27 at 21:11
@steeldriver visual formatting
– WR7500
Mar 28 at 1:55
@steeldriver visual formatting
– WR7500
Mar 28 at 1:55
Please edit the question to show the actual format of the data. Also where does
DMS-NEW come from? is that just a fixed string?– steeldriver
Mar 28 at 2:06
Please edit the question to show the actual format of the data. Also where does
DMS-NEW come from? is that just a fixed string?– steeldriver
Mar 28 at 2:06
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
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
});
}
});
draft saved
draft discarded
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%2faskubuntu.com%2fquestions%2f1129244%2fhow-to-update-a-string-with-values-from-other-fields%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
draft saved
draft discarded
Thanks for contributing an answer to Ask Ubuntu!
- 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.
draft saved
draft discarded
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%2faskubuntu.com%2fquestions%2f1129244%2fhow-to-update-a-string-with-values-from-other-fields%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
Do your fields really have all that whitespace padding, or is that just visual formatting?
– steeldriver
Mar 27 at 21:11
@steeldriver visual formatting
– WR7500
Mar 28 at 1:55
Please edit the question to show the actual format of the data. Also where does
DMS-NEWcome from? is that just a fixed string?– steeldriver
Mar 28 at 2:06