https://community.esri.com/t5/python-questions/get-parent-folder-of-gdb-as-a-string/m-p/1209893#M65492 <LI-CODE lang="python">from pathlib import Path def get_folder(dataset): parent = Path(dataset).parent if "." in parent.name: # .gdb, .sde return str(parent.parent) return str(parent)</LI-CODE> Tue, 06 Sep 2022 14:51:09 GMT JohannesLindner 2022-09-06T14:51:09Z https://community.esri.com/t5/python-questions/get-parent-folder-of-gdb-as-a-string/m-p/1209873#M65490 <P>I just need a bit of code that will look at the input feature class and return a value which is the parent OS folder that the GDB or SDE or other database resides in.</P><P>So far i have the following, but it returns the full path up to the feature dataset. I would like the code to return the folder path up until a geodatabase, And if the data is a shapefile, to just choose the parent folder.</P><LI-CODE lang="python">import arcpy, os from arcpy import metadata as md dataset = arcpy.GetParameterAsText(0) workspace = os.path.dirname(dataset) walk = arcpy.da.Walk(workspace) for dirpath, dirnames, filenames in walk: arcpy.AddMessage(dirpath)</LI-CODE><P>Greatly appreciated,&nbsp;</P> Tue, 06 Sep 2022 14:36:54 GMT https://community.esri.com/t5/python-questions/get-parent-folder-of-gdb-as-a-string/m-p/1209873#M65490 David_Brooks 2022-09-06T14:36:54Z https://community.esri.com/t5/python-questions/get-parent-folder-of-gdb-as-a-string/m-p/1209893#M65492 <LI-CODE lang="python">from pathlib import Path def get_folder(dataset): parent = Path(dataset).parent if "." in parent.name: # .gdb, .sde return str(parent.parent) return str(parent)</LI-CODE> Tue, 06 Sep 2022 14:51:09 GMT https://community.esri.com/t5/python-questions/get-parent-folder-of-gdb-as-a-string/m-p/1209893#M65492 JohannesLindner 2022-09-06T14:51:09Z