Removing preceding Zeros

Situation:
The table field contains non numeric data preceded by zero like the one below,

FieldName
0000000234
0000123456
0000000034
0000000056

When we load this data into qlikview, it can not be converted into numeric, you will get the result like the same. but if you want to convert this non numeric data into numeric then it would be a challenge.

your general script would look like this:

Load
FieldName
From Data Source;

now, to convert this field values into numeric you can use the following functions.

Load
mid(FieldName,findoneof(FieldName, '123456789')) as FieldName
From Data Source;

This script will convert the non numeric data into numeric and also removes the preceding zeros.