Search results

If you used a RegEx you'd be able to check and remove the offending characters all in one command!

Definitely a task for Regular Expression. Also what about foreign names with umlauts, hyphens, ^, ´, ` etc.,

I can honestly say that in 40+ years of computing from back in the days of coding sheets and punch cards I have only ever heard/used CRUD. Don't you just hate it when people re-invent the wheel. Especially when they tell you that square wheels are now the thing.

I just assumed it opened at user documents folder as that's what mine does.

How you can build any database without proper design planning including RDA defeats me, and is regularly the core problem with items on this site! Reminds me of the old Two Ronnies country yokels sketch who when asked for directions reply with "If I was going there I wouldn't start from here".

I think you are oversimplifying it. As I read it, it was also identifying the opposite - files where no record exists: and this has been the basis of most of the efficiency arguments(discussion). The missing files task you refer to is the simple part of the operation!

This would be a useful idea but not for me. I only run the complete system occasionally as a housekeeping and pretty much it seldom ever identifies any discrepancies. Mostly my Database Adds records as I add new files to my archive, and deleting a record deletes the associated file.

This whole thread has been fascinating to me so I did a bit of experimenting with my Archive database tables. Dictionaries, temp files, findFirst, Seek etc. There was actually little to choose between any of the method. Surprisingly using Seek instead of FindFirst gave only marginal...

We now have an example of convergence between the two language variants. The usage of the adjective military: this now generally refers to all armed services in UK in the same way it changed in 1920s in the USA. When I joined the Army in 1967 the word solely referred to the Army. Even now the...

Yes there is - when you right-click on it on the task bar and the options of Command Prompt and Unpin from Task Bar appear , Right-Click on 'Command Prompt' and choose the Run As Administrator option. This is standard taskbar behaviour.

One nuance I hadn't thought of when trying to help on this topic is of course the size on disc requirement - this of course is not constant and differs from PC to PC according to its configuration. I'd like to see the usage intended for it.

You aren't doing anything wrong. You are trying to mix two different things. I forgot to say that GetFileProperty() is a separate function which I didn't supply the code for as I consider it too clumsy, for this task. I only ever use it to get graphics dimensions. I can supply the code if...

I'll just say that I have tried many methods, including dictionaries, and this method has proven to be the quickest. Just remember we are talking of thousands of files. I do iterations twice because they are separate logical processes. One is to remove extraneous records, the other to record...

The paradigm I use albeit on about only 8% of the number files is two part process. First iterate through the table where (assuming you have stored the full paths) checking every file listed exists ( using FSO.FileExist() and if not delete the record in the table. Secondly, iterate through...

Probably a good job we don't normally require that level of exactitude :)

One point - the Size returned by Extended File properties "Size" and "Total size" are in the abbreviated format '446 GB' etc, whereas the FSO 'size' property of a FSO file is in full numeric format eg, 58,520,161. Actual examples: FSO ...

One question that hasn't been asked is how often will you want to do this? If it is seldom, or once only, or just an initial load then anything that does the job is OK. Only if it is a regular occurrence for regular updates does seeking the best way makes sense. Also there is no hint at the...

Not as bad as it sounds - you just hit the Return key and problem dealt with. Big thing to remember was/is to ALWAYS start a database explicitly using the version you want - there's no depending on double clicking a database to open it. Whole heartedly agree with VM - had this on my Windows...

I'm happily running 2003 an 2010 on my laptop but it is on Winows 7.

As I was told at school - the only really stupid question is the one you should have asked but didn't. Just keep asking.