June 4, 2008 at 12:02 pm
I've got a package that imports a flat file into a table and unfortunately one of the fields that gets converted to money is coming in as just real numbers and the transform is appending the decimal and 4 zeros at the end of it.
Example:
14325 -> 14325.0000
What I want is:
14325 -> 143.2500
I'm figuring I'm going to have to fiddle around with replace but I'm sure this has been encountered before. Any suggestions?
June 4, 2008 at 12:27 pm
david.burrows (6/4/2008)
I've got a package that imports a flat file into a table and unfortunately one of the fields that gets converted to money is coming in as just real numbers and the transform is appending the decimal and 4 zeros at the end of it.Example:
14325 -> 14325.0000
What I want is:
14325 -> 143.2500
I'm figuring I'm going to have to fiddle around with replace but I'm sure this has been encountered before. Any suggestions?
Looks like you're not getting the decimal point. You just have to divide by 100, no?
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply