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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding, printing and counting substrings in VBA
If I have a worksheet with alphanumeric string data in columns like: Column A -------- Row 1 %4(_XY76 Row 2 ^&*_XY11 Row 3 :)*_XY7- Row 4 *()_XY7Y Row 5 *)(_XY11 What code can I write that will (1) find the occurrence of the substrings "_XY7" and "_XY11", (2)...- Argonath
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Creating Filters with UserForms, List Boxes and Command Buttons
What modifications do I need to make to the following code to filter column-based data fields in an Excel spreadsheet? The List Boxes (ListBox1 and ListBox2) are the data elements to be selected in columns named "Column_X_Data" and "Column_2_Data", respectively. The data looks like: Column...- Argonath
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Borland C++ Builder 6.0 and Windows NT - System Resource Problem
I recently installed Borland C++ Builder Pro Version 6.0 on a Windows NT Machine and upon starting the C++ application am receiving a "Not enough system resources" error. No other processes are running in the background and the Virtual Memory settings are set to what Windows NT advises. What...- Argonath
- Thread
- Replies: 1
- Forum: Embarcadero: C++Builder
-
Perl colon-delimited text file reading & parsing
I have a text file (Microsoft Access Locked database (.LDB) file that I am able to read and display as a single stream using the short script as follows: ----------------------------------------------------------- #!/usr/local/bin/perl/ open(INFILE,'TEST.LDB') || die("Could not open file!")... -
reading and parsing .ODB files in Perl
Can a script be written to read and parse .ODB files in Perl that is independent of the DBI? Before I realized that Perl had a DBI specifically for this purpose I was working on a script to read an .odb file: -----------------------------------------------------------... -
Writing and Calling the Factorial Function (QBasic rookie)
I am relatively new to QBasic and am writing a simple tool which will compute (and display) the results of the Binomial PDF and CDF given n trials, k opportunities, and a probability of success in each trial of ReplyProb. I need to use a Factorial function but since QBasic has no such function...
