Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Requirement

Regex Setting

Example

Remove leading zero.

Pattern: (^|\s)0+

000123 Sales Office => 123 Sales Office
Cost centre: 0000123 Sales Office => Cost centre: 123 Sales Office

Format a number that has only zeros

Pattern: (^|\D)0+(\D|$)

Replacement: 0,

0000 => 0
Batches: 000, 1 => Batches: 0, 1

...