+38Hi,
I'm looking for a best practice to extract parts of a path name.
If I have a path: S:\\Miljø og teknik\\Svendborg Vand\\Anlæg vand\\Microstation\\Dokgraf dokumenter\\VandGraf\\vand_knude\\ULB00004\\Arbejdsrapport.pdf
I need to extract the part starting with "VandGraf", i.e.: "VandGraf\\vand_knude\\ULB00004\\Arbejdsrapport.pdf" into one attribute, and the file name into another.
What is the simplest way to accomplish this (without custom Python coding) ?
Cheers.
Best answer by ebygomm
String searcher with some regex possibly depending on the exact rules you want to follow, e.g. do you need everything always starting with VandGraf or everything at that level which sometimes might be in a folder not called VandGraf?
If the latter, finding the substring after every 6th backslash might be more straightforward e.g.
+44String searcher with some regex possibly depending on the exact rules you want to follow, e.g. do you need everything always starting with VandGraf or everything at that level which sometimes might be in a folder not called VandGraf?
If the latter, finding the substring after every 6th backslash might be more straightforward e.g.
+7You can also use an attributesplitter. Splitting on the '\\' but it has to be in the same place in the list.
+38String searcher with some regex possibly depending on the exact rules you want to follow, e.g. do you need everything always starting with VandGraf or everything at that level which sometimes might be in a folder not called VandGraf?
If the latter, finding the substring after every 6th backslash might be more straightforward e.g.
+38You can also use an attributesplitter. Splitting on the '\\' but it has to be in the same place in the list.
+38Have a look at the FilenamePartExtractor transformer also
+38I ended up solving it with a PythonCaller:
def processFeature(ft):
doc_name = ft.getAttribute("Documentname")
if doc_name != None:
try:
p = doc_name.upper().index("VANDGRAF")
if p > 0:
RelDocName = doc_name[p:]
ft.setAttribute("RelDocName", unicode(RelDocName))
except:
pass
pass
pass
I ended up solving it with a PythonCaller:
def processFeature(ft):
doc_name = ft.getAttribute("Documentname")
if doc_name != None:
try:
p = doc_name.upper().index("VANDGRAF")
if p > 0:
RelDocName = doc_name[p:]
ft.setAttribute("RelDocName", unicode(RelDocName))
except:
pass
pass
pass
+44
