hash file directory path does not take spaces

battleboy1 · Post by **battleboy1** » Fri Dec 23, 2005 3:05 pm

Hi,

while i try to create a hash file in remote network drive. i specified the path which has spaces for directories. for ex:

c:\new folder\some folder....

i get error message saying that the path for hash file should not contain spaces.

i tried searching the forum but couldnt find anything.

is there a solution where i can mask the space and specify the path.??

thanks in advance

ameyvaidya · Post by **ameyvaidya** » Fri Dec 23, 2005 4:58 pm

As far as the windows OS is concerned, the alternative way to handle long file names are:

use the first 6 non-whitespace characters with a ~1( or ~2 and so on if multiple folders qualify).

e.g. "c:\Program Files"
becomes:
"c:\progra~1"

hth

battleboy1 · Post by **battleboy1** » Fri Dec 23, 2005 5:33 pm

what if the first word is less than 6 non space characters? can you please take the same example.

thanks.

ameyvaidya · Post by **ameyvaidya** » Fri Dec 23, 2005 5:47 pm

Just pick the first six non-space characters(not just the first word, the entire name):

"c:\documents and settings\admin\my documents"
becomes:
"c:\docume~1\admin\mydocu~1"

ArndW · Post by **ArndW** » Sat Dec 24, 2005 3:17 am

The DIR /X command will show you what the 8.3 name of a Windows file is, sometimes when there are duplicates the ending is not ~1. The DataStage engine came from operating systems that did not allow spaces in the path and I have never felt comfortable using such filenames as they didn't always function correctly, even in places where it should be allowed.