What is the regex for date type

Question

I have one string I want to find out all date values and relace them with specific string.

My code looks like:

String mydata = "{[... \"date\":\"2016-03-16T12:38:28.390Z\"]},{[ ... \"date\":\"2016-03-16T12:38:28.390Z\" ...]}";
        Pattern pattern = Pattern.compile("");
        Matcher matcher = pattern.matcher(mydata);
        while(matcher.find()){
            mydata = mydata.replace(matcher.group(), matcher.group().substring(0, 10));
        }
        System.out.println(mydata);

What string regex I should pass in Pattern.compile("");?

My output should look like:

{[... "date":"2016-03-16"]},{[ ... "date":"2016-03-16" ...]}

It lloks like json data. So you should use a json Parser not regex — Jens, Apr 06 '16 at 06:18

score 0 · Answer 1 · edited May 23 '17 at 12:24

0

import org.json.*;


JSONObject obj = new JSONObject("{[... "date":"2016-03-16"]},{[ ... "date":"2016-03-16" ...]}");

The rest of the code depends on your json-structure. Have a look at:

How to parse JSON in Java

or

Java Api Link JsonObject

edited May 23 '17 at 12:24

Community

1
1

answered Apr 06 '16 at 06:26

osanger

2,276
3
28
35

score 0 · Answer 2 · answered Apr 06 '16 at 07:19

I am not sure about T and Z from input. If they are same always, then below regex will work. If T and Z not constant then change T and Z by [A-Z] in regex.

one more change i did, replaced

mydata = mydata.replace(matcher.group(), matcher.group().substring(0, 10));

by

mydata = matcher.replaceAll("");

It getting required output.

String mydata = "{[\"date\":\"2016-03-16T12:38:28.390Z\"]},{[\"date\":\"2016-03-16T12:38:28.390Z\"]}";

Pattern pattern = Pattern.compile("T\\d{2}\\:\\d{2}\\:\\d{2}\\.\\d{3}Z");

Matcher matcher = pattern.matcher(mydata);
while(matcher.find()){
   mydata = matcher.replaceAll("");
}
System.out.println(mydata);

score 0 · Answer 3 · answered Apr 06 '16 at 07:25

If you want a regex based solution this seems to work for your example

Pattern pattern = Pattern.compile("(\\{\\[.*?\"date\":\"\\d{4}\\-\\d{2}\\-\\d{2}).*?(\"\\]\\})");
Matcher matcher = pattern.matcher(mydata);

while(matcher.find()) {
    System.out.println(matcher.group(1) + matcher.group(2));
}

IDEONE DEMO

What is the regex for date type

3 Answers3