Grooper 23.00.0020 is available as of 5-15-2023! Check the  Downloads Discussion  for the release notes and to get the latest version.
Grooper 21.00.0073 is available as of 5-19-2023! Check the  Downloads Discussion  for the release notes and to get the latest version.

Question regarding Parsing information from a Folder Name to Populate a Field

I have a default value expression that currently Grabs the folder name on Import to populate a certain field. The default expression is this:

This gets me the 7th segment in the import path. Is there a way to parse a certain piece out of this segment?

Best Answer

  • tmartintmartin Posts: 82 ✭✭
    Answer ✓
    I spoke to several people regarding this question and came to the following solution:

    I used a calculate expression that references the field that is grabbing the folder name. 

    The structure of the folder name is:
    "Name" "4-Digit License Number" - "8-Digit Date"
    Ex: Martin, Trey 1234 - 20180525
    The Calculate Expression is as follows:

    Note: "Licensee_Name" in the expression above is the field in the content model that is grabbing the entire folder name.


  • GrooperGuruGrooperGuru Posts: 476 admin
    Yep, substring should be a good method for this use case. However, if it needed to be more dynamic, a regular expression could possibly be implemented here via .Net. I don't know the syntax though. I'm spoiled by Grooper handling that kind of thing for me. I know RegularExpression itself, but now how to access it via .Net.
    Matt Harrison
    Product Manager
    [email protected]
Sign In or Register to comment.