+29Hi,
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.
+31String 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.
+6You can also use an attributesplitter. Splitting on the '\\' but it has to be in the same place in the list.
+29String 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.
+29You can also use an attributesplitter. Splitting on the '\\' but it has to be in the same place in the list.
+29Have a look at the FilenamePartExtractor transformer also
+29I 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
+31
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
