Regular Expressions 101

Community Patterns

Community Library Entry

2

Regular Expression
ECMAScript (JavaScript)

/
([1-3]{1,2}-[A-Z][a-z]{2}-[0-9]{2}).([0-9]{5}).([A-Z][A-Za-z].{2,}).([0-9]{1,2}\.[0-9]{0,2})\n
/
g

Description

Lets you rearrange columns of time data exported from the On The Job app to something more useful in Excel as required. Still a work in progress as this gets tweaked for improvement and streamlining.

Submitted by anonymous - 9 years ago