Search results for query: *

I've written a dozen or so small apps that read and write data in Excel, SQK Server2005, and Access using objects. I'm not a wiz but I can usually make it work. Now I need to move these programs over to C# (I have the express in my machine but can get the Professional should I need it. Before I...

That was it. I have to admit I got used to VB correcting the spelling for me. Thanks a bunch. Bruce

I'm trying to incorporate .PadRight into my program. I want to make sure each text line is 574 bytes long. I've tried several things, including some suggestions from here. Below is my code. I get the following error when I uncomment the bolded line below, but the console.write works. I'm sure...

Input is a ragged right text file, not all lines are the same length. The output has to be another text file with each record being 574 bytes long. I'm a Cobol guy that's done some C and VB coding. In VB I would just open the file, read a record into deers_in (see below), then just write the...

I'm trying to find all occurrences of a column named SSN in all tables in all user databases. A perfect solution would be to also alter the format of SSN to CHAR (9). Thanks, Bruce

Chris, I forgot to mention I planned on using a 2 dimensional array, 40 rows (1 per record) by 4 columns for the 4 fields in each input record. Bruce

Chris, Thanks for information. I've used SAS on the mainframe for 4 years, but for simple "quick and dirties". I'm a COBOL and VB programmer by trade. In reading all I could about SAS arrays from forums, the help files and 2 SAS programming books I admit to not knowing how SAS gets the data...

I have a file of records that contains a 7 position id, an 8 position YYYYMMDD start date, a state code, and an YYYYMMDD end date. There can be from 1 to 30 records with the same id. I'm trying to remove overlapping dates from the file. I need to read in all records with the same id and be able...