G
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 Access and somehow convert
the long file paths/names to short file paths/names? 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!
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 Access and somehow convert
the long file paths/names to short file paths/names? 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!