Regular Expressions 101

Community Patterns

OnTheJob CSV Export to Excel Tab Delimited Import

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 - 8 years ago