Invalid Floating Point Operation

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

johnnyjohnny
Posts: 1
Joined: Mon Oct 13, 2008 11:31 pm

Invalid Floating Point Operation

Postby johnnyjohnny » Mon Oct 13, 2008 11:41 pm

Hello
I'm currently using TextPipe to sort a csv-table numerically. Unfortunately the file is rather large (ca. 80 MB) and when I try to process the file, TextPipe usually stops at around 27MB with the error message "Invalid floating point operation". Can't TextPipe handle such big files? Is there a possible workaround?

Thx
johnny

User avatar
DataMystic Support
Site Admin
Posts: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Invalid Floating Point Operation

Postby DataMystic Support » Tue Oct 21, 2008 9:47 am

Hi Johnny,

1) Sounds like there is an invalid numeric value in the file which is causing the error, although this should not happen. We tested it here with invalid numeric values and it doesn't give an error, so I wonder what data you have.
.....We were finally able to get it to error out on data like
1e9999
1e-9999

We've now added a check for this for the next version.

2) Set the Sort\Maximum memory to use to 100MB.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest