regex - javascript regular expression to parse a .net json Datetime - Stack Overflow

admin管理员组

文章数量:1390399

I'm no regular expression guru, so I'm asking for help to e out with a regular expression that would work like this:

var regExp = ???

regExp.exec('\/Date(1330848000000-0800)\/') = [..., '1330848000000', '0800']

// optional gmt
regExp.exec('\/Date(1330848000000)\/') = [..., '1330848000000', null]

regExp.exec('\/Date(1)\/') = [..., '1', null]

// gmt required if - is present
regExp.exec('\/Date(1330848000000-)\/') = null

// escaping backslash is required
regExp.exec('/Date(1330848000000-0800)\/') = null
regExp.exec('\/Date(1330848000000-0800)/') = null

// case sensitive
regExp.exec('\/date(1330848000000-0800)\/') = null

// only numbers allowed
regExp.exec('\/Date(1aaa848000000-0800)\/') = null
regExp.exec('\/Date(1330848000000-0a00)\/') = null

I got stuck pretty early with something as stupid as this:

/\\bla(.*)bla/.exec('\bla123bla') = null // instead of [ ..., '123']

new RegExp('\\\\bla(.*)bla').exec('\bla123bla') = null // instead of [ ..., '123']

I'm no regular expression guru, so I'm asking for help to e out with a regular expression that would work like this:

var regExp = ???

regExp.exec('\/Date(1330848000000-0800)\/') = [..., '1330848000000', '0800']

// optional gmt
regExp.exec('\/Date(1330848000000)\/') = [..., '1330848000000', null]

regExp.exec('\/Date(1)\/') = [..., '1', null]

// gmt required if - is present
regExp.exec('\/Date(1330848000000-)\/') = null

// escaping backslash is required
regExp.exec('/Date(1330848000000-0800)\/') = null
regExp.exec('\/Date(1330848000000-0800)/') = null

// case sensitive
regExp.exec('\/date(1330848000000-0800)\/') = null

// only numbers allowed
regExp.exec('\/Date(1aaa848000000-0800)\/') = null
regExp.exec('\/Date(1330848000000-0a00)\/') = null

I got stuck pretty early with something as stupid as this:

/\\bla(.*)bla/.exec('\bla123bla') = null // instead of [ ..., '123']

new RegExp('\\\\bla(.*)bla').exec('\bla123bla') = null // instead of [ ..., '123']

• javascript
• regex
• json
• date

Share Improve this question Follow asked Jan 30, 2013 at 4:31 opensasopensas 63.8k9090 gold badges265265 silver badges415415 bronze badges 3

• You seen this? stackoverflow./questions/1016847/… – elclanrs Commented Jan 30, 2013 at 4:44
• "Escaping backslash is required" - Actually, with or without the backslash, the 2 strings are exactly the same, since / doesn't need escaping. – nhahtdh Commented Jan 30, 2013 at 5:02
• Yes, I did realize that playing with chrome debugger, but .Net spec requires it, and I'd like to enforce it – opensas Commented Jan 30, 2013 at 5:05

Add a ment  | 

3 Answers 3

Sorted by: Reset to default 5

You can use this regex if the string never contains any other numbers apart from the time and the time zone:

/(\d+)(?:-(\d+))?/

Putting into your code:

var regex = /(\d+)(?:-(\d+))?/;
// regex.exec...

If you really need to validate and extract the numbers out of the string:

/^\/Date\((\d+)(?:-(\d+))?\)\/$/

The regex above will check that the string follows the exact format, and also extract the numbers out.

The following regex checks for your required constraints:

\\/Date\((\d{13})(-(\d{4}))?\)\\/

It checks for a \ followed by a / followed by the text Date followed by brackets enclosing 13 digits and an optional sequence of - followed by 4 digits, then a required \ and /.

The \\ matches a single \ which requires escaping as it is a special character in regex. Same is in the case of ( and ).

From this, $1 matches the 13 digits inside the brackets and $3 matches the 4 digits if present.

I kept playing with regular expressions and finally got it

The escaping slashes are just being ignored by javascript, so this it the solution I came out with (tested on chrome console)

var regExp
undefined

regExp = /^\/Date\((\d+)(?:-(\d+))?\)\/$/
/^\/Date\((\d+)(?:-(\d+))?\)\/$/

regExp.exec('\/Date(1330848000000-0800)\/')
["/Date(1330848000000-0800)/", "1330848000000", "0800"]

regExp.exec('\/Date(1330848000000)\/')
["/Date(1330848000000)/", "1330848000000", undefined]

regExp.exec('\/Date(1)\/')
["/Date(1)/", "1", undefined]

regExp.exec('\/Date(1330848000000-)\/')
null

regExp.exec('/Date(1330848000000-0800)\/')
["/Date(1330848000000-0800)/", "1330848000000", "0800"]

regExp.exec('\/Date(1330848000000-0800)/')
["/Date(1330848000000-0800)/", "1330848000000", "0800"]

regExp.exec('\/date(1330848000000-0800)\/')
null

regExp.exec('\/Date(1aaa848000000-0800)\/')
null

regExp.exec('\/Date(1330848000000-0a00)\/')
null

本文标签： regexjavascript regular expression to parse a net json DatetimeStack Overflow