Hi list Im sure this is a simple one but being relatively new, Im trying to populate a popup menu with a list of currently open tables for the user to select from.
Ive been searching the help all morning but it seem to be escaping me. Any hints TIA Carolyn -----Original Message----- From: Bill Thoen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 October 2005 8:45 AM To: [email protected] Subject: MI-L SUM: Problem Breaking Up Large Files Problem: How do you break up a file bigger than 2 GB into smaller pieces so that you can load it into software like Access or MapInfo? Writing a program in VBA or MapBasic won't work because these programs can't work with files larger than 2GB. In fact, you can't even open a file bigger than 2GB with these tools. I also couldn't do with gcc (but my version wasn't compiled for BIG files.) Solution: I used Perl on my Linux box and it worked great. Score one for Open Source! Here's the code: (modified from code sent by Michael Taylor) open(IN,"<WhopperFile.txt"); open(OUT1,">part1.txt"); open(OUT2,">part1.txt"); while (<IN>) { $i++; if ($i<1000000) { # This is the line number cutoff print OUT1 $_; } else { print OUT2 $_; } } close IN; close OUT1; close OUT2; Other Solutions: 1. Use an editor like TextPad or UltraEdit. This works but it's not fast. 2. Half the people who responded mentioned SRC's PinPointCRM. You can download a trial version from ftp://ftp.extendthereach.com/GET/PinPointCRM/ Thanks, everyone! - Bill Thoen --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18132 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18133
