Get upercase within String Value
I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated within a folder, but sometimes got strange symbols and/or uppercase letters, like this: "Sⁿkwrld.xlsx".
By collecting this value within a string, VBA retrieves: "Snkwrld.xlsx". This results in not being able to find the right file.
Is there a way to fix this problem and let VBA retrieve the correct value with the uppercase "N"?
Thanks in advance!
Best Regards,
Remco Coppens
vba string text symbols uppercase
asked Nov 13 at 7:33
R. Coppens
1
add a comment |
I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated within a folder, but sometimes got strange symbols and/or uppercase letters, like this: "Sⁿkwrld.xlsx".
By collecting this value within a string, VBA retrieves: "Snkwrld.xlsx". This results in not being able to find the right file.
Is there a way to fix this problem and let VBA retrieve the correct value with the uppercase "N"?
Thanks in advance!
Best Regards,
Remco Coppens
vba string text symbols uppercase
asked Nov 13 at 7:33
R. Coppens
1
2
Can be please post snippet of the code , you are using
– Arul Suju
Nov 13 at 7:35
FWIW in what you show thenis not "uppercase". UppercasenisN. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
– Cindy Meister
Nov 13 at 13:25
I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
– R. Coppens
Nov 13 at 14:09
add a comment |
I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated within a folder, but sometimes got strange symbols and/or uppercase letters, like this: "Sⁿkwrld.xlsx".
By collecting this value within a string, VBA retrieves: "Snkwrld.xlsx". This results in not being able to find the right file.
Is there a way to fix this problem and let VBA retrieve the correct value with the uppercase "N"?
Thanks in advance!
Best Regards,
Remco Coppens
vba string text symbols uppercase
asked Nov 13 at 7:33
R. Coppens
1
I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated within a folder, but sometimes got strange symbols and/or uppercase letters, like this: "Sⁿkwrld.xlsx".
By collecting this value within a string, VBA retrieves: "Snkwrld.xlsx". This results in not being able to find the right file.
Is there a way to fix this problem and let VBA retrieve the correct value with the uppercase "N"?
Thanks in advance!
Best Regards,
Remco Coppens
vba string text symbols uppercase
vba string text symbols uppercase
asked Nov 13 at 7:33
R. Coppens
1
asked Nov 13 at 7:33
R. Coppens
1
asked Nov 13 at 7:33
R. Coppens
1
asked Nov 13 at 7:33
R. Coppens
1
asked Nov 13 at 7:33
R. Coppens
1
1
2
Can be please post snippet of the code , you are using
– Arul Suju
Nov 13 at 7:35
FWIW in what you show thenis not "uppercase". UppercasenisN. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
– Cindy Meister
Nov 13 at 13:25
I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
– R. Coppens
Nov 13 at 14:09
add a comment |
2
Can be please post snippet of the code , you are using
– Arul Suju
Nov 13 at 7:35
FWIW in what you show thenis not "uppercase". UppercasenisN. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
– Cindy Meister
Nov 13 at 13:25
I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
– R. Coppens
Nov 13 at 14:09
2
2
Can be please post snippet of the code , you are using
– Arul Suju
Nov 13 at 7:35
Can be please post snippet of the code , you are using
– Arul Suju
Nov 13 at 7:35
FWIW in what you show the
n is not "uppercase". Uppercase n is N. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.– Cindy Meister
Nov 13 at 13:25
FWIW in what you show the
n is not "uppercase". Uppercase n is N. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.– Cindy Meister
Nov 13 at 13:25
I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
– R. Coppens
Nov 13 at 14:09
I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
– R. Coppens
Nov 13 at 14:09
add a comment |
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%2f53275971%2fget-upercase-within-string-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
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%2f53275971%2fget-upercase-within-string-value%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
2
Can be please post snippet of the code , you are using
– Arul Suju
Nov 13 at 7:35
FWIW in what you show the
nis not "uppercase". UppercasenisN. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.– Cindy Meister
Nov 13 at 13:25
I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
– R. Coppens
Nov 13 at 14:09