How to fetch all dates and time from string using JavaScript/Jquery?

Question

I'm trying to fetch all DateTime fields using JS/Jquery.

Currently I'm trying it with Regex, but failing miserably.

INPUT:

12345 User Name 9/10/2018 11:39:37 AM Valid Entry Place1 
12345 User Name 9/10/2018 12:48:43 PM Valid Exit Outside Place1 
12345 User Name 9/10/2018 1:00:44 PM Valid Entry Place1 
12345 User Name 9/10/2018 2:17:01 PM Valid Exit Outside Place1 
12345 User Name 9/10/2018 3:23:36 PM Valid Entry Place1 
12345 User Name 9/10/2018 3:25:56 PM Valid Entry Place1 
12345 User Name 9/10/2018 6:06:25 PM Valid Exit Outside Place1 
12345 User Name 9/10/2018 6:07:55 PM Valid Entry LC 
12345 User Name 9/10/2018 6:28:19 PM Valid Exit Outside LC 
12345 User Name 9/10/2018 6:30:06 PM Valid Entry Place1

EXPECTED OUTPUT:

9/10/2018 11:39:37 AM
9/10/2018 12:48:43 PM
9/10/2018 1:00:44 PM
9/10/2018 2:17:01 PM
9/10/2018 3:23:36 PM
9/10/2018 3:25:56 PM
9/10/2018 6:06:25 PM
9/10/2018 6:07:55 PM
9/10/2018 6:28:19 PM
9/10/2018 6:30:06 PM

CURRENT LOGIC:

function myFunction() {
    var str = document.getElementById("demo").innerHTML; 
    var txtIdAndName = str.replace(/[0-9]*\s[a-z,\s*]*/ig,"");
    var txtStatusAndPlace = txtIdAndName.replace(/[AM,PM]+\s[a-z,\s*]*/ig,"<br/>");
    document.getElementById("demo").innerHTML = txtStatusAndPlace;
}

Please do let me know if any more info is needed form my end.

Can use any Logic or method to achieve the task.

Thanks in advance

Wiktor Stribiżew · Accepted Answer · 2018-09-11 07:32:51Z

2

You may match these substrings with

s.match(/\b\d{1,2}\/\d{1,2}\/\d{4}\s+\d{1,2}:\d{2}:\d{2}\s*[AP]M\b/g)

See the regex demo

Details

\b - a word boundary
\d{1,2} - 1 or 2 digits,
\/ - a slash (escaped since a regex literal notation is used with / as delimiters)
\d{1,2}\/\d{4} - 1 or 2 digits, / and then 4 digits
\s+ - 1+ whitespaces
\d{1,2}:\d{2}:\d{2} - (time pattern) 1 or 2 digits, :, 2 digits, : and another 2 digits
\s* - 0+ whitespaces
[AP] - A or P
M - an M char
\b - a word boundary.

JS demo:

var s = "12345 User Name 9/10/2018 11:39:37 AM Valid Entry Place1 \n12345 User Name 9/10/2018 12:48:43 PM Valid Exit Outside Place1 \n12345 User Name 9/10/2018 1:00:44 PM Valid Entry Place1 \n12345 User Name 9/10/2018 2:17:01 PM Valid Exit Outside Place1 \n12345 User Name 9/10/2018 3:23:36 PM Valid Entry Place1 \n12345 User Name 9/10/2018 3:25:56 PM Valid Entry Place1 \n12345 User Name 9/10/2018 6:06:25 PM Valid Exit Outside Place1 \n12345 User Name 9/10/2018 6:07:55 PM Valid Entry LC \n12345 User Name 9/10/2018 6:28:19 PM Valid Exit Outside LC \n12345 User Name 9/10/2018 6:30:06 PM Valid Entry Place1";
var rx = /\b\d{1,2}\/\d{1,2}\/\d{4}\s+\d{1,2}:\d{2}:\d{2}\s*[AP]M\b/g;
document.body.innerHTML = "<pre>" + s.match(rx).join("<br/>") + "</pre>";

edited Sep 11, 2018 at 7:32

answered Sep 11, 2018 at 7:24

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Nambi_0915 Over a year ago

changing \d{2} to \d{1,2} in date will also match 12345 User Name 9/7/2018 12:48:43 PM Valid Exit Outside Place1

Wiktor Stribiżew Over a year ago

@NambiMurugan Fair enough, I added the minimum limit to the quantifier.

theLearner Over a year ago

@Wiktor Stribiżew This worked for me. Thanks a ton for the extra effort put in.

Nambi_0915 · Accepted Answer · 2018-09-11 07:35:50Z

0

Try this regex,

\d+\/\d+\/\d+\s*\d+:\d+:\d+\s*[AP]M

Demo

edited Sep 11, 2018 at 7:35

answered Sep 11, 2018 at 7:24

Nambi_0915

1,0998 silver badges22 bronze badges

1 Comment

Wiktor Stribiżew Over a year ago

Note that \s*? will yield the same result as \s* since \d+ (pattern after) does not match a whitespace.

Mohammad · Accepted Answer · 2018-09-11 07:36:52Z

0

Other users posted answer for using regex. But you can use another way instead of regex if structure of your string is constant.

Using javascript .split() to splitting string and using .splice() to selecting special part of result.

var str = document.getElementById("demo").innerHTML;
var newStr = str.trim().split("\n").map(function(text){
    return text.split(" ").splice(3, 3).join(" ");
}).join("\n");
console.log(newStr);

<div id="demo">
12345 User Name 9/10/2018 11:39:37 AM Valid Entry Place1 
12345 User Name 9/10/2018 12:48:43 PM Valid Exit Outside Place1 
12345 User Name 9/10/2018 1:00:44 PM Valid Entry Place1 
12345 User Name 9/10/2018 2:17:01 PM Valid Exit Outside Place1 
12345 User Name 9/10/2018 3:23:36 PM Valid Entry Place1 
12345 User Name 9/10/2018 3:25:56 PM Valid Entry Place1 
12345 User Name 9/10/2018 6:06:25 PM Valid Exit Outside Place1 
12345 User Name 9/10/2018 6:07:55 PM Valid Entry LC 
12345 User Name 9/10/2018 6:28:19 PM Valid Exit Outside LC 
12345 User Name 9/10/2018 6:30:06 PM Valid Entry Place1
</div>

answered Sep 11, 2018 at 7:36

Mohammad

21.5k16 gold badges58 silver badges86 bronze badges

1 Comment

theLearner Over a year ago

Yes, even this option works great. Thanks for the reply

Collectives™ on Stack Overflow

How to fetch all dates and time from string using JavaScript/Jquery?

3 Answers 3

3 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related