Omniscope Help Center

Here's a handy formula that will trim leading zeros (any number) in data that might contain mix of numbers and text.

MID([Field 1], SEARCHREGEX(`[^0]`, [Field 1]), LEN([Field 1]))