JUSTPATH() will extract a path w/o backslash at the end from a file name. ADDBS() will add backslash at the end of a directory name if there isn't one. However, to get correct results you have to apply JUSTPATH() to a file name and ADDBS() to a directory names respectively.

>
>I have :
>
>"c:/data/data1/myfile.txt " and i want "c:/data/data1/"
>OR
>"c:/data/data1 " and i want "c:/data/data1/"
>OR
>"c:/myfile.txt " and i want "c:/"
>OR
>"c:/data/myfile.txt " and i want "c:/data/"
>
>Thanks in advance or help.
>
>bernhart