Recent content by sagobogger

Let's say I have two sets of data relating to the same population of individuals. DATASET1 has a 6 character ID as the identifier, DATASET2 has a 12 character ID as the identifier. The data files do not contain demographic info. So lets say we have someone called SMITH,JOHN and his ID in...

I need a simple (I think) master file but I'm just stuck :( I have three fields: ID_ONE/A6 ID_TWO/A12 NAME/A40 I need to be able to join to either ID_ONE or ID_TWO and get the NAME, so ID_ONE and ID_TWO both need to be indexed. (ID_ONE is in legacy data, ID_TWO is in current data.) I'll...

Hmmm, seems we discovered something that works differently in a saved .fex and entered directly at the >>

I'm sure I'm missing something obvious but I need to buy a clue. Someone decided it would be nicer to have some data feeds in mixed case instead of upper case, so before we got e.g. SMITH,JOHN and now we are suddenly getting Smith,John Previously WHERE NAME LIKE 'SMITH%' or WHERE NAME EQ...

The answer appears to be by using SCAN.

I need to change one field in a few records in a large .FOC table. Normally I would do that by creating a hold file with the corrected data, and then use a MODIFY to UPDATE the field in the .FOC. But this time it is an indexed field and I have run into the "A key field cannot be updated using a...

Unless I'm missing something I don't think FORMAT EXCEL will produce a compound/multitab report. (I didn't mention it above but it also has formulas.)

I'm having a problem with a Managed Reporting (web client) compound EXL2K format report that saves as a .XLS suffix file, but is really a "single file webpage" format file. This is transparent to later versions of Excel on the PC but causes problems on mac. I can fix it by opening it in Excel...

Thank you lionelhill, I'll look at sigmaplot, I'm not familiar with that one. "if you want a graph exactly 100 by 70mm, you just have to type in 100 and 70. This sort of thing ought to go without saying, but making a publication-quality figure with Excel is a nightmare." Yup, my thoughts exactly.

I'm interested to learn what programs folks are using when they need more sophisticated/flexible graphing than Excel can provide.

RewriteRule will also work. The difference is that a Redirect will cause the browser to display the target URL in the address box, but with a RewriteRule the displayed URL is the original one.

The big dog has the answer, it needs a full URL as the target. Thanks!

I added that redirect line to my .htaccess and the whole site became unreachable with a 500 error.

I need to redirect the url for one file e.g. http://www.mydomain.net/dir/thatfile.gif to a different file http://www.mydomain.net/dir/thisfile.php No wildcards/regex, just one defined URL to another defined URL. Could someone please show me the RewriteRule for that? Thanks!

Does anyone still use SpinRite? It was great back in the days of small disks, but the last time I tried it for a dodgy 20 gig one it was going to take about 200 hours to process. I guess if you have critical data and no backup that would be worth a try.