Text to Number

[pgolightly]

I have parsed a 400 character string from a .txt file in Input Data to 91 fields with set lengths based on a specified matrix using the 'Read as a fixed width text file'  option from the Resolve File type box that opens when the .txt file is selected.  One field needs to be converted from text to a four decimal number as shown. The text field contains no decimal point so removing the leading zeros doesn't work because it converts '000000437 to 437.

'000000437 to 0.0437

'000012587 to 1.2587

Thanks

[MarqueeCrew · Accepted solution]

ToNumber(left([input],5)+'.'+right([input],4))

that should do do the trick. 

Cheers,

mark

[Joe_Mako · Accepted solution]

How about:

ToNumber([Field])/10000