Long file names to short file names

[Guest]

OK, he're's the dilemma.

I have two lists of files I've imported. One has the file names/paths in
long format that contains the path, name, size, last accessed, etc.

The other list has them in DOS format wiht name, path size, last accessed
and owner.

I need to get the file name strings in the same format so I can compare the
two and put the owners to the long file names.

Is there some magical way to put these lists in a query and and somehow
convert
the long file paths/names to short file paths/names in a new field? It's
the only way I can think of to get the files in sync. I thought of
converting from short to
long, but my problem is I may have three files with a short name of
OGS101~1.TXT that have three different owners - how would I know what one is
~1, ~2 or ~3 when they are all the same size/file date?

I found some scripts that take out the spaces, but I don't know how the
short file name handles special characters and how it truncates to ~2, ~3,
etc.

Any help would be greatly appreciated!

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

If you're using Microsoft's web interface to post, you should see an
"Advanced Options" link at the bottom of the page. You can type the names of
the various groups into the Newsgroup box, separating each newsgroup name
with a semicolon.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups. (And, for what it's worth, this question isn't
appropriate for this particular newsgroup. This newsgroup is for questions
about using queries in Access, not for general queries about Access)

 

[Guest]

No, I posted to exactly the groups I wanted to...I wanted to see if this can
be done in a query. I also posted a similar question in MSExcel groups in
case I had to use that application instead of Access.

And I didn't 'cross post' for exactly the reason you stated...that people
think 'it's a bad thing'. Funny, when you DO cross post people tear you a
new one, and when you don't, you still get grief. Maybe you guys should all
get together and decide what you want us to do and stick with the decision.