Function using regular expression to extract start and end date from string column
0
have a data set like below and need to extract start date and end date using regular expression in postgresql
OCT-16
(SEPT-16 )
(JULY-AUG-16)
( JULY-16 TO OCT-16 )
(SEP TO OCT 2016 )
( NOV-16 )
( NOV-16)
(October16)
(SEP - 2016)
(OCt - 2016)
( SEPT-16 )
November 2016
postgresql
edited Nov 23 '18 at 7:13
a_horse_with_no_name
305k46466562
asked Nov 23 '18 at 7:03
srikrishnasrikrishna
82
add a comment |
0
have a data set like below and need to extract start date and end date using regular expression in postgresql
OCT-16
(SEPT-16 )
(JULY-AUG-16)
( JULY-16 TO OCT-16 )
(SEP TO OCT 2016 )
( NOV-16 )
( NOV-16)
(October16)
(SEP - 2016)
(OCt - 2016)
( SEPT-16 )
November 2016
postgresql
edited Nov 23 '18 at 7:13
a_horse_with_no_name
305k46466562
asked Nov 23 '18 at 7:03
srikrishnasrikrishna
82
What is the expected result for the above data? What if there is only one date in that column, e.g. is the first line a start or end date? Are two dates always "separated" byto?
– a_horse_with_no_name
Nov 23 '18 at 7:14
@a_horse_with_no_name: for this ( JULY-16 TO OCT-16 ) input expected result start_dt: 01-jul-16 and end_dt: 31-OCT-16.
– srikrishna
Nov 23 '18 at 10:02
@a_horse_with_no_name: if only one date is present for instance OCT-16 then start_dt :01-OCT-16 and End_dt : 31-OCT-16
– srikrishna
Nov 23 '18 at 10:04
add a comment |
0
0
0
have a data set like below and need to extract start date and end date using regular expression in postgresql
OCT-16
(SEPT-16 )
(JULY-AUG-16)
( JULY-16 TO OCT-16 )
(SEP TO OCT 2016 )
( NOV-16 )
( NOV-16)
(October16)
(SEP - 2016)
(OCt - 2016)
( SEPT-16 )
November 2016
postgresql
edited Nov 23 '18 at 7:13
a_horse_with_no_name
305k46466562
asked Nov 23 '18 at 7:03
srikrishnasrikrishna
82
have a data set like below and need to extract start date and end date using regular expression in postgresql
OCT-16
(SEPT-16 )
(JULY-AUG-16)
( JULY-16 TO OCT-16 )
(SEP TO OCT 2016 )
( NOV-16 )
( NOV-16)
(October16)
(SEP - 2016)
(OCt - 2016)
( SEPT-16 )
November 2016
postgresql
postgresql
edited Nov 23 '18 at 7:13
a_horse_with_no_name
305k46466562
asked Nov 23 '18 at 7:03
srikrishnasrikrishna
82
edited Nov 23 '18 at 7:13
a_horse_with_no_name
305k46466562
asked Nov 23 '18 at 7:03
srikrishnasrikrishna
82
edited Nov 23 '18 at 7:13
a_horse_with_no_name
305k46466562
edited Nov 23 '18 at 7:13
a_horse_with_no_name
305k46466562
edited Nov 23 '18 at 7:13
a_horse_with_no_name
305k46466562
305k46466562
asked Nov 23 '18 at 7:03
srikrishnasrikrishna
82
asked Nov 23 '18 at 7:03
srikrishnasrikrishna
82
asked Nov 23 '18 at 7:03
srikrishnasrikrishna
82
82
What is the expected result for the above data? What if there is only one date in that column, e.g. is the first line a start or end date? Are two dates always "separated" byto?
– a_horse_with_no_name
Nov 23 '18 at 7:14
@a_horse_with_no_name: for this ( JULY-16 TO OCT-16 ) input expected result start_dt: 01-jul-16 and end_dt: 31-OCT-16.
– srikrishna
Nov 23 '18 at 10:02
@a_horse_with_no_name: if only one date is present for instance OCT-16 then start_dt :01-OCT-16 and End_dt : 31-OCT-16
– srikrishna
Nov 23 '18 at 10:04
add a comment |
What is the expected result for the above data? What if there is only one date in that column, e.g. is the first line a start or end date? Are two dates always "separated" byto?
– a_horse_with_no_name
Nov 23 '18 at 7:14
@a_horse_with_no_name: for this ( JULY-16 TO OCT-16 ) input expected result start_dt: 01-jul-16 and end_dt: 31-OCT-16.
– srikrishna
Nov 23 '18 at 10:02
@a_horse_with_no_name: if only one date is present for instance OCT-16 then start_dt :01-OCT-16 and End_dt : 31-OCT-16
– srikrishna
Nov 23 '18 at 10:04
What is the expected result for the above data? What if there is only one date in that column, e.g. is the first line a start or end date? Are two dates always "separated" by
to?– a_horse_with_no_name
Nov 23 '18 at 7:14
What is the expected result for the above data? What if there is only one date in that column, e.g. is the first line a start or end date? Are two dates always "separated" by
to?– a_horse_with_no_name
Nov 23 '18 at 7:14
@a_horse_with_no_name: for this ( JULY-16 TO OCT-16 ) input expected result start_dt: 01-jul-16 and end_dt: 31-OCT-16.
– srikrishna
Nov 23 '18 at 10:02
@a_horse_with_no_name: for this ( JULY-16 TO OCT-16 ) input expected result start_dt: 01-jul-16 and end_dt: 31-OCT-16.
– srikrishna
Nov 23 '18 at 10:02
@a_horse_with_no_name: if only one date is present for instance OCT-16 then start_dt :01-OCT-16 and End_dt : 31-OCT-16
– srikrishna
Nov 23 '18 at 10:04
@a_horse_with_no_name: if only one date is present for instance OCT-16 then start_dt :01-OCT-16 and End_dt : 31-OCT-16
– srikrishna
Nov 23 '18 at 10:04
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
});
}
});
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%2fstackoverflow.com%2fquestions%2f53442016%2ffunction-using-regular-expression-to-extract-start-and-end-date-from-string-colu%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 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.
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%2fstackoverflow.com%2fquestions%2f53442016%2ffunction-using-regular-expression-to-extract-start-and-end-date-from-string-colu%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
What is the expected result for the above data? What if there is only one date in that column, e.g. is the first line a start or end date? Are two dates always "separated" by
to?– a_horse_with_no_name
Nov 23 '18 at 7:14
@a_horse_with_no_name: for this ( JULY-16 TO OCT-16 ) input expected result start_dt: 01-jul-16 and end_dt: 31-OCT-16.
– srikrishna
Nov 23 '18 at 10:02
@a_horse_with_no_name: if only one date is present for instance OCT-16 then start_dt :01-OCT-16 and End_dt : 31-OCT-16
– srikrishna
Nov 23 '18 at 10:04