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!
-
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
Opening the .LDB file in notepad gives a header, whitespace, field, whitespace, data, whitespace, as follows: [COLOR=red]HeaderVersion:[/color red]X.X-XXX[COLOR=red]Source File:[/color red] Filename >[COLOR=red]Date/Time:[/color red] MM-DD-YY at HH:MM:SSNextField:THIS_IS_WHAT_IT_LOOKS_LIKE... -
Perl colon-delimited text file reading & parsing
chazoid, do you mean something like this - ----------------------------------------------------------- [COLOR=blue] #!/usr/local/bin/perl -w #this command opens the .ldb file open(odbfile_in,"+<ANYFILE.LDB") || die("Could not open file!"); # this section contains properties of the open... -
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)
The following are all of my dimension statements: DIM SHARED N AS INTEGER DIM SHARED K AS INTEGER DIM SHARED i AS INTEGER DIM tot AS DOUBLE DIM SHARED A$(15) I added the following code block: DIM SHARED factorial$(15) OPEN... -
Writing and Calling the Factorial Function (QBasic rookie)
I added the following lines to my code: DEFDBL A-Z DIM SHARED total AS DOUBLE DIM tot AS DOUBLE I verified by a debug/trace that the SUB simpfact is being called but total is not holding the value I intend to return from the subroutine (which is, of course, the value of the factorial). In... -
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...
