Mixing
Need Format or Input mask
I asked this question before but did get a favorable response so am asking again just to see if i get help.
I have an oracle form with a field (:p4_filenumber) and i am trying to either get a input or format mask which changes the numbers in the filed to the format x/xx/xxx.
The input mask will of course allow the numbers to be entered in with the above format before process but if i cant get that then i could use the format mask to change it after process.
oracle11g oracle-apex oracle-apex-5.1
asked Jan 2 at 13:33
rawlerawle
465
add a comment |
I asked this question before but did get a favorable response so am asking again just to see if i get help.
I have an oracle form with a field (:p4_filenumber) and i am trying to either get a input or format mask which changes the numbers in the filed to the format x/xx/xxx.
The input mask will of course allow the numbers to be entered in with the above format before process but if i cant get that then i could use the format mask to change it after process.
oracle11g oracle-apex oracle-apex-5.1
asked Jan 2 at 13:33
rawlerawle
465
Hello! If your previous question was as terse and vague as this one, the reason why you don't get an answer is that you didn't provide enough information for people to help you. idownvotedbecau.se/itsnotworking. If you have not done that yet, remember that we have a site containing tips on how to ask a good question
– akraf
Jan 2 at 14:14
1
i have edited the question
– rawle
Jan 2 at 14:29
1
Possible duplicate: stackoverflow.com/questions/1041415/… . As you have not provided any hints on what you have tried or what similar tips you have found, I don't know if you have found this and it didn't work for whatever reason.
– akraf
Jan 2 at 14:39
Possible duplicate of Applying a phone number format mask in oracle apex
– Jeffrey Kemp
Jan 21 at 2:38
add a comment |
I asked this question before but did get a favorable response so am asking again just to see if i get help.
I have an oracle form with a field (:p4_filenumber) and i am trying to either get a input or format mask which changes the numbers in the filed to the format x/xx/xxx.
The input mask will of course allow the numbers to be entered in with the above format before process but if i cant get that then i could use the format mask to change it after process.
oracle11g oracle-apex oracle-apex-5.1
asked Jan 2 at 13:33
rawlerawle
465
I asked this question before but did get a favorable response so am asking again just to see if i get help.
I have an oracle form with a field (:p4_filenumber) and i am trying to either get a input or format mask which changes the numbers in the filed to the format x/xx/xxx.
The input mask will of course allow the numbers to be entered in with the above format before process but if i cant get that then i could use the format mask to change it after process.
oracle11g oracle-apex oracle-apex-5.1
oracle11g oracle-apex oracle-apex-5.1
asked Jan 2 at 13:33
rawlerawle
465
asked Jan 2 at 13:33
rawlerawle
465
edited Jan 2 at 14:28
rawle
asked Jan 2 at 13:33
rawlerawle
465
asked Jan 2 at 13:33
rawlerawle
465
asked Jan 2 at 13:33
rawlerawle
465
465
Hello! If your previous question was as terse and vague as this one, the reason why you don't get an answer is that you didn't provide enough information for people to help you. idownvotedbecau.se/itsnotworking. If you have not done that yet, remember that we have a site containing tips on how to ask a good question
– akraf
Jan 2 at 14:14
1
i have edited the question
– rawle
Jan 2 at 14:29
1
Possible duplicate: stackoverflow.com/questions/1041415/… . As you have not provided any hints on what you have tried or what similar tips you have found, I don't know if you have found this and it didn't work for whatever reason.
– akraf
Jan 2 at 14:39
Possible duplicate of Applying a phone number format mask in oracle apex
– Jeffrey Kemp
Jan 21 at 2:38
add a comment |
Hello! If your previous question was as terse and vague as this one, the reason why you don't get an answer is that you didn't provide enough information for people to help you. idownvotedbecau.se/itsnotworking. If you have not done that yet, remember that we have a site containing tips on how to ask a good question
– akraf
Jan 2 at 14:14
1
i have edited the question
– rawle
Jan 2 at 14:29
1
Possible duplicate: stackoverflow.com/questions/1041415/… . As you have not provided any hints on what you have tried or what similar tips you have found, I don't know if you have found this and it didn't work for whatever reason.
– akraf
Jan 2 at 14:39
Possible duplicate of Applying a phone number format mask in oracle apex
– Jeffrey Kemp
Jan 21 at 2:38
Hello! If your previous question was as terse and vague as this one, the reason why you don't get an answer is that you didn't provide enough information for people to help you. idownvotedbecau.se/itsnotworking. If you have not done that yet, remember that we have a site containing tips on how to ask a good question
– akraf
Jan 2 at 14:14
Hello! If your previous question was as terse and vague as this one, the reason why you don't get an answer is that you didn't provide enough information for people to help you. idownvotedbecau.se/itsnotworking. If you have not done that yet, remember that we have a site containing tips on how to ask a good question
– akraf
Jan 2 at 14:14
1
1
i have edited the question
– rawle
Jan 2 at 14:29
i have edited the question
– rawle
Jan 2 at 14:29
1
1
Possible duplicate: stackoverflow.com/questions/1041415/… . As you have not provided any hints on what you have tried or what similar tips you have found, I don't know if you have found this and it didn't work for whatever reason.
– akraf
Jan 2 at 14:39
Possible duplicate: stackoverflow.com/questions/1041415/… . As you have not provided any hints on what you have tried or what similar tips you have found, I don't know if you have found this and it didn't work for whatever reason.
– akraf
Jan 2 at 14:39
Possible duplicate of Applying a phone number format mask in oracle apex
– Jeffrey Kemp
Jan 21 at 2:38
Possible duplicate of Applying a phone number format mask in oracle apex
– Jeffrey Kemp
Jan 21 at 2:38
add a comment |
1 Answer
1
active
oldest
votes
You can't do this with a format mask because x/xx/xxx is not a representation for a number. It's sort of a date, but not quite. You don't say how this field will be stored in the database, but I'm guessing it will be a VARCHAR2. If you're just trying to reformat, say, user input of xxxxxx into x/xx/xxx, then you need a Dynamic Action for that, probably on the change of the field. That would run a piece of Javascript to reformat the input.
But there's a lot there to unpack. What if the user enters only 4 numbers? What if they enter letters?
answered Jan 6 at 20:10
eaolsoneaolson
8,70163147
thanks for your input. am pretty sure the user will not enter letters
– rawle
Jan 7 at 13:23
add a comment |
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%2f54007319%2fneed-format-or-input-mask%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can't do this with a format mask because x/xx/xxx is not a representation for a number. It's sort of a date, but not quite. You don't say how this field will be stored in the database, but I'm guessing it will be a VARCHAR2. If you're just trying to reformat, say, user input of xxxxxx into x/xx/xxx, then you need a Dynamic Action for that, probably on the change of the field. That would run a piece of Javascript to reformat the input.
But there's a lot there to unpack. What if the user enters only 4 numbers? What if they enter letters?
answered Jan 6 at 20:10
eaolsoneaolson
8,70163147
thanks for your input. am pretty sure the user will not enter letters
– rawle
Jan 7 at 13:23
add a comment |
You can't do this with a format mask because x/xx/xxx is not a representation for a number. It's sort of a date, but not quite. You don't say how this field will be stored in the database, but I'm guessing it will be a VARCHAR2. If you're just trying to reformat, say, user input of xxxxxx into x/xx/xxx, then you need a Dynamic Action for that, probably on the change of the field. That would run a piece of Javascript to reformat the input.
But there's a lot there to unpack. What if the user enters only 4 numbers? What if they enter letters?
answered Jan 6 at 20:10
eaolsoneaolson
8,70163147
thanks for your input. am pretty sure the user will not enter letters
– rawle
Jan 7 at 13:23
add a comment |
You can't do this with a format mask because x/xx/xxx is not a representation for a number. It's sort of a date, but not quite. You don't say how this field will be stored in the database, but I'm guessing it will be a VARCHAR2. If you're just trying to reformat, say, user input of xxxxxx into x/xx/xxx, then you need a Dynamic Action for that, probably on the change of the field. That would run a piece of Javascript to reformat the input.
But there's a lot there to unpack. What if the user enters only 4 numbers? What if they enter letters?
answered Jan 6 at 20:10
eaolsoneaolson
8,70163147
You can't do this with a format mask because x/xx/xxx is not a representation for a number. It's sort of a date, but not quite. You don't say how this field will be stored in the database, but I'm guessing it will be a VARCHAR2. If you're just trying to reformat, say, user input of xxxxxx into x/xx/xxx, then you need a Dynamic Action for that, probably on the change of the field. That would run a piece of Javascript to reformat the input.
But there's a lot there to unpack. What if the user enters only 4 numbers? What if they enter letters?
answered Jan 6 at 20:10
eaolsoneaolson
8,70163147
answered Jan 6 at 20:10
eaolsoneaolson
8,70163147
answered Jan 6 at 20:10
eaolsoneaolson
8,70163147
answered Jan 6 at 20:10
eaolsoneaolson
8,70163147
8,70163147
thanks for your input. am pretty sure the user will not enter letters
– rawle
Jan 7 at 13:23
add a comment |
thanks for your input. am pretty sure the user will not enter letters
– rawle
Jan 7 at 13:23
thanks for your input. am pretty sure the user will not enter letters
– rawle
Jan 7 at 13:23
thanks for your input. am pretty sure the user will not enter letters
– rawle
Jan 7 at 13:23
add a comment |
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.
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%2f54007319%2fneed-format-or-input-mask%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
Hello! If your previous question was as terse and vague as this one, the reason why you don't get an answer is that you didn't provide enough information for people to help you. idownvotedbecau.se/itsnotworking. If you have not done that yet, remember that we have a site containing tips on how to ask a good question
– akraf
Jan 2 at 14:14
1
i have edited the question
– rawle
Jan 2 at 14:29
1
Possible duplicate: stackoverflow.com/questions/1041415/… . As you have not provided any hints on what you have tried or what similar tips you have found, I don't know if you have found this and it didn't work for whatever reason.
– akraf
Jan 2 at 14:39
Possible duplicate of Applying a phone number format mask in oracle apex
– Jeffrey Kemp
Jan 21 at 2:38