Import few digits and trim rest

[sfast]

I have to import a file to MySQL database with a numeric field that has values as -

007234560999.

When I import that file, this field should import 723456 only. I mean should trim (00) from left and accept 6 digits and then reject any other digits.

How can I do it?

The only way I could think of it is import the original data to the table and trim the field values and store it again.

Thanks

[coopster]

Just define the column in your table properly and upon import you won't have to do any type of conversion whatsoever.

[sfast]

Thanks for responding, Coopster.
But how do I define the column in the table to skip 00 at start?

[coopster]

More than likely as an INTEGER, but you'll have to make that decision based on the largest value expected. Probably an UNSIGNED INTEGER.

[dev.mysql.com...]

[whoisgregg]

If you were going to preprocess the file with PHP, you could use substr [php].

echo substr("007234560999", 2, 6); // 723456

[sfast]

Thanks everybody , thats what I did. used substr.