Solved

How to extract certain parts from path name ?

  • 22 August 2017
  • 9 replies
  • 34 views
lifalin2016
Rank
Userlevel 1
Badge +22

Hi,

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.

icon

Best answer by ebygomm 22 August 2017, 14:34

View original
-- Cheers, Lars I.

9 replies

ebygomm
Rank
Userlevel 1
Badge +21

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.

M
Badge +2

Have a look at the FilenamePartExtractor transformer also

robert_punt
Rank
Badge

You can also use an attributesplitter. Splitting on the '\\' but it has to be in the same place in the list.

lifalin2016
Rank
Userlevel 1
Badge +22

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.

Actually, I wanted the former: everything starting with "Vandgraf", or NULL if not found.

 

 

-- Cheers, Lars I.
lifalin2016
Rank
Userlevel 1
Badge +22

You can also use an attributesplitter. Splitting on the '\\' but it has to be in the same place in the list.

Alas, I can't be sure that the paths are that well-structured.

 

 

-- Cheers, Lars I.
lifalin2016
Rank
Userlevel 1
Badge +22

Have a look at the FilenamePartExtractor transformer also

I did, but it just gives me the "standard" parts of a path name, not a custom and optional part.

 

 

-- Cheers, Lars I.
lifalin2016
Rank
Userlevel 1
Badge +22

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

-- Cheers, Lars I.
lifalin2016
Rank
Userlevel 1
Badge +22

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

The try-except was necessary, as it apparently throws an exception if the substring isn't found.

 

 

-- Cheers, Lars I.
ebygomm
Rank
Userlevel 1
Badge +21
Actually, I wanted the former: everything starting with "Vandgraf", or NULL if not found.

 

 

Even easier then with regex VandGraf.+ in the string searcher

 

 

Reply


Community Stats

28,709
Posts
109,482
Replies
36,556
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.