Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
improved parsing out to .htm
I've written a script that will read an 8 part string that starts with the word -alias-. It extracts the 2nd, 6th and 8th variable and prints it out to htm with count in a table format. example: http://www.graffece.com/dev/prevplanout.htm I have 3 problems One. I would like to further isolate... -
Booting Users from Access
Is there a code that gracefully kills the .ldb instance that appears when a user is in Access. Or in otherwords kicks the user out. I have a script that will resync, lockdown and compress an .mdb. Only problem is that users will forget they have the app open when it's time to do maintenance and...- nanohurtz
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Exporting Recordsets to .xls
Hi, I am trying to write a SubRoutine/SQL statement that will group data by zipcode and export each recordset into individual spread sheets based on those groupings. (i.e. 10472.xls 10888.xls..). I've written the SQL to group all Zipcodes and output to a recordset (rst). The second query uses...- nanohurtz
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Getting Rid of Redudant Data
I need to modify this code to eliminate any duplicate 'words' it picks up from a flat file THE CODE #!/usr/bin/perl -w open(IN, "< scdreader.txt") or die "Cannot open file for read\n"; open(OUT, "> scdreaderout.txt") or die "Cannot open file for... -
Few lines of Code Needed
well..since noone helped with the Pattern search part of my request today, I managed to muster up the rather lengthy script on my own. It was successfully tested using optiPerl3 (my favorite)..flawless. One problem though, it's too long. Can some one tighten this code up by a few lines and still... -
Advanced Pattern Searching Snippet
Hi, I'm looking for a .pl code snippet that can read a .txt flat file of 12,000 jobs like the ones included below (FLATFILE INPUT) and output to 6 column .xls output as also included. Please note that some of the lines defy the $_=~/m^(.*)#(.*) or (SERVER)#(JOB) pattern because the flat file was...
