Parse Numbers not parsing some attributes - attribute remains nominal
I'm starting to get the hang of this - a fully integrated RM and R setup with database access and all. However, I am struggling to get Parse Numbers to work on all data returned by R.
Some attributes are converted correctly, but others remain nominal although they are numerical text - Parse Numbers doesn't seem to convert them. I'm wondering if I can determine what is causing this and how to fix it. Some example of the data that is not converted:
1 93.8050166776113 0.0454157740586547 0.0443342630670029 1.47691587794877e-05
2 74.3344711293915 0.0468817728698001 0.0448437650275624 1.34038276456967e-05
3 74.3344711293915 0.0474954230324842 0.0453740966285467 1.22608784444541e-05
4 92.6475985034064 0.0491963308363763 0.0461385434701127 1.65735980572911e-05
2476 26.7948477790146 -0.00422690861908714 -0.0094301112003816 1.45483738479543e-05The only guess I have is that Parse Numbers can't handle the number of digits in the string and somehow fails? If any of you have thoughts, they would be greatly appreciated.
2477 8.61930163773315 -0.00573894600796043 -0.00869187816189736 1.35195186313268e-05
2478 37.0749500040653 -0.00627755754951664 -0.00820901403942122 1.64033364144268e-05
2479 78.0625143961145 -0.00488596064822655 -0.00754440336118229 1.51513082738902e-05